Solved

Highlight task in report

Forum|Forum|5 years ago
August 6, 2020
3 replies
1455 views

I have a report where i need to call attention to "late" completed tasks but can't quite seem to get it right. I want to highlight the row when the Last Update Date is later than the Plan Start. See the image.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by LinnieCi

Hi Michelle and Kyna,

The code in my presentation is a little different (it flags tasks as "late" while taking the handoff date into account). But, here is code that should solve Michelle's issue. You can paste it into one of the columns you are comparing. I created most of this using the conditional formatting tools in the report builder, and made a few tweaks in text mode:

linkedname=direct

namekey=lastUpdateDate

querysort=lastUpdateDate

row.0.styledef.applyallcases=true

row.0.styledef.case.0.comparison.icon=false

row.0.styledef.case.0.comparison.isrowcase=true

row.0.styledef.case.0.comparison.leftmethod=lastUpdateDate

row.0.styledef.case.0.comparison.lefttext=lastUpdateDate

row.0.styledef.case.0.comparison.operator=lt

row.0.styledef.case.0.comparison.operatortype=date

row.0.styledef.case.0.comparison.rightmethod=plannedStartDate

row.0.styledef.case.0.comparison.righttext=plannedStartDate

row.0.styledef.case.0.comparison.trueproperty.0.name=textcolor

row.0.styledef.case.0.comparison.trueproperty.0.value=000000

row.0.styledef.case.0.comparison.trueproperty.1.name=bgcolor

row.0.styledef.case.0.comparison.trueproperty.1.value=eac6c9

row.0.styledef.case.0.comparison.truetext=

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.isrowcase=true

styledef.case.0.comparison.leftmethod=lastUpdateDate

styledef.case.0.comparison.lefttext=lastUpdateDate

styledef.case.0.comparison.operator=lt

styledef.case.0.comparison.operatortype=date

styledef.case.0.comparison.rightmethod=plannedStartDate

styledef.case.0.comparison.righttext=plannedStartDate

styledef.case.0.comparison.trueproperty.0.name=textcolor

styledef.case.0.comparison.trueproperty.0.value=000000

styledef.case.0.comparison.trueproperty.1.name=bgcolor

styledef.case.0.comparison.trueproperty.1.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=lastUpdateDate

valueformat=atDate

This article is a great resource for conditional formatting and text mode: https://one.workfront.com/s/article/Comparing-Fields-in-Conditional-Formatting-1413809645

Hope that helps!

kynabaker16

Adobe Employee

Hi Michelle,

I know that in @Linnie Ciepielowski‚ 's Leap session she shared some great text mode to display the "Early, Late or On Time Tasks" in a report - maybe she has some great tips for you as they relate to this report ‚Äîor you can find what you need in her Leap session.

Just an idea!

Thanks,

Kyna

L

LinnieCiAccepted solution

Hi Michelle and Kyna,

The code in my presentation is a little different (it flags tasks as "late" while taking the handoff date into account). But, here is code that should solve Michelle's issue. You can paste it into one of the columns you are comparing. I created most of this using the conditional formatting tools in the report builder, and made a few tweaks in text mode:

linkedname=direct

namekey=lastUpdateDate

querysort=lastUpdateDate

row.0.styledef.applyallcases=true

row.0.styledef.case.0.comparison.icon=false

row.0.styledef.case.0.comparison.isrowcase=true

row.0.styledef.case.0.comparison.leftmethod=lastUpdateDate

row.0.styledef.case.0.comparison.lefttext=lastUpdateDate

row.0.styledef.case.0.comparison.operator=lt

row.0.styledef.case.0.comparison.operatortype=date

row.0.styledef.case.0.comparison.rightmethod=plannedStartDate

row.0.styledef.case.0.comparison.righttext=plannedStartDate

row.0.styledef.case.0.comparison.trueproperty.0.name=textcolor

row.0.styledef.case.0.comparison.trueproperty.0.value=000000

row.0.styledef.case.0.comparison.trueproperty.1.name=bgcolor

row.0.styledef.case.0.comparison.trueproperty.1.value=eac6c9

row.0.styledef.case.0.comparison.truetext=

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.isrowcase=true

styledef.case.0.comparison.leftmethod=lastUpdateDate

styledef.case.0.comparison.lefttext=lastUpdateDate

styledef.case.0.comparison.operator=lt

styledef.case.0.comparison.operatortype=date

styledef.case.0.comparison.rightmethod=plannedStartDate

styledef.case.0.comparison.righttext=plannedStartDate

styledef.case.0.comparison.trueproperty.0.name=textcolor

styledef.case.0.comparison.trueproperty.0.value=000000

styledef.case.0.comparison.trueproperty.1.name=bgcolor

styledef.case.0.comparison.trueproperty.1.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=lastUpdateDate

valueformat=atDate

This article is a great resource for conditional formatting and text mode: https://one.workfront.com/s/article/Comparing-Fields-in-Conditional-Formatting-1413809645

Hope that helps!

Kundanism

Hei Linnie

I also tried the above works great. Also I tried to modify the above text code to know the last update done by with user id, please check;

linkedname=direct

namekey=lastUpdatedBy

querysort=lastUpdatedBy

row.0.styledef.applyallcases=true

row.0.styledef.case.0.comparison.icon=false

row.0.styledef.case.0.comparison.isrowcase=true

row.0.styledef.case.0.comparison.leftmethod=lastUpdatedBy

row.0.styledef.case.0.comparison.lefttext=lastUpdatedBy

row.0.styledef.case.0.comparison.operator=lt

row.0.styledef.case.0.comparison.operatortype=name

row.0.styledef.case.0.comparison.rightmethod=plannedStartDate

row.0.styledef.case.0.comparison.righttext=plannedStartDate

row.0.styledef.case.0.comparison.trueproperty.0.name=textcolor

row.0.styledef.case.0.comparison.trueproperty.0.value=000000

row.0.styledef.case.0.comparison.trueproperty.1.name=bgcolor

row.0.styledef.case.0.comparison.trueproperty.1.value=eac6c9

row.0.styledef.case.0.comparison.truetext=

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.isrowcase=true

styledef.case.0.comparison.leftmethod=lastUpdatedBy

styledef.case.0.comparison.lefttext=lastUpdatedBy

styledef.case.0.comparison.operator=lt

styledef.case.0.comparison.operatortype=name

styledef.case.0.comparison.rightmethod=plannedStartDate

styledef.case.0.comparison.righttext=plannedStartDate

styledef.case.0.comparison.trueproperty.0.name=textcolor

styledef.case.0.comparison.trueproperty.0.value=000000

styledef.case.0.comparison.trueproperty.1.name=bgcolor

styledef.case.0.comparison.trueproperty.1.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=lastUpdatedBy

valueformat=name

Best regards,

Kundan.

L

LinnieCi

Hi Kundan, you may have better luck by comparing the plannedStartDate field to the lastNote:entryDate field (if you're looking for when the last note text was entered) or the lastUpdateDate field, as opposed to lastUpdatedBy.

kynabaker16

Adobe Employee

Ah! Well, at least you had something that could help! Thank you so much for sharing, Linnie!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded