Hi,
Is there way to compare List and Reference field values in GlideAggregate query it self.
We had list type field called “Products” in that we had multiple selections. Ex: Monitor, Computer, Docking station, Keyboard etc
We had Refence field called “Product” and it is single selection. Ex: Computer
Both fields are in different tables but we combine them using Database views.
So in the script (GlideAggregate) we want to validate Product field value is part of Products field values. That way we will get count. I tried ga.addQuery(‘product’,’CONTAINS’,’products’); but it doesn’t work.
Any suggestions
