0

Hi All, I have an use case as following. I need to retrieve all objects of entity A and I need to show sum of all money which is stored in cost attribute based on different filters applied by the user. There are four filters a,b,c and d. a is from date and b is to date which are attributes of A entity, there are mandatory filters users should apply. c and d are are attribute of associated entities of A, as B and C entities.   If they apply filter values on c attribute I should retrieve all the records of A entity which matches filter values of dates and c value, they can also apply filter on d attribute, how to achieve this by using OQL ?   Applying filter values on c and d attributes is not mandatory, if they apply we need to retrieve all the objects matching those filter values.   TIA

asked 2024-07-08

1 answers