Method (GreaterThanUtcNow()) failing build & sync

(1) Share

Report

Posted on by alinawaz

209

Hello Cmmunity Experts,

I have one custom data entity which has many data sources and the parent in HcmPosition. Among first joins is HcmPositionDetails which has an outer join relation with HcmPosition.

I have added one range on the ValidTo field of HcmPositionDetails but its throwing build error afterwards.

"A local variable named '_isAnyFieldSet_' cannot be declared in this scope because it would give a different meaning to '_isAnyFieldSet_', which is already used in a parent or current scope to denote something else."

Not sure why this is the case as in the following documentation from Microsoft the method is mentioned to use for date range queries.
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options#advanced-date-queries-that-use-sysqueryrangeutil-methods

Looking forward to helpful responses :)

Best Regards.

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi alinawaz,

Are you sure the error started appearing after u added the range? so if you remove this range, would the error go?

Was this reply helpful? Yes No
alinawaz 209 on at

Like (0)

Report
Copy link

Link copied!

Yes that Error started appearing only after I added the range on HcmPositionDetail Datasource.

Plus, when I add the same range on the Data entity's range node, there is no build or sync error but the range isn't working either. Checked the data in SQL.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

Check similar issue on here.

https://community.dynamics.com/forums/thread/details/?threadid=60d94870-e97d-4869-825e-211ca6343339

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,634 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

What you're trying to do is logically wrong, therefore if you get rid of the error, it still won't to do what you want.

A data entity is a SQL view in the database. The view can't connect to F&O and execute X++ code, including greaterThanUtcNow() function. It simply can't work. The only thing you could get is getting greaterThanUtcNow() executed on DB sync, therefore the time of the DB sync would be hard-coded in the entity definition. It wouldn't use the current date time when querying the data.

Date-effective data entities require a different approach. Please refer to F&O documentation (Date effectivity) for details.

Was this reply helpful? Yes No
Verified answer

alinawaz 209 on at

Like (1)

Report
Copy link

Link copied!

Changing the join type to Inner Join from Outer join has resolved the problem.

Build and Sync is successful, plus the range is also applied.

Thanks guys :)

Cheers

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

Like (1)

Report
Copy link

Link copied!

The range is applied, but is the range value correct? I still expect a hard-coded value, which isn't what you wanted. Please look at the actual view in SSMS to see what you've generated. That the view gave you the correct result at that moment doesn't mean that it'll be correct tomorrow.

Was this reply helpful? Yes No