Description

I'd like to extract transaction/query list associated with workflow solutions from Evolve.

Table view 'RPT_SolutionView' provides good information about standalone scripts and queries, however it doesn't show the ones imported in a solution.

Could you advise if we can get it from a table or about the method it is stored?

Applies To

20x

Solution/Immediate Workaround

You can achieve this by using the below query this information Recite in table TransationROI View and QueryROI view; Runtype determines whether the script is run in form or Studio.Below is example of Query Script.

select [AppGroupView].Appname AS Appname,[SolutionView].title AS Title,QueryRoiView.RunType AS RunType,QueryRoiView.QueryFileName AS QueryFileName,
QueryRoiView.SAPUser AS SAPUser,
QueryRoiView.SAPSystem AS SAPSystem,QueryRoiView.NumberOfRecords AS NumberOfRecords,
QueryRoiView.TimeToExecute AS TimeToExecute, QueryRoiView.TablesUsed AS TablesUsed,
QueryRoiView.OutputFields AS OutputFields,
QueryRoiView.DateTimeOfRun AS DateTimeOfRun, QueryRoiView.Username AS Username from RPT_QueryRoiView AS [QueryRoiView]
join RPT_SolutionView AS [SolutionView]
ON [QueryRoiView].SolutionId=[SolutionView].SolutionId
join RPT_AppGroupView AS [AppGroupView]
on [SolutionView].AppId=[AppGroupView].AppId