Hello again!

Ok if I use a sqldatasource to connect and I go and create a custom query on process_definition.list.

SELECT     ProcessSetID, COUNT(Version) AS VersionCount
FROM          Process_Definition.List]
GROUP BY ProcessSetID

Instead of the query returning a count of how many versions each process set has it just lists them all again.  I know these smartobjects are just views of the tables, but i would have thought this would have worked.

Any thoughts?  what i was trying to do was figure out what the latest version of a particular process instance was via the workflow general smart objects.

Thanks for the input and have a good weekend!

 

- John