Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCX 9 Search by first 4 letters and another data

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

1 ACCEPTED SOLUTION

Accepted Solutions

UCCX 9 Search by first 4 letters and another data

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.

Anthony Holloway

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

UCCX 9 Search by first 4 letters and another data

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.

Anthony Holloway

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

UCCX 9 Search by first 4 letters and another data

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

UCCX 9 Search by first 4 letters and another data

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.

Anthony Holloway

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

UCCX 9 Search by first 4 letters and another data

Yes,  Thank you so much Anthony

172
Views
0
Helpful
4
Replies
CreatePlease login to create content