Hello all,
I have a use case where for a parent workflow (let's say order) I'm starting many child workflows (suborders).
There are some details which i don't want to duplicate on suborders like 'customer' for example - it should be stored only on order, but not on suborders.
In the reports i have one report for orders, second one for suborders - on suborders I'm able to show 'customer' using custom column. With SQL like this:
(
SELECT
  dbo.ClearWFElem(WFD_AttChoose2) /* Customer */
FROM 
  WFElements JOIN
  WFSteps ON WFD_STPID = STP_ID JOIN
  WorkFlows ON WF_ID = STP_WFID
WHERE 
  WF_GUID = 'af556142-7ad9-44e1-9xy2-550c2cxz361cf' AND /* GUID WF Order */
  WFD_ID = wfelems.WFD_AttChoose5_ID /* Field Order Relation */
)
This works pretty good, although i can't get a grasp how to make it work with Advanced Cell Coloring.
On Orders view, i'm using this:
{
  "children": [
    {
      "element": "span",
      "style": { 
        "color": "red"
      },
      "attributes": {
        "iconName": "=if(WFD_AttBool2 == true, 'FastForward', '')"
      }
    }
  ]
}
But on suborders there is no WFD_AttBool2 if i understand it well. 
I've tried using _12 (this is the alias of the column generated by webcon), but no luck.
Any ideas how to make it work? :)
                        
 
                                    