How to add conditions in Flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2022 12:47 AM
Need to delete records from sysrule_assignment table which is defined on certain conditions. Now i am using flow designer to trigger these deletions. How can i define the conditions defined in Assignment rules table to the flow so i can trigger the required deletion
i need to delete the below assignment rule from the sysrule_assignment table
- Labels:
-
flow designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2022 01:39 AM
Hi Nishant,
You can add whatever condition required based on the table you selected. In the Trigger part of flow designer add the filter conditions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2022 02:24 AM
hi Vishnu,
How can i add the conditions section of the sysrule_assignment table as below for the conditions on Flow designer:
for eg: in conditions of the assignment rule we have category, subcategory and CI fields but these are not fields on sysrule_assignment table but on incident
how do i filter them in the flow?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2022 02:41 AM
Hi,
Do you mean that when some other table/record criteria is fulfilled, you need to delete a specific sysrule_assignment record?
And the sysrule_assignment that should be deleted is based on what it contains i the conditions field?
The way to work with the conditions field, is to add "contains" conditions in flow designer. Like this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2022 05:34 AM
Hi Olan,
Yes, i need to trigger the deletion of sysrule_assignment entries based on the inputs on a Catalog item request
i am capturing the Category, Subcategory values from the user on a RITM and based on these values i am looking up these records and deleting them.
i am not sure how to put in the conditions though when triggering the deletion of the record requested based on category and subcategory