If I infer correctly, your test SQL code is not actually pulling any ‘real' data, just returning the {StartTime} and {EndTime} values for testing purposes - correct?
If so, the follow-on question becomes - what is different between the Properties of the Table and the Chart?
The next thing to check is whether there is consistent use of the Integration.EnableUtcStartAndEndTimes property for both controls:
, (@controlID, 'N', 'Integration.EnableUtcStartAndEndTimes', 'True')
From the NPC Integration Guide:
Integration.EnableUtcStartAndEndTimes
This setting is optional. The default value for this setting is false for backwards compatibility. If set to true, then UTC start and end times will be passed to the data source web service. Otherwise, the NPC server start and end times will be passed.
If this parameter is not explicitly set, ‘false' will be used and the ‘NPC server start and end times will be passed' - it appears that this might be the case for the tabular data in your example…?
Please verify these settings in the MySQL file and let us know.
Regards,
Adrian