Ignore Hypen while searching in the search grid

Question

How to ignore hypens while searching in the grid 
 
 In the above image, while searching in the grid after removing hypen also below data needs to be come..

Soma · Answer

If you are using Sync time evaluation, you can create a custom record field and use stripwith(rv!record[field],"-"), and then run the query on this field. 
 But AFIK you cannot achieve it if you are using real time evaluation as it has limited number of custom record function

Mike Schmitt · Answer

Then I would suggest a DB view that strips out the hyphens in whatever way you deem appropriate, and your searches can run against that column (for the user-side, you can allow them to enter dashes or not, and pass the stripped-of-hyphens text to the actual search filter, searching against the View Column that also has hyphens stripped). 
 Beyond that, and we're kinda getting into "magic wand requirements" territory - that is to say, you're expecting the system to do something "intuitive" that it has no logical reason to know to try doing.

Mike Schmitt · Answer

I suggest you make a new custom record field which contains the data from "assgnmntNmbr" but strips out everything but digits (or other valid characters beyond hyphens). Then your query filter can just do an "includes" on the user-entered-text-similarly-stripped and reference that column (but you'll still display the original column and its value-with-hyphens).

Ignore Hypen while searching in the search grid

Top Replies