Is there any limitation on length of Access query in Saviynt

[yogendragautam]

MyCWT endpoint access query modification:

• The current setup in Saviynt entails that ‘MyCWT’ will only be visible in Saviynt if the Country Code (CustomProperty8) of the Requestee at Passport identity level equal ‘FR’.
• This is managed via the Endpoint access query:

• WHERE  '${requestee.companyname}' != 'AAA B2B Users' AND '${requestee.customproperty8}' = 'FR'

• Now our requirement is that users from the following countries listed below will need to be included in the condition on the visibility of the application in Saviynt on Requestee Country Code.
• This would entail the modification of the Endpoint access query in Production:

• WHERE  '${requestee.companyname}' != 'AAA B2B Users' AND '${requestee.customproperty8}' in ('FR','ES','PL','UK','MX','CA','US','IN')

• Please confirm on above can we add above country in Access query,
• and If  list continues to extend, limitation on length of Access query in Saviynt can create any issue?
• Is there any limitation on this?

[pmahalle]

Hi @yogendragautam ,

Access Query stores in endpoints table and the size of the field accessquery is 255. I don’t think you can put query of size more than that. 

ACCESSQUERY

accessquery

varchar(255)

Indicates the attributes used to raise access queries to endpoints.

[rushikeshvartak · Accepted solution]

In your current version v5.5 limit is 255 characters.

In v23.x onwards Access Query size is longtext.