Skip to Content
0
Former Member
Oct 20, 2016 at 02:54 PM

exportItemsFlexibleSearch error while exporting from HMC

220 Views

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