20
Views
13
Comments
Searching along with () using filter condition
Question
Application Type
Reactive

I have a entity where data of integer type along with  paranthesis so doing a normal search is achieved by IntegerToText but inorder to search with (value) what will be the condition .

Can anyone help me to sortout 

Rank: #493

HI,

Let describe more about your case, for example value = 2

  1. you want to search for text "(2)" in 1 column fields
  2. or, you want to search many value put in ()
mvp_badge
MVP
Rank: #76

Hi Ummul,

You can try by defining the filter condition as mentioned below

Entity.Attribute = "(" + searchIntegerValue + ")"

Hope this helps you!


Regards,

Benjith Sam

Hi Ummul,

If I understood correctly base on the previous answers.

You can apply what Shingo suggested:

"(" + Ticket.IO +")" = searchIntegerValue

You can use the function IntegerToText on the Ticket.IO but there is no need.


But this example that you wrote doesn't seems quite right to me or maybe I'm missing something:

IntegerToText(Ticket.IO) like "%" + "(" + SearchText + ")" +"%" it is not working can u help me on this  

If your Ticket.IO is an Integer why you would apply the like operator and mixing ( ) in the search condition? Integers will never have ( ).


Best Regards,

Cláudio Rodrigues