CreatedDateTime filter is not working on WorkflowTrackingStatusTable table

(0) Share

Report

Posted on by Akbar Pasha

1,542

Hi All,

I need to filter the data on “WorkflowTrackingStatusTable” on createddate time , date is getting from parameters using Transdate.

Written the code below for the same:

WorkflowTrackingStatusTable wftst;

fromDate = coming from parameters(parmFromDate)
todate = coming from parameters(parmToDate)

utcFromDateTime = DateTimeUtil::newDateTime(fromDate,0);
utcToDateTime = DateTimeUtil::newDateTime(todate,86400);

while select CreatedDateTime from wftst
where wftst.CreatedDateTime > utcFromDateTime
&& wftst.CreatedDateTime < utcToDateTime

{

}

The above code is getting out of the control, it is not going inside the loop.

Is there anything missing in the code, please advice.

Regards,

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 240,171 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It must mean that there is no record for your parameters. What values do you have in fromDate and toDate variables? What record do you expect to meet the criteria?
I suggest you copy the actual SQL code generated from your X++ code and execute it directly against the database. This will ensure you work with the actual database data, which may be different from what you see in GUI (e.g. because of timezones) or what you expect to be produced by your code.

Was this reply helpful? Yes No
Akbar Pasha 1,542 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,
Fromdate is having ‘07/01/2025’ (1st July 2025)
Todate → '07/31/2025' (31st July 2025)

Records does exists for (07/04/2025) it is coming as 4th July 2025 - which is coming as 04/07/2025 when commented the fromdatetime and todatetime filter.

Was this reply helpful? Yes No
Martin Dráb 240,171 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Now get the actual SQL code:
select generateOnly forceLiterals CreatedDateTime from wftst
where wftst.CreatedDateTime > utcFromDateTime
&& wftst.CreatedDateTime < utcToDateTime;
info(wftst.getSqlStatement());
share it with us and test it against your database.

Was this reply helpful? Yes No