Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Advanced query in WSRETRY Job

soumyabrata
New Contributor III
New Contributor III

Hi,

There is a requirement to exclude certain applications from wsretry job and run them separately.

So used below query and it worked fine in nonprod:

and at.ENDPOINT not in(5,10,15,20) or at.TASKTYPE in(9)

Added 'or' condition as also wanted to process update user tasks. In Nonprod it seems working fine but in Prod it not. Removed 'or' condition and it seems working fine.

So can somebody help how we can use multiple conditions to exclude certain endpoints along with tasktypes.

Regards,

Soumya.

2 REPLIES 2

nimitdave
Saviynt Employee
Saviynt Employee

@soumyabrata , not working in prod , so does it through any error in logs and does not process any tasks or its processing tasks of other endpoints but not processing only update user tasks.

you can try as below:

and (at.ENDPOINT not in(5,10,15,20) or at.TASKTYPE in(9))

Further , you can also check the logs for the actual query getting executed and use the same in data analyzer to verify the data.

rushikeshvartak
All-Star
All-Star

and (at.endpoint not in(5,10,15,20) or at.tasktype in(9))


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.