Time Refresh control not getting displayed on Line chart

[Former Member]

Dear All,

I have a line chart. I ahve set

ShowTimeRefreshControl property to true using javascript.

In Javascript i am setting Date Column , Start Date, End Date

dynamically depending upon Date Column selected from list.

Code written to set above properties as follows

1 ) document.appUserChart.getQueryObject().setDateColumn(strDateColG);

2) document.appUserChart.getQueryObject().setStartDate(strStartDateG);

3) document.appUserChart.getQueryObject().setEndDate(strEndDateG);

After setting this i did document.appUserChart.updateChart(true)

After doing all these things Time Control is not getting displayed in Line chart.

Anyone please tell me what else do i need to do to display Time Control on Line Chart.

Regards,

Shalaka

[Former Member · Accepted solution]

1) Is there a date/time column assigned to the DateColumn in the query?

2) Are the [SD] and/or [ED] tokens used in the Query property for a FixedQuery?

If neither of these conditions is true, the time control will not be displayed.

[Former Member · Accepted solution]

Thanks Rick,

i have not used SD and ED earlier in fixed query so Time control was not getting displayed. Included SD and ED in fixed query and its working fine .

Thanks a lot for your help.

Regards,

Shalaka

[Former Member]

Hi all,

this might be useful for you.

Syntax to use SD and ED in a fixed query is

select * from tableName

where DateColumn between [SD] and [ED]

either SD and ED can be set in QueryTemplate under Date Range Tab or can set it through code using

document.chartapplet.getQueryObject.setStartDate(DateInXMLformat)

document.chartapplet.getQueryObject.setEndDate(DateInXMLformat)

Regards,

Shalaka

[Former Member]

Hello Shalaka,

Check the date format that is giving to its variables. For the properties StartDate and EndDate should give the dates in XML format.

I hope that the information could help.

Regards,

Marcelo Vieira