Workflow "IF" on requested items in Service catalog request wont work

Jess Larsen1
Tera Expert

Hi.

 

We have a normal workflow that validates on recurringPrice on the entire request and it´s gathered from sc_recurring_rollup table. This all works, but I have a new challange where one item can have skip all approvals with a code set at 999 in this field: u_skip_approval_code on the table sc_cat_item. 

 

I have tried multiple sollutions and it keeps failing on this when I test. 

If I have more items in the same request and just one does not have the code it should NOT skip the approval part. But if it is the only item or all items ordered have the skip code then it should skip require approval. 

 

No matter how I build the if sorting it either says true to requires approval on all or skips it on all. 

 

Can someone tell me how this can be solved?

 

Best Regards

Jess

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Jess Larsen1 

I dont have answer for this, but commenting to bring back this issue in cycle to get reply from other.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi Kilo Patron

 

Do you have a suggestion for this, I´m not sure what the comment was about if it was to make the post more seen and it was added 4 minutes after the post was made. 

 

Best Regards

Jess

Yes @Jess Larsen1 

 

Purpose to bring this post in visibility again.

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************