Custom SQL Query passing EAGUID or Scenario?

[meeert]

Hi,

I'm trying to access the EAGUID to filter per scenario in a way like the #OBJECTID# is being passed in SQL within Templates.

Code: [Select]

SELECT
a.step.value('@level', 'NVARCHAR(MAX)') AS 'step',
a.step.value('@name', 'NVARCHAR(MAX)') AS 'action',
a.step.value('@result', 'NVARCHAR(MAX)') as result,
a.step.value('@uses', 'NVARCHAR(MAX)') as comment
FROM
(SELECT CAST(XMLContent AS XML) AS Content FROM t_objectscenarios WHERE Object_ID = #OBJECTID# ???AND ea_guid = #EAGUID#???) s
CROSS APPLY Content.nodes('/path/step') a (step)
Is there a way to pass the EAGUID within a custom query (template)? OR Scenario name with SQL? Or should I use a custom script to get the desired result?

[Geert Bellekens]

No, fragments are executed per object, not per scenario.

Geert

[meeert]

Not even when the 'Scenario' checkbox is enabled within the template?

[Geert Bellekens]

Not even when the 'Scenario' checkbox is enabled within the template?

No, doesn't matter. The only parameter your fragment is getting is the object ID

Geert