1
Automation Interface, Add-Ins and Tools / Re: Custom SQL Query passing EAGUID or Scenario?
« on: December 21, 2023, 09:40:49 pm »
Not even when the 'Scenario' checkbox is enabled within the template?
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
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)
You need to create relations one after the other.
q.