Pass a particular or All as value of Report Level Filter in 4.2 SP02 with Drill API

[Former Member]

Dear All,

I am getting lov of report level filters and selecting any particular value of a report level filter with Drill API to get html response for that selected filter value using Restful web services. I want the data for all possible values of a filter selecting"All" as value from listbox.

Please guide me how to pass 'All' as value for that filter.

e.g. With eFashion universe, selecing California as state filter, we can do this

PUT, url: http://<server>:6405/biprws/raylight/v1/documents/1972284/reports/22/driller/filters/DP0.DOda

Raw Payload:

<filter>

<value>California</value>

<filter>

and I am expecting as below:

PUT, url: http://<server>:6405/biprws/raylight/v1/documents/1972284/reports/22/driller/filters/DP0.DOda

Raw Payload:

<filter>

<value>All</value>

<filter>

I don't want to fill Raw payload with all possible values as below(assuming there are four possible values of State filter):

Raw Payload:

<filter>

    <lov>

    <values>

    <value>California</value>

    <value>DC</value>

    <value>Florida</value>

    <value>Colorado</value>

    </values>

    </lov>

</filter>

Thanks & Regards,

Deepak Kumar

[former_member197386 · Accepted solution]

Hi Deepak,

To select "All values", you have to simply not specifying any values:

PUT, url: http://<server>:6405/biprws/raylight/v1/documents/1972284/reports/22/driller/filters/DP0.DOda

Raw Payload:

<filter>

</filter>

Best regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony,

Thanks a lot, it's really amazing 🙂

I have tested and it's is working well.

Best regards,

Deepak Kumar

[former_member197386]

Hi Deepak,

Very good question, I will check that.

Regards,

Anthony