
Hello
I have two dataverse Tables named "asset" and "inventory" with a 1:N relationship.
Now I would like to create a view, that shows all assets:
- that do not exist in the inventory table
or
- that exists in the inventory table but the inventory date is not in this year
Does anyone have an idea how to apply the filter?
Regards,
Roland
Hello
It seems that it is not possible to solve my requirement using the view's filter only.
I managed to find a solution. I have added a 'inventory taken' table and I store all assets on which inventory was taken for the year. The table will be cleaned end of the year after inventory was made.
I then can simply add a relation from asset to inventory taken and show all assets that are not in inventory taken.
Regards,
Roland