Workflow Soluiton

I have a custom ORM data type that includes a session id field.  Multiple instances of that data type have the same session id and I'd like to display those multiple instances on a Process View page for the corresponding process (matching process id with session id). I'm familiar with using Lists and Profiles to define a Workflow Process profile using an existing table but this does not seem to work in this particular case - they never show up in the profile web part.

I'm guessing its because there are multiple instances with the same session id.

I tried creating a custom report and managed to get a list of processes and profiles but I couldn't dynamically filter by process as I would need to do so that the Process view page only showed instances with a matching id - it shows all of them.

Hopefully this makes sense - does anyone know how I can achieve this?

You are correct,if using a Profile, it will look for the first matching SessionId and display that. Depending on the Type you create when using a DBDT it will overwrite the single row against that SessionId.

There are two options.

Create a Process Type Action, a link, to open a Workflow Web Form that has an input of the SessionId (ReportId) and shows a table/grid view of data.

ServiceDesk Customization: Process Type Actions
https://www.symantec.com/connect/videos/servicedesk-customization-process-type-actions

 

The other option is to create a Custom Web part where you can display any information you need.

Symantec™ Workflow 8.0 Component Developer Guide

https://support.symantec.com/en_US/article.DOC8700.html

Thanks Alex

The other option I've come up with is to use one of the iframe web parts and build a small web form project to display the multiple instances in a grid or list. This seems to work and you can even pass the userid, their email address and the Process Id in as standard input variables.  One problem with this is the Process Id is that XXNNNNN type format and I need the SessionId.

Does anyone know of a component that can retrieve the Session if if you only have the Process Id?

Integration Component SQL SELECT SessionId FROM ReportProcess WHERE ReportProcessID = @ReportProcessID Put this at the beginning of the Web Form project

Thanks Alex - that sorted it.  I was hoping for a native component but that works just as well.