Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 '%Мен%';
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 '%Мен%';