Is there a way to create a status column rule on a report for requests that are pending approval?
I've put in the status rule which equals the status' i want to be highlighted yellow, but how do only the status' that are PENDING THE APPROVAL come up highlighted? I cant' find the option
Screenshot attached
Solved! Go to Solution.
Views
Replies
Total Likes
Hi,
I can see that there are four statuses used in this formatting rule. Should all of them appear in orange when pending approval? If yes, you will need to append ":A" to all of the status codes, so the line of code would look like this:
styledef.case.0.comparison.righttext=HFA:A WJL:A EQB:A VRI:A
Please note that there should be a tab inbetween each status code i.e., HFA:A <tab> WJL:A etc.
Best Regards,
Rich.
Views
Replies
Total Likes
Hi,
You'll need a little text mode to achieve this, but it can be done by following these steps:
(1) Go into the report editor, select the status column, then advanced settings and add your formatting rules for the "Compliance request Check" status.
(2) Once your formatting is added, switch to text mode and find the line of code that reads:
styledef.case.0.comparison.righttext=INP
In my code above I have used the "In Progress" status, that has a key of "INP". Yours will have a different key, whatever you set the key as for the "Compliance request Check status"
(3) Add ":A" to the end of the status key (which stands for awaiting approval) and click save. So in my example, the code would look like this:
styledef.case.0.comparison.righttext=INP:A
(4) Save and close the report and you should now find that any requests in "Compliance request Check - Pending Approval" status are formatted per the rules you set earlier.
Hope this helps!
Best Regards,
Rich.
Views
Replies
Total Likes
Thanks so much for this helpful breakdown, Rich.
I've followed your steps but it doesn't pull through on my report.
Have I done it correctly? Screenshots attached.
Views
Replies
Total Likes
Hi,
I can see that there are four statuses used in this formatting rule. Should all of them appear in orange when pending approval? If yes, you will need to append ":A" to all of the status codes, so the line of code would look like this:
styledef.case.0.comparison.righttext=HFA:A WJL:A EQB:A VRI:A
Please note that there should be a tab inbetween each status code i.e., HFA:A <tab> WJL:A etc.
Best Regards,
Rich.
Views
Replies
Total Likes
That worked!! Thanks as always Rich!
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies