Skip to main content
P
ptc-60837981-Visitor
1-Visitor
September 22, 2014
Solved

Query items in different color

  • September 22, 2014
  • 1 reply
  • 1791 views

Hi

We want to run a query after running the query in the resultset I to show some items in different colors.

Can I do this ?

For example :

I want to Run all "Requirements Query" and to see all the records at the same time I want the Completed Requirements Should Show in Red (or any other color) or Background color should be red or Text color should be red like this I want to differ the item.

Best answer by mrump

This is not possible for query but easily done in a report (using CSS and javascript).

Furthermore it might be possible to create a "colored result table" using a chart based on that query and computation for calculating the cell background colors.

Nevertheless you can filter the resultset of an query using the "where"-clause in the gui.

HTH Matthias

1 reply

M
mrump16-PearlAnswer
16-Pearl
September 23, 2014

This is not possible for query but easily done in a report (using CSS and javascript).

Furthermore it might be possible to create a "colored result table" using a chart based on that query and computation for calculating the cell background colors.

Nevertheless you can filter the resultset of an query using the "where"-clause in the gui.

HTH Matthias

J
JoeBartlett21-Topaz I
21-Topaz I
October 7, 2014

It is also possible to export the query results to Excel and use the conditional formatting feature of Excel to accomplish this. Nothing in core Integrity to do this though.

Terms & ConditionsAccessibility statement