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? :)