I created a custom criteria and have done testing in List manager and it works just fine. However, the dropdown appears as empty whenever we try it from the criteria set builder in extraction manager. Has anyone had this issue before? Both the detail table and reference table I designated in T_KEYWORD are looking at views, if that makes a difference.
Who has permissions on those views? I suspect List Manager (being newly rebuilt) uses Tessitura_app, while Extractions, being old, probably still require Impusers?
Thanks so much! That did the trick. I had created a few other custom criteria where a local view was used in the Detail Table, but this was the first one I created using a view for the Reference Table. Just to be safe I added both Imp_users and Tessitura_app to the permissions of the view and that seem to fix the issue.
Cool. For the foreseeable future I'd go ahead and attach permissions to both users for any custom database objects.
I usually try to make a habit of that for tables and procedures, but since I don't use views very often I never think that they need permissions. But now I will make sure to keep that in mind for any object. Thanks again!