UCCX 9 Search by first 4 letters and another data

[nkobayashi123]

Good afternoon everyone

Could you please advise me on this question?   I need to search a person's information by using first 4 of ID number, first 3 of area code and another data such as his/ her birthday...

My script is....

1.  Ask a caller to enter first 4 digit of ID  (Complete ID number is 10digits or longer)

2.  Ask a caller to enter first 3 numbers of area code

3.  then, ask his/her to enter complete birthday (MM/DD/YYYY)

4.  With those information, I need database to search person's recent activity data

I tired for first 4 digit ID search as    SELECT * From VW_Database WHERE CustomeNumb LIKE 'CustomerNumber%'      in DB Read Field Selection.   However, it comes back as no data found...   It does not look like taking wild card (%) 

Please advise how i can use wildcards with this data search....

Thank you ,

Nana

[Anthony Holloway · Accepted solution]

You need a dollar sign in front of the variable name, when referencing script variables in SQL statements.

E.g.,  '$CusomterNumber%'

Could you give that a try?

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

[nkobayashi123]

Thank you so much for super quick reply.

My team member Left function   LEFT (CsuomterNum, 4) = $CustomerNumber and yes,  it worked

Thank YOU for your help as usual!!!!

nana

[Anthony Holloway]

You are welcome.  Glad you have it working now.  Could you please mark the thread as answered?  Thank you.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

[nkobayashi123]

Yes,  Thank you so much Anthony