Image in Power Table

Ignition
,
1

Hi, i Want to incruse a image in a cell of data of a power table, is it possible ? I have my database in Mysql and I want to based in this sentence and in the component based example such as configure cell but not colors, images of my repository. if someone can helpme please with this.

SELECT 
  CASE 
    WHEN EXISTS (
      SELECT 1 
      FROM mantenimiento.INSTRUCTIVOS_COMPONENTE 
      WHERE EQUIPO_ID_EQUIPO = '155'
    ) THEN 1
    ELSE 0
  END AS resultado;
2

Do you want the image in a Power Chart (graph) or a Power Table (table)?

If it is in a Power Table, the ConfigureCell extension function with the IconPath property is likely your best bet

3

Your question title says Power Chart. The body of the post says "power table". Which is it?
It looks like a Vision question so include the vision tag from the dropdown below your question title.

Please also see Wiki - how to post code on this forum.

Formatted query 
SELECT
  CASE
    WHEN EXISTS (
      SELECT 1
      FROM mantenimiento.INSTRUCTIVOS_COMPONENTE
      WHERE EQUIPO_ID_EQUIPO = '155'
    ) THEN 1
    ELSE 0
  END
AS resultado;
4

I want the image in a power table, I tried in the configure cell but don't works, is there any other form?

5

Where are your images stored? If they are stored in Ignition's image manager, the IconPath property in the return dictionary should work

6

In my image browser for example this is the image componentesFV.png.
Could you help me with one example how to do this with configure cell please?

7

Thanks

8 
if value == 1 :
    return {"iconPath": "componentesFV.png", "text": ""}
else :
    return {"text":""} # Don't show the 0
1 Like