Skip to main content
Skip table of contents

KPI-Object-Equipment relations

SQL
SELECT
    fc_kpi_def_equipment.id_kpi_definition AS "ID KPI Definition",
    kpi.title AS "KPI Title",
    fc_kpi_def_equipment.id_equipment AS "ID Equipment",
    eq.description AS "Equipment description",
    fc_kpi_def_equipment.id_fc_object AS "ID Object",
    ob.title AS "Object title"
    FROM fc_kpi_def_equipment
    LEFT JOIN fc_kpi_definition kpi ON kpi.id = fc_kpi_def_equipment.id_kpi_definition
    LEFT JOIN fc_object ob ON ob.id = fc_kpi_def_equipment.id_fc_object
    LEFT JOIN equipment eq ON eq.id = fc_kpi_def_equipment.id_equipment

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.