We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Extracting count of Application accounts in workflow through if-else condition block

sukoor
New Contributor
New Contributor

Hi, 

We have a requirement to get one of the Application Active account count from Accounts table in if else condition block in Workflow.We are unable to submit the enable request in ARS by using below custom Query in if else condition block in Workflow Error details in below screen shot.

(com.saviynt.ecm.identitywarehouse.domain.Accounts.executeQuery("select count(a.name) from accounts a where status IN (1 ,'Manually Provisioned') and endpointkey=115 and customproperty6 in ("00e57000001pFNMAA2","00eD0000001QmngIAC","00eD0000001o8S4IAI","00eD0000001o8RpIAI","00eD0000001o8RuIAI","00e2o0000028PBQAA2","00eD0000001o8RzIAI")") < 1000)

If else block in workflow

sukoor_1-1699539044118.png

 

 

Error:

sukoor_0-1699538874142.png

 

Any other ways to get the count of accounts in If else block

Appreciate any suggestions in this regard.

4 REPLIES 4

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @sukoor,

We are checking on this and we will keep you posted.

DixshantValecha
Saviynt Employee
Saviynt Employee

Hi @sukoor,

I understand that you are trying to get the count of active accounts from the Accounts table in an if-else condition block in Workflow, but you are unable to submit the enable request in ARS due to an error.

The error message you provided indicates that there is a syntax error in your custom query. Specifically, the issue seems to be with the use of double quotes inside the query string. You can try replacing the double quotes inside the query string with single quotes to fix the syntax error.

Here’s an updated version of your query with single quotes:

(com.saviynt.ecm.identitywarehouse.domain.Accounts.executeQuery("select count(a.name) from accounts a where status IN (1 ,'Manually Provisioned') and endpointkey=115 and customproperty6 in ('00e57000001pFNMAA2','00eD0000001QmngIAC','00eD0000001o8S4IAI','00eD0000001o8RpIAI','00eD0000001o8RuIAI','00e2o0000028PBQAA2','00eD0000001o8RzIAI')") < 1000)

Regarding your question about other ways to get the count of accounts in an if-else block,you can refer to the Saviynt documentation.

sukoor
New Contributor
New Contributor

Thank you DixshantValecha for your response.

I tried with above given custom query , but still the same error message as shown below

sukoor_0-1700550424281.png

Tried searching in below Saviynt documentation for Workflow Components , but didn't get related content.

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter12-Workflows/Workflow-Compon...

If you had anything more in Saviynt documentation related to Workflow if else block, please post it here.

Regards

Abdul Sukoor

DixshantValecha
Saviynt Employee
Saviynt Employee