DM_QUERY_E_COMPOUND_FUNC

Migrateduser

HI All,

I want to sum the r_link_cnt from dm_document(all) in document_id ('r_object_id) descend.

select sum (r_link_cnt) from dm_document(all) in Document id('r_object_id') descend where r_link_cnt>=1;

getting error like Error occured during query execution :[DM_QUERY_E_COMPOUND_FUNC]error: "IN DOCUMENT clause and a set function appear in the same SELECT."

Is there any better way to get the sum of r_link_cnt.