Hi there, @doug1… with the way you have your data types set up, you would have to use an advanced filter to get the list of concepts where all of their assets are approved. Here is an example where an option set is used for the approval statuses.
Note that the Search for Concepts doesn’t have any constraints on it, and that is actually one of the downsides here from a performance perspective because advanced filters happen on the client (browser) side. So, the search is going to return all of the items in the Concept data type to the browser, and then the filter will be applied. Oh, and here is the filter that is part of the advanced filter.
If you want to avoid using an advanced filter, you could do what you said and have a status on the concept that changes when all of the concept’s assets have been approved. I’m not going to go down that path in this response, but you could consider it if the advanced filter is not performant.
Hope this helps.
Best…
Mike
2 Likes
Forum
Academy
Marketplace
Showcase
Pricing
Features
