ValidTimeStateFieldType

Finance and Operations/AX Developer Forum
1

Okay, in our database we have a table with a ValidTimeStateFieldType value of ‘Date’ in the table’s properties. So in this table, it has a ValidTo and ValidFrom date that will filter automatically based on the date, so if the values are outside the current date, the record will not show up on the grid on my form. If I manually update the ValidTo date on the record in the table so it is greater than today’s date, it will then show up in my grid.

I’ve looked online and found stuff related to report queries, but can’t find anything on forms. I basically want to override the validation on these fields so all records will show regardless of the ValidFrom and ValidTo date range. I have a plain form with one grid where the data is based off a query that consists of several tables including the one that has this ValidTimeStateFieldType property value set. There’s nothing complicated about it, it’s just that I don’t know how to adjust the query so it won’t look at the valid dates when pulling data to populate my grid.

Can someone help me out?

2

Change ValidTimeStateAutoQuery property of the form data source to DateRange.

3

That was easy! I knew there had to be something…thanks a lot!

4

Everything I’ve read about that said it should work, but I updated the property on the datasource and it still won’t display, however if I manually update the ValidTo date in the table to today’s date or greater it will then show up in my grid?

5

I actually tested my answer and it works. Please try it at a trivial example - maybe the data is filtered out by something else in the form you’re currently using.