Drill Filter LOV prefixed with 'L' in 4.2 SP02 with Rest SDK drill API

[Former Member]

Dear All,

I am not able to get the list of values for filters prefixed with 'L' using drill API as below:

GET,URL:http://server:port/biprws/raylight/v1/documents/94734/reports/18074/driller/filters/L17

Response:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<filter qualification="Dimension" inQuery="false" ambiguous="false" inScope="true">

    <id>L17</id>

    <name>PNumber</name>

    <lov hierarchical="false" partial="false" refreshable="false" searchable="true" mandatorySearch="false">

        <columns mappingId="0">

            <column id="0" type="String"/>

        </columns>

    </lov>

</filter>

Please let me know how lov are achievable for these type of fields.

Thanks & Regards,

Deepak Kumar

[former_member197386 · Accepted solution]

Hi Deepak,

It seems you're still drilling in your data, great!

About your question, do you know which is the nature of "L17"? Is it a merged dimension?

Best regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony,

Thanks a lot for replying.

Yes, L17 is a merged dimension.

Best regards,

Deepak Kumar

[former_member197386 · Accepted solution]

Hi Deepak,

Is seems this has been fixed starting 4.2 SP03.

Regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony,

Thanks for replying.

Regards,

Deepak Kumar