Skip to main content
M
MeghanKa
Level 2
April 12, 2021
Question

Reports - Need text mode help!

  • April 12, 2021
  • 1 reply
  • 486 views

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!

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

1 reply

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
April 12, 2021

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.

    Terms & ConditionsAccessibility statement

    Loading footer...