plotted dots not well alligned in a ichart type line

[Former Member]

I have an SQLTEMPLATE which outputs two columns ( Y vs X data ) . Y is flow and X is date . When I use an iChart to plot this data , the tick marks do not align properly when the time control range changes .

¿ How come ?

[erik_schrampf]

Antonio,

By nature a SQL query is not time sensitive. In order to make a SQL or Oracle query time sensitive so you can use the Time Control bar on the bottom of a chart you must make known to the query which column is your DateTime field. There are two ways of doing this depending on how you wrote the querying within MII Query editor. If you used the mode:

1. Query - The DateTime column will need to be inserted into the "Date Column" parameter under the "SQL Query Detail" tab.

2. Fixed Query - You will have to add a where clause similar to "Where DateTime between [SD] and [ED]"

Depending on what mode the query is written in you will have to modify accordingly.