You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Search Incident by Reference Number without Hyphen (-) or any Phone number with dash or Hyphen

edited Nov 3, 2016 1:24PM in Reporting & Analytics for B2C Service 3 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!