comparing array values using 'in' operator in Saviynt runtime analytics.

[Anurag]

Hi Team,

We have a requirement to send and compare multiple values through runtime analytics.

we are trying to create analytics query like below using in operator but it does not compare all the items sent.

select campaignkey from certification where certkey in (67,23,32,42)

select campaignkey from certification where certkey in $'({CERTKEY})'

is there any way to create an analytics where we can compare a column with list of data?

[rushikeshvartak]

Use find_in_set

[Anurag]

Hi Rushikesh,

Thanks for your response.

Can you please share a sample query or point to documentation link, I tried using find_in_set and selected attribute type as string(other types required some default values) getting blank dialog box as error on preview.

select campaignkey from certification where certkey find_in_set $'{CERTKEY}' --blank dialog box as error on preview

select campaignkey from certification where certkey find_in_set $'[CERTKEY]' --preview does not work and on create button the web page goes in indefinite loading state.

[rushikeshvartak]

https://www.w3schools.com/sql/func_mysql_find_in_set.asp

[Anurag]

find_in_set function won't work for our use case.

we will be sending multiple cert keys from our code, and from analytics we will need to return the certifications for all these cert keys.
Analytics should be able to receive this list of cert keys for comparison.

[rushikeshvartak · Accepted solution]

select campaignkey from certification where certkey in (${CERTKEY})