Skip to main content
Question

Input Range not filtering in order reports in IFS10 Aurena

  • Oct 19, 2023 12:15 PM UTC
  • 2 replies
  • 94 views

Forum|alt.badge.img+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?

2 replies

Forum|alt.badge.img
  • Do Gooder (Partner)
  • Jun 25, 2024 5:41 PM UTC

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


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • Jun 26, 2024 7:28 AM UTC

@DasuniK No. I did not get any solution yet