Hi There,
I need to highlight font color of column values in interactive grid based on the below condition:
Highlight font color of Column A when the value is not equal to the value of Column B.
Dynamic action created on the column A, event - change, where client side condition given as Col A != Col B
True action : set style, Style Name: color, Value: red.
When I am running the page it is highlighting when I click to change the value of particular cell. When I don't select the particular cell It shows it's original font color rather than showing red in color even though the condition satisfies.
Vinish Kapoor
If your interactive grid source is SQL query then fine else change it to SQL query and modify the query as below:
The above SQL query will add one more column acolor, set this column as a hidden column.
Then set the following HTML expression property for column A:
Now on the IG load, it will take the effect.
You can keep your dynamic action as is.
aadeeaan
If I select column A type as HTML expression and provide the above given HTML code then col became display only ,we don't have an option to edit this col. in the intractive report.The column A should be editable plus highlighted based on the above given condition. Whatever new value we enter that also check whether it is equal to the col B value or not and change the font color accordingly.
aadeeaan
Hi Vinish,
What I noticed now dynamic action without submitting the page is not working as expected. It is an editable Interactive GRID and whenever we change the value of column A it should check whether the value is matching with column B or not, If it doesn't match then it should change font color of that value without submitting or refreshing the page.
Could you please suggest what client side condition I can give. Item/column value = value (col A = :col B) condition is not working as expected.
Vinish Kapoor
Your client-side condition should be Item/Column (A) value Not equal to B.
aadeeaan
Yes,it is like that colA!= colB.it was a typo. But this approach is not working.