Skip to main content

hi all,

I created an order report with 3 input parameters: Project ID, Sub Project ID and Activity. When i enter a range in project id input eg: PROJ1..PROJ10 ,  then next input parameter sub project id is not getting filtered based on the project ids in this range. It is showing all subproject id values irrespective of the project id range I entered. 

I gave below conditions in REP view columns

^QUERY=Project:^QFLAGS=OW-BL^REF=C_CLS_PROJECT_LOV^
^QUERY=Sub Project:^QFLAGS=OC---^REF=C_CLS_SUB_PROJECT_LOV(PROJECT)^

and below conditions in LOV view column comments

COMMENT ON COLUMN C_CLS_SUB_PROJECT_LOV.PROJECT_ID IS 'FLAGS=PMI-L^DATATYPE=STRING(100)^PROMPT=Project ID^';
   COMMENT ON COLUMN C_CLS_SUB_PROJECT_LOV.SUB_PROJECT_ID IS 'FLAGS=KMI-L^DATATYPE=STRING(100)^PROMPT=Sub Project ID^

The filtering is working fine in IFS10 IEE, but not working in Aurena. Could you please help?

Hi, was just wondering, have you had any luck with a workaround for this problem?


@DasuniK No. I did not get any solution yet


Reply