Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


The information on this page refers to License Statistics v6.8 and newer, which changed the parameters for limiting and ordering results in columns. If you are using a version previous to v6.8, see documentation for previous versions.

To generate a License Statistics report of your choosing, you can use any browser or an HTTP client (cURL). cURL is a library and command-line tool that can be used to access HTTP-based web services and websites. 

...

Code Block
languagejs
fieldVisibility="{"lsid":"1","lsn":"1","fid":"1","fns":"1"}

Limiting and ordering

...

results

You can order results using the parameters "orderByorder" parameter and "orderDirection", and limit record count using the parameters "offset" and "limit." . Order is applied first, then offset and limit.

  • orderBy - column order - list of columns and directions to order by
  • orderDirection - ASC to use ascending order, or DESC to use descending order
  • offset - rows to skip at the beginning of sorted result
  • limit - maximum number of rows to return

Example: Sort rows by checkout time ("lco") in descending order and include rows from 10th to 14th


Code Block
languagejs
offset: 9
limit: 5
order: [{"property":"lcovn","direction":"DESC"},{"property":"lsn","direction":"ASC"}]
offset: 9
limit: 5

Response

The API can respond with the following codes.

...