Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Using "where" on load from DB: problem with 'wildmatch' function

Hello! Here is my code in the end of load sript:


FROM `amo_akz`.leads where `status_name`<>'Новый заказ' and `status_name`<>'Ожидает подтверждения (Call center)' and `status_name`<>'' and wildmatch(`responsible_user_name`,'*Мен*')='1';

On compilation i'm getting error:

SQL##f - SqlState: 37000, ErrorCode: 1305, ErrorMsg: [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.38-0+wheezy1]FUNCTION amo_akz.wildmatch does not exist


Without "wildmatch" everething is ok. What to do to make it work?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Wildmatch() is a qv qlik function that doesn't get recognized by SQL engine. Rather try with Like, like:

...`status_name`<>'' and `responsible_user_name` like '%Мен%';

View solution in original post

1 Reply
tresesco
MVP
MVP

Wildmatch() is a qv qlik function that doesn't get recognized by SQL engine. Rather try with Like, like:

...`status_name`<>'' and `responsible_user_name` like '%Мен%';