Do not display Actions
I want to delete some rows when a condition is met but the data in my table is as follows:
The table contains: - rows where Root has values such as 1, 2, 3 etc. whose Item column is equal to the Root column value (TOPLEVEL rows) - rows where Item has values such as 1, 1.1, 1.2, 1.2.1 etc. whose Root column value is 1 (CHILD rows)
When the Invoiced column is set to Y for a TOPLEVEL row with a specific Root value, I want to delete all the CHILD rows with the same Root value.
I have defined two actions for this: 1. Delete Child rows - look for corresponding TOPLEVEL row and if it is Invoiced, delete the row 2. Delete Parent row - look for corresponding CHILD rows and if there are none (meaning all CHILD rows have been deleted,) delete the row
My question is, is this a good way to do this and will it work with no explicit action by the user?
Secondarily, as there could be a lot of CHILD rows, I am concerned about speed.
It is easy to create a slice for the CHILD rows - could you consider an action where I can say delete all rows in a slice?
Sorry, I forgot to mention that I have a workflow rule which triggers the Grouped action which includes the above mentioned two actions.
The actions are NOT being executed when the workflow rule is matching. In the audit log, I see this:
โAppTemplateNameโ: โLM-Master-179269โ,
โAppIdโ: โ9041ebe4-282a-4c87-9c40-87143bc9e843โ,
โAppTemplateVersionโ: โ1.000052โ,
โRuleNameโ: โDelete Invoicedโ,
โEventTypeโ: โChangeโ,
โOperationโ: โChange workflow ruleโ,
โRuleEvalModeโ: โProductionโ,
โTableNameโ: โOrdersโ,
โRuleTableNameโ: โOrdersโ,
โOperationUpdateModeโ: โUPDATES_ONLYโ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โ=AND(ISNOTBLANK([Invoiced]),[_THISROW_AFTER].[Invoiced]<>[_THISROW_BEFORE].[Invoiced])โ,
โMatchesConditionโ: โTrueโ,
โActionsโ: โCreated 1 Actionsโ,
โPerformanceโ: โ{โVersionโ:1,โTimeโ:โ00:00:00โ,โPerformanceTimingRootโ:{โMidโ:154,โParamsโ:{โParamListโ:[{โPidโ:13,โValueโ:โInvoice Itemsโ}]},โTimerโ:{โTimeโ:โ00:00:00โ},โChildrenโ:[]}}โ,
โResultโ: โSuccessโ
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |