Passing Values to UDR
To filter the information displayed in a report, use the following parameters with the POST method described in the previous topic.
Parameters for Passing Values
| Parameter | Label or Value |
|---|---|
| Label | Enter a Label that matches the one used for the Query Condition when the UDR was created in the user interface (UI). For example, the Label might be Status. |
| Value 1 | To refine the report further, specify a value for the Query Condition. For example, the value might be Terminated. |
| Value 2 |
If the Query Condition contains an operator, such as between, use this parameter to specify the end of the range. Or, if the Query Condition uses a Date Picker with operators such as equals, less than, less than equals, or greater than equals, use this parameter to specify a whole number that reflects the addition of custom days. |
Note:
You can also enter multiple values using a comma-separated approach. For example, Value 1 might be Approved,Pending.Sample JSON to Pass Parameters
{
"reportname": "UDR for Request for Bid",
"query": [
{
"label":"Requests for Bid / Title",
"value1":"Standard"
},
{
"label":"Requests for Bid / Title",
"value1":"34",
"value2":"43"
},
{
"label":"Formula_01",
"value1":"100"
},
{
"label":"Formula_02",
"value1":"200"
},
{
"label":"Requests for Bid / Due Date",
"value1":"2018-07-31",
"value2":"5"
},
{
"label":"Requests for Bid / Creation Date",
"value1":"2018-07-31",
"value2":"2019-07-31"
},
{
"label":"Requests for Bid / Bid Sponsor",
"value1":"XYZ"
}
]
}