Rest Services Getting total count

mattslater1980
edited January 18, 2017 in Documentum #1

Hi ,

I would like to get the total count of the results in the response . I am using include-total=true and i am not able to see the total count in the response.

/dctm-rest/repositories/testrepo?dql=select * from dm_user&include-total=true&inline=true&&items-per-page=10&page=1

The documentation says include-total should return the total items.

Tagged:

Best Answer

  • abc123
    edited January 9, 2017 #2 Answer ✓

    As the API documentation states, DQL Query resource does NOT support the parameter include-total. Here is the screenshot for REST 7.3 RADL documentation.

    Snip20170109_18.png

    You can perform an explicit DQL query to get the total count, for instance, dql=select%20count(*)%20%20as%20cnt%20from%20dm_sysobject.

Answers

  • abc123
    edited January 9, 2017 #3 Answer ✓

    As the API documentation states, DQL Query resource does NOT support the parameter include-total. Here is the screenshot for REST 7.3 RADL documentation.

    Snip20170109_18.png

    You can perform an explicit DQL query to get the total count, for instance, dql=select%20count(*)%20%20as%20cnt%20from%20dm_sysobject.

  • mattslater1980
    edited January 18, 2017 #4

    Thank you for the clarification .