Search Incident by Reference Number without Hyphen (-) or any Phone number with dash or Hyphen
Content
Hi Team,
We have business requirement where our business want to search Incidents by Reference Number without putting Hyphen (-) character. As an example In Incident Quick Search they want Report to return data if user is passing input as 161023000289 Instead of 161023-000289
Same way we need to change Any Phone filter search also so that user can enter phone in any format and our report search based on Actual digit value at DB level. Ignore all - etc like if in Database Phone entered is 9999976757 and user is entering 999-99-76757 it should return result.
Please help me understand what is the best way to achieve this result.
Tagged:
0