Hi Team,
I am applying a advanced filter on section on one of its detail let's say "Purcahse order" is the section and "PO Details" is the detail in purchase order section.
If on Purchase Order section page I will apply advanced filter on On PO Detail then only Numeric fields of PO Detail comes in drop down.
Please see the below screenshot, now here if I check the column dropdown then only numeric fields of PO detail will come why not text and lookup field of PO Details will come ?
Like
Hello Akshit,
Unfortunately, there are no basic tools to implement your business task.
We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.
Best regards,
Bogdan
Hello Akshit,
Since PO Details has a 1:many relationship with PO, you can only select fields where an aggregate is possible, meaning max, min, sum, etc. It's not possible to perform an aggregate on a text value, which is why they do not appear in that list. In order to achieve the filter you're after:
- Select "Quantity" from the list
- Then enter > 0 for the PO Details count (from #1 above)
- Now you can enter the conditions for the PO Details inside the condition of count > 0. The end result is it will look something like this:
Hope this helps.
Ryan