Determine number of nodes through sql

Hi guys,


I am wondering if the number of nodes in a flow (preparations screen and server actions) can be obtained from one of the OSSYS tables? or via some query?

We are trying to keep a check on code complexity and this is one possible avenue.


Thanks,

Andy


Hi Andy,

I think you want to query the Espace_Object_Count entity, but you need to join the Espace_Version and the Espace entity as well. Hope this helps

Many thanks Rogelio, 

That looks like a great tip. The output gives me

Espace_version_id, Obj_kind, Obj_count

So, for example  the Obj_kind is: "Nodes_WebScreen"

but since this is only at an espace level I don't know which flow it corresponds to.

Select * from 

[OUTSYSTEMSDEV].DBO.[OSSYS_ESPACE] esp,
[OUTSYSTEMSDEV].DBO.[ossys_Espace_Version] ver,
[OUTSYSTEMSDEV].DBO.[OSSYS_Espace_Object_Count] cnt

where esp.[ID] = ver.Espace_Id
 and ver.[ID] = cnt.Espace_Version_Id
 and esp.NAME = 'OUR ESPACE NAME'
 and Obj_Count > 10


Any idea how to narrow down further? It would be great if we could get the Screen name/server action name?

thanks again,

Andy