From Date and To date

[shravan.pitla]

Please help me,
I am trying to filter the data based on from date and to date.
Please check the bellow filter condition and my query
after adding the filter condition the data is not showing in the report.
(userstat.actiondate >= fromdate) && (userstat.actiondate <= todate)
{userstat}select distinct time_stamp as actiondate,user_name as username ,event_description as action,event_name as actiontype from dm_audittrail where event_name in ('dm_connect','dm_disconnect','d2_connect') and user_name not in ( 'dm_bof_registry','DCTM Reports','d2_mail_method' ) and user_name not like 'dm\_%' ESCAPE '\' and user_name not like 'd2\_%' ESCAPE '\' and user_name not like 'c2\_%' ESCAPE '\' and (string_1 in ('inline password','ldap','OS password') or event_description='Logoff' ) and user_name is not nullstring order by time_stamp desc ENABLE(RETURN_TOP 1000);

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[shravan.pitla]

Hi Thanks for the replay,

Please find the sample report and help me please.

[Lech Kulikowski]

Hello,

Please send us a test data for your report.

Thank you.

[shravan.pitla]

Hi,

Please find the test data for reference, its showing only 100 rows
Do i need to do anything related to browser like cache.

[Lech Kulikowski]

Hello,

It is not possible to use word document as data in your report.

Please send us a sample that reroduces the issue for anlaysis.

Thank you.

[shravan.pitla]

How to send test data, which format is needed to test the data, can you please explain so i will send you according to you

[Lech Kulikowski]

Hello,

Any format - XML, JSON, etc, that we can use in your report and reproduce the issue.

Thank you.

[shravan.pitla]

Please find the sample data and help me

[shravan.pitla]

Please find the sample data and help me