I am working on a report (read only) which display all records that have any missing mandatory fields (fetch it from database)
I know that I can do it by add filter to the aggregate which check each field if it is null or empty
but I want to know if there is a way to do this once instead of check each attribute
Thank you
Hi,
Seif, I don't think there is an easier way, that filtering on each attribute.
Regards,
Daniel
Hi Seif Chowdhury,
Additional of solution proposed by Daniel Kuhlmann you can add indexes to that fields if it makes sense to improve the performance while filtering.
Hope that it helps you
Hi @Seif Chowdhury ,
only if you are dealing with very large amounts of attributes, or you need to do this reporting for several entities, it might be interesting to explore a solution where you involve the metamodel to create a custom where clause of an sql widget.
But this is a lot of extra work if you are only talking about a few entities and/or a few attributes, it wouldn't be worth it.
Dorine