Notifications
Announcements
No record found.
Is it possible to use validTimeState() in a select statement join clause? If so, what is the syntax? Where would you place the validTimeState() call?
*This post is locked for comments
Hi Steve
Take a look at download.microsoft.com/.../using_date_effective_patterns_ax2012.pdf
Here you are able to find some examples on using the validTimeState keyword in a Join.
Reading at page 30, seems that the ValidTimeState keyword can be set only on the master data source, which is the root table in a form or a query. It cannot be set on the inner/outer/exist/notexist joined child table.
Thank you.
So I guess I would need to do a separate lookup from within the "while select" loop. Is that correct?
For my particular query, I set the keyword on the root table, and it worked for the joined address table. So is that how it actually works? You can place it at the beginning and it will trickle down through the joins?
My query starts with CustInvoiceJour and ends with a join on LogisticsPostalAddress. I needed the ValidTimeState to apply to LogisticsPostalAddress, which it appears to do.
Apparently if you apply the validTimeState keyword on the root table, that time state rolls down to all the joins as well.
Yes, my understanding is that you're setting it for the query as a whole, not for individual tables.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
