Hi Priya,
For distict and some other operation you can also use my published module
also it doesnt need committed objects as well
https://marketplace.mendix.com/link/component/222662
just pass the list and name of attribute 'region'
Coming to your question in same microflow you are deleting and committing, so somewhere objects are not yet in database because microflow is still not complete and non empty list is still in memory
but without removing emoty objects and all try this
SELECT DISTINCT region FROM MyFirstModule.RegionFiltersWHERE region IS NOT NULL AND region != ''
this query will only take account non empty objects
Good luck!
Hi ,
can you paste screeshot of errors and microflow