Hello everyone, Does anyone know how to change the background color of a specific cell (follow some condition) of the component “Table” in Perspective via a script ? I have a componant Table (data binded to a NameQuery Dataset). I would like to change the background color of some cell (follow my c…

[image] Miguel_Villasenor_Es: Can I populate the table via a button and then use a binding on the data property? You usually do one or the other, not both. If you want something similar to what was originally asked, then you can use what was already explained. If it's not enough, you'll hav…

They're using a binding and then a transform to get their desired results correct? If so I'll try it that way and here's what I have so far: I have a named query that runs with 1 parameter. That is bound to the data property on the table. The table gets populated. So I just need to add the trans…

I've been at it for a few days and I don't understand.. :confused: [image] What should I do so the cell in the Status column become stylized based on their value.

Let's say your query returns a table that looks like this: name value foo 1 bar 2 pox 3 wuz 4 First thing to do is change the return type to json instead of auto, since we're gonna work with json and not datasets. It should look like this: ▶ data returned by the query We want to a…

I copy pasted your code and made some modifications to it and I get this error: line 2, in transform TypeError:'..........................." Object is not iterable return [dict(row, **{'style': {'color': "green" if row['value'] == "Old" else "red" }}) for row in value] [image] I really want thi…

[image] Miguel_Villasenor_Es: line 2, in transform TypeError:'..........................." Object is not iterable You missed something: [image] pascal.fragnoud: First thing to do is change the return type to json instead of auto [image]

You know, I actually had it as Json at first but it was giving me the non-itterable error. I tried it again and it was no longer there. However, now it's throwing a KeyError:value :upside_down_face:

[image] pascal.fragnoud: { 'name': "bar", 'value': 2, 'style': { 'color': "red" } }, this is not correct you would want { 'value':{ 'name': "bar", 'value': 2 }, 'style': { 'color': "red" } },

[image] Miguel_Villasenor_Es: KeyError:value he made this asuming the coljumn named "value" was a thing [image] Miguel_Villasenor_Es: query = "SELECT Val1 as Asset, Val2 as Sheet, Val3 as Title, Rev, Status, Path, Val6 as Vendor, Val7 as Category, FileNameModified, ID FROM ProductionData…

I always get lost in the table's formats :X

Change style of cell (component Table) via script - Perspective

Ignition

pascal.fragnoud February 28, 2024, 2:43pm 24

You missed something: