Skip to Content
Former Member
May 21, 2014 at 01:45 PM

BOBJ 4.1SP2 REST API REQUEST: documents/{documentId}/parameters, limit return LOVs count



<children xsi:type="queryspec:ConditionOperatorNode" logicalOperator="And">

<children xsi:type="queryspec:ConditionDataNode"logicalOperator="Null">

<condition xsi:type="queryspec:ComparisonCondition" conditionType="Comparison" itemIdentifier="DS0.DO2" comparisonOperator="InList">

<operands xsi:type="queryspec:QueryPromptOperand" free="true" userPosition="2" persistent="true" question="Enter values for Period_Name:" lovIdentifier="DS0.DO2"/>

I have a prompt condition over field name Period_Name. The table holds this column contains million of records.

Created a query above query specification to the data provider and same data provider linked to a document.

GET <webiURL>/documents/{documentId}/parameters.

When I am making the above call, it is trying to get distinct LOVs for Period_Name and as it has huge records in the table, Request is throwing Request timed out exception. I set request time out to 30 mins, still no use.

Is there any option to limit max LOV return values from the above call, like top 5000 LOV values only.

Please help me.

Thanks in advance