Expand my Community achievements bar.

SOLVED

Search function in Predefined filter

Avatar

Level 4

Hi,

I have added partId field in predefined filter but search function is not working as expected.

When I select filter name or email from list of filters its showing only those records where partId is equal to zero whereas I want all the records of partId.

 

Below is the logic which I have added in the predefine filter:

Logic in general tab:

tejashriw155148_0-1586264109355.png

 

Logic in Form tab:

<form maxLabelWidth="300">
<enter>
    <set value="0" xpath="@partyPartId"/>
  </enter>
  <container colcount="3">
    <input noTransaction="true" xpath="@lastName"/>
    <input noTransaction="true" xpath="@email"/>
    <input label="PartId" minValue="0" noTransaction="true" type="number" xpath="@partyPartId"/>
  </container>
</form>

Here how the output is coming:

tejashriw155148_1-1586264109359.png

 

Here instead of only zero partId how the all records will come?

Please suggest me.

Thanks,

 

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi,

 

As the partyPartId field is a numeric field, I think you should  enter the following script in the "Taken into account if" field :

$(@partyPartId)!=0

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi,

 

As the partyPartId field is a numeric field, I think you should  enter the following script in the "Taken into account if" field :

$(@partyPartId)!=0