- Last Active
- No Roles
I tried like below Dql--Enter Query: select sum (r_link_cnt) from dm_document(all) where r_object_id in (select r_object_id from dm_document(all) in Document id('')descend ); Execute Show the SQL Error occured during query execution :[…
If you see query, I am getting below result, my requirement is to get the sum of r_link_cnt as an end result. I.e 59 is the total sum. select r_object_id,r_link_cnt from dm_document(all) in Document id(‘09001faa800b70e3’) descend where r_link_cn…
Hello , Yes If i remove sum(), query is working fine. I am trying to count all the virtual documents with all descends including direct and indirect components.