Skip to Content (Press Enter)
UserImage.jpg
Shalini D M
53Views
3Comments
Solved
How to search only first letter in the search box
Question
Beginner
Reactive

I want to search only first letter of every data not the similar letter present in the data 

how can i achieve this , what filter i need to use

0
0
22 Feb 2024
Copy Link
2023-11-20 06-53-17
Neha Rathore
Solution

Hi Shalini,

You can use this filter in the aggregate.

Hope this helps

Thanks
Neha


0
0
22 Feb 2024
Copy Link
UserImage.jpg
Shalini D M

Yes it worked for me Thank You.

0
0
22 Feb 2024
Copy Link
UserImage.jpg
Muhammad Khoir Al Alim Manurung

Hi @Shalini D M, 

You can use the substring to get the first letter. 

Substr(Entity.Name, 0, 1)

But in case you want to make the search function. The best practice is you can prefer to use the like "%" syntax. The example syntax is like this:

SearchKeyword = "" or Entity.Name like SearchKeyword + "%" 

Thanks hopefully can help you.

0
0
22 Feb 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.