[Closed] Getting object (step) names during SDK execution

0

I'm currently using this approach to access the data:
var command = $@"
SELECT STP_ID as StpId,
case
when isnull(TRANS_Name, '') = '' then STP_Name
else TRANS_Name
end[Name]
FROM
dbo.WFDefinitions
join dbo.WorkFlows on DEF_ID = WF_WFDEFID
join dbo.WFSteps on WF_ID = STP_WFID
left join
(dbo.Translates
JOIN dbo.TranslateLanguages ON dbo.Translates.TRANS_LANID = dbo.TranslateLanguages.LAN_ID and SUBSTRING(LAN_Name, 1, 2) = 'Configuration.Language')
on TRANS_OBJID = 5 and TRANS_ELEMID = STP_ID
where
DEF_ID in ({Configuration.ProcessIds})
order by STP_ID
";
var result = WebCon.WorkFlow.SDK.Tools.Data.SqlExecutionHelper.GetDataTableForSqlCommand(command,args.Context);


I don't really like the idea of hard coding the query, on the other hand I could create some data source. I would have to map the column names via configuration properties so that I can safely access them.
The only workaround would be, if I could define a template. Is this possible or has someone an alternative idea?

Best regards,
Daniel