Hi,
Im trying to export below query from System-tools-export
INSERT_UPDATE Customer;uid[unique=true,allownull=true];customerType(code) "#% impex.exportItemsFlexibleSearch( ""SELECT {C.uid}, {PCT.code} from {Customer} as C join Pangaea2CustomerType as PCT on {C.customerType} = {PCT.PK} } where {PCT.code}='Migrated'"" );"
I want to only export customer which are tagged as Migrated.Only customers which have enum values as Migrated. But this query throws error for PK.
Please need your help here.
Regards, Siddhi