Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
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.
Solved! Go to Solution.
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
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
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.