Sort web interface report data and retrieve all contents with a single query

[somesh.m...@gmail.com]

Hi,

Question 1: Is there a way we can sort the web interface report response? For example, I have the following Web Interface report and I want to default sort the response based on the MEASURE_9:

https://live.runmyprocess.com/live/2215365968/applireport/nominations.csv?nb=20&first=0&column=name%20measure_10%20measure_2%20measure_3%20measure_9%20measure_6%20measure_1%20measure_14%20measure_11%20measure_5%20measure_8%20measure_12&operator=EE%20EE%20EE%20IN&value=58903%20%7BTEST%7D%2086303%201&filter=PROJECT%20MODE%20APPLI%20STATE&media=json

Question 2: The query parameter "nb" seems to control the number of records returned for a specific query. Can I set it to a value which returns me all the data in a single query?

Thanks!

[Madhuri...@in.fujitsu.com]

Hi Somesh,
Answer for Question 1-You can add Measure_9 as one column in web interface report configurations and save that report.
In report widget select this particular web interface report and check Sortable.
At runtime click on column name e.g. Measure_9 .It will sort ASC and DESC respectively.

Can you please elaborate more for Question 2?

Thanks & regards,
Madhuri,Fujitsu

[Somesh Mukherjee]

For question 1, I am not using any web interface report widget to display the report data on UI. I am parsing the response to access process level data. My question was to check if we can indicate the sort expectation through the query parameters.

--

__________________________________________

SOMESH MUKHERJEE

Enterprise IT | Cloud Computing Community | IEEE

445 Hoes Lane, Piscataway, NJ 08854, USA

Desk: +1-732-981-2877

Email: somesh.m...@ieee.org

Website: www.ieee.org

__________________________________________

[Dimitri MELCHIOR Pro]

Hi Somesh

Please add this into you report query :

&orderby=MEASURE_9&order=desc

You can get up to 100 instances. If you want to get all, you must paginate queries.

Best regards.

--

Dimitri MELCHIOR

PreSales Consultant

Contact: dmel...@runmyprocess.com

Tel: +33(0)1 75 77 51 78

Mobile : +33(0)6 52 70 89 82

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.
Be environmentally friendly: do not print this email unless it is entirely necessary.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAFqUvHSDBkUrTzewfraKcy3VzvGrU0ms9hNBg2GmNSpvgk-81w%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/groups/opt_out.

[somesh.m...@gmail.com]

Thanks Dimitri!