QFQ

{

    "tableName": "MaAgreement",

    "recordLockTimeoutSeconds": 900,

    "FormElement_ff": [

        {

            "name": "grIdTrackDecisionStage",

            "label": "Instanz",

            "type": "select",

            "ord": 10,

            "tabindex": 0,

            "sql1": "{{! SELECT grC.id AS id, grC.name AS label\r\n           FROM Ggroup AS grC, Ggroup AS grP, Ggroup AS grT\r\n           WHERE grP.id = grC.grId\r\n             AND grP.reference = 'mef_role_ma_track'\r\n           GROUP BY grC.id\r\n}}",

            "parameter": "emptyItemAtStart"

        },

        {

            "name": "instanzName",

            "label": "Name",

            "mode": "readonly",

            "ord": 20,

            "tabindex": 0,

            "note": "{{ SELECT name FROM Ggroup WHERE id = {{grIdTrackDecisionStage:R0}} AND EXISTS (SELECT name FROM Ggroup WHERE id = {{grIdTrackDecisionStage:R0}} ) }}",

            "value": "{{ SELECT name FROM Ggroup WHERE id = {{grIdTrackDecisionStage:R0}} AND EXISTS (SELECT name FROM Ggroup WHERE id = {{grIdTrackDecisionStage:R0}} ) }}"

        },

        {

            "name": "query",

            "label": "Query",

            "type": "note",

            "ord": 30,

            "tabindex": 0,

            "value": "SELECT name FROM Ggroup WHERE id = {{grIdTrackDecisionStage:R0}} AND EXISTS (SELECT name FROM Ggroup WHERE id = {{grIdTrackDecisionStage:R0}})"

        }

    ]

}