Question

Input Range not filtering in order reports in IFS10 Aurena

  • 19 October 2023
  • 0 replies
  • 19 views

Badge +1

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?


0 replies

Be the first to reply!

Reply