Share
Report
70Hello there,
I was wondering what is the best practice around Data Entity Field Value filtering or Range in D365 F&O. I have requirements as follows:
- We currently have a custom Data entity (based on total custom tables) and in the primary data source table, we have one Datetime column (i.e. Reading DateTime). So, Data entity should give records related to the 'latest 3 reading records' from that main source table.
Like for example, for a given combination of Lab#, Instrument#, Item# we can have several 'Reading DateTime records'. But we need to show/export only the latest 3 out of those.
- Que is, should we create a data entity method (new method or override existing method) for this? If we can get some direction here.
- Another question is, there is 'range' and 'having' node of the Data source. Can we leverage that? i.e. How should we fill out the Value property - like does it take >today()-7 or something?
Thank you in advance.
I have the same question (0)
All responses (
Answers (
