#DefaultFilters I am creating an entity backed record type with default filters

#DefaultFilters I am creating an entity backed record type with default filters for security reasons. The database has three columns for three different types of users associated with each item. I am trying to create a default filter so that items can only be seen in the list view by those three users. Meaning I would like to "OR" the default filters, one for each column, but "AND" is the only option. My current workaround is to create a query entity that will pull back all of the IDs where the logged in user is listed in any of those three columns. In the default filters I compare the record ID with those returned in the rule with the "IN" operator. This works, but it is obviously more resource intensive than it needs to be. Does anyone know of a better way?

OriginalPostID-195196

OriginalPostID-195196

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data