Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to list numbers as list of values for an IRIN url parameter/filter

LajosV-OracleSep 10 2011 — edited Jun 28 2012
Hello,

I'dl like to call Apex interactive report page with filter parameter IRIN in the URL
to get the report for a list of action ids.

When filter looks like IRIN_ACTION_ID:189353, i get the report for action_id=189353 properly.
However the point would be to get the report for a set of action_id values, but i am struggling to find the format how to list more than one action_id value to get the expected result.


This works, gives what i expect:
http://../pls/apex/f?p=999:916:1087915793180497:::CIR:IRIN_ACTION_ID:189353

These format do not work, here i am trying to get the report for action_id IN 189353,19004
http://.../pls/apex/f?p=999:916::::CIR:IRIN_ACTION_ID:189353%2C190043
http://.../pls/apex/f?p=999:916::::CIR:IRIN_ACTION_ID:189353,190043

Action_id=190043 is not included in the report though it exists.

Can someone please confirm how the number type values should be listed in the URL for the IN operator?

Many thanks,
Lajos

Edited by: lvarady on 10-Sep-2011 06:39
This post has been answered by Asitterson-Oracle on Jun 28 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2012
Added on Sep 10 2011
2 comments
620 views