Skip to main content
June 30, 2021
Question

Need Help on tackling null values in Filter

  • June 30, 2021
  • 2 replies
  • 0 views

Hi ,

I am using below codes in Filter.

filter:if(isnull(local!empType),{},a!queryFilter(
field: "emptype",
operator: "=",
value: local!empType
))

It is displaying the error as  "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 37]: Expression evaluation error at function a!queryEntity [line 38]: Cannot apply a filter with a blank field name."

This is working fine when I am using ri!empType with some default value. But I do not want to use Rule input as I need to use this Interface in report.

Could someone please help me on this?

Thanks

Faisal

    2 replies

    sushilk061231
    June 30, 2021

    Hello Faisal,

    We at least one filter which return value for Filter, otherwise please update below  value

    ignoreFiltersWithEmptyValues : true in the query entity

    Cheers

    June 30, 2021

    Thank you Sushil.... I also changed the as (instead of {} I passed null word and it is working)..I will try this option which u have suggested.