Skip to main content
Solved

Advanced Search Only Certain Business Opportunity Stages

  • January 19, 2026
  • 3 replies
  • 45 views
M
Do Gooder (Customer)
Forum|alt.badge.img+2

Need assistance on Advanced Searches on List Views within Aurena. See image below. What am I doing wrong?  As you can see from search I am trying to see only certain stage values, but results are bringining in all. Please advise correct query. 

(ProcessId = 'UNI_SALES_PROCESS') AND (StageId ne '100' OR  StageId ne '90')

 

Also, what language is this? Is there documentation?

 

 

Best answer by Nikila Dis

Hi ​@mwesley11529 ,

As per your current query for any record:

  • If StageId = '100' → it is not '90' → condition is TRUE
  • If StageId = '90' → it is not '100' → condition is TRUE
  • If it’s anything else → it’s not both → condition is TRUE

So every row satisfies (StageId ne '100' OR StageId ne '90'). The problem is the OR condition.That’s why you see all results.

Instead of using OR function you can use AND function as below which will show records where the process is UNI_SALES_PROCESS and the stage is neither 100 nor 90.

(ProcessId = 'UNI_SALES_PROCESS') AND (StageId ne '100' AND StageId ne '90')

Let’s say if you want to see only Stage 100 and 90

(ProcessId = 'UNI_SALES_PROCESS') AND (StageId eq '100' OR StageId eq '90')

This will give the expected result.

In addition I think this is OData filter syntax (used by Aurena list views).

https://docs.ifs.com/techdocs/23r2/060_development/022_user_interface/030_aurena_dev/099_concepts/search_concepts/#filter_operators_and_functions

https://docs.ifs.com/techdocs/23r2/060_development/022_user_interface/030_aurena_dev/099_concepts/search_concepts/

Regards,

Nikila Dissanayake

    3 replies

    Annjse
    Hero (Employee)
    Forum|alt.badge.img+11
    • Annjse
    • Hero (Employee)
    • January 19, 2026

    Hi ​@mwesley11529 ,

    If you change OR to AND it should exclude records that are not equal to 90 and not equal to 100. 

    Best regards,

    Anna

      Nikila Dis
      Hero (Employee)
      Forum|alt.badge.img+13
      • Nikila Dis
      • Hero (Employee)
      • Answer
      • January 20, 2026

      Hi ​@mwesley11529 ,

      As per your current query for any record:

      • If StageId = '100' → it is not '90' → condition is TRUE
      • If StageId = '90' → it is not '100' → condition is TRUE
      • If it’s anything else → it’s not both → condition is TRUE

      So every row satisfies (StageId ne '100' OR StageId ne '90'). The problem is the OR condition.That’s why you see all results.

      Instead of using OR function you can use AND function as below which will show records where the process is UNI_SALES_PROCESS and the stage is neither 100 nor 90.

      (ProcessId = 'UNI_SALES_PROCESS') AND (StageId ne '100' AND StageId ne '90')

      Let’s say if you want to see only Stage 100 and 90

      (ProcessId = 'UNI_SALES_PROCESS') AND (StageId eq '100' OR StageId eq '90')

      This will give the expected result.

      In addition I think this is OData filter syntax (used by Aurena list views).

      https://docs.ifs.com/techdocs/23r2/060_development/022_user_interface/030_aurena_dev/099_concepts/search_concepts/#filter_operators_and_functions

      https://docs.ifs.com/techdocs/23r2/060_development/022_user_interface/030_aurena_dev/099_concepts/search_concepts/

      Regards,

      Nikila Dissanayake

      www.linkedin.com/in/nikila-dissanayake-7140891a0
        A
        Sidekick (Customer)
        Forum|alt.badge.img+5
        • Anna_B
        • Sidekick (Customer)
        • January 20, 2026

        Hi ​@mwesley11529 ,

        If you change OR to AND it should exclude records that are not equal to 90 and not equal to 100. 

        Best regards,

        Anna

        Hey ​@Annjse ,

        Is making “OR” statements easier to search on the roadmap for improvements for IFS Cloud?

        Terms & ConditionsCookie settingsAccessibility statement