Hi all, We are running into issues with the Default Filter on Records

Hi all,

We are running into issues with the Default Filter on Records on 7.7. Hoping to hear some viable workarounds…

Background:
One of our record-backed case-management stye applications is approaching the limits of the # of parameters SQL Server can accept (2100 is the default). The app grown 2-3 times faster than we originally anticipated, so our plan for archiving requests after Xyears is no longer valid.

For the Record’s Default Filter, we are using the IN clause (eg. caseID IN (1,2,3...3000)). Very similar to the best practise recommended at: forum.appian.com/.../Record_Level_Security_for_Entity_Backed_Records_Best_Practice.html , (but we are not creating an Appian group per request... we can determine viewer rights based on a View we query).

Record security required:
- Requestors and Approvers can view requests that they are involved in.
- Business Admin’s can view ALL requests <<< It is here where use of the IN clause wi...

OriginalPostID-154122

OriginalPostID-154122