Unable to import data using Not Like from SQL below is the sample code

[Anonymous]

Hi I'm importing data from a table using hte below sql code. The problem is i get the full table including the data from description that i do not want. When i use like instead of not like the code seems to work.

select * from public.report_investment_items_view where

"Description" not like '%Accrued%' OR
"Description" not like 'receivable%' OR
"Description" not like 'ATO%' OR
"Description" not like 'Borrowing%' OR
"Description" not like 'Cash%' OR
 

[TeigeGao]

HI @Anonymous ,

Could you please tell us what's error message did you meet when you import the data? Based on my test, all works normal.

Best Regards,

Teige

[Anonymous]

Hi @Anonymous 

Why the double quotes around description? Also you have an extra OR at the end?!
Works fine for me with MySQL DB.

Thanks

[Anonymous]

Hi..its postgres server that i need to connect to..so the syntax needs double quotes for column name..the extra or is not in the actual code..i just pasted a sample

[Anonymous]

Sorry, I cannot test PostgreSQL.

Maybe others can test and say if there is a bug?!

Cheers!
A