Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
11 subscribers
Views
1318 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
#DefaultFilters I am creating an entity backed record type with default filters
georgeu
over 8 years ago
#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
0
Chris
over 8 years ago
Unfortunately other than the 'best practice' group method as Stefan mentions above, you have found the only way to work that type of security into entity-backed records. As performance is not very good with the 'IN' operator (and best practice is only recommended for < 100 groups per user), we've moved to service-backed records with data via queryEntity(). There is an enhancement being tracked under AN-60876 to allowing record filters to be expressionable and dynamic.
Here are a few other threads on the topic as well:
forum.appian.com/.../e-191793
forum.appian.com/.../e-155229
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Chris
over 8 years ago
Unfortunately other than the 'best practice' group method as Stefan mentions above, you have found the only way to work that type of security into entity-backed records. As performance is not very good with the 'IN' operator (and best practice is only recommended for < 100 groups per user), we've moved to service-backed records with data via queryEntity(). There is an enhancement being tracked under AN-60876 to allowing record filters to be expressionable and dynamic.
Here are a few other threads on the topic as well:
forum.appian.com/.../e-191793
forum.appian.com/.../e-155229
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data