Reports - Need text mode help!

Question

I have a report that shows me the planned completion date of an issue (in 1 column) and the resolving task planned completion date in another column.

We use this report to compare the 2 dates and will adjust them accordingly.

Can someone please provide me the text to format the Issue Planned Completion Date as red and bold if it is not equal to the resolving task planned completion date?

TIA!

Richard_Le_ · Answer

Hi Meghan,

The below text mode should do it on an issue report.

displayname=

linkedname=direct

namekey=plannedCompletionDate

querysort=plannedCompletionDate

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.leftmethod=plannedCompletionDate

styledef.case.0.comparison.lefttext=plannedCompletionDate

styledef.case.0.comparison.operator=ne

styledef.case.0.comparison.operatortype=date

styledef.case.0.comparison.rightmethod=resolveTask:plannedCompletionDate

styledef.case.0.comparison.righttext=resolveTask:plannedCompletionDate

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

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

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

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

styledef.case.0.comparison.truetext=

textmode=true

valuefield=plannedCompletionDate

valueformat=atDate

One thing to point out is that the comparison between the two dates will also take into consideration the time. So if the planned completion date of the issue is 12th April at 9:00am, and the planned completion date of the task is 12th April at 9:01am, this will still highlight in red.

Best Regards,

Rich.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded