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