Home > Forum > Rules, JS, SQL > Reports Advanced Cell Coloring - Custom column

Reports Advanced Cell Coloring - Custom column
0

MVP

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

MVP

Another day, fresh mind, and I've found a way in some older reports, in this case i was able to use 'CurrentField' instead of 'AttributeName' in Advanced Cell Coloring, so ended up like this:

{
"children": [
{
"element": "span",
"style": {
"color": "red"
},
"attributes": {
"iconName": "=if(CurrentField == 'Tak', 'FastForward', '')"
}
}
]
}

I'm leaving thread open though, as maybe someone will know a way how to reference other custom columns which might come handy someday :)

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings