Actually it is not possible to have an Import Objects using AQL Filter (Filter data source by AQL) that is using information based on reference objects. It is needed to filter object by reference during the import

Example :

• Just import host system where the reference operating system.name like windows.
• Here we want to use Filter data source by AQL as "Attribute Name" IS NOT LIKE Windows or "Attribute Name" IS NOT Empty.
• It is needed to add the possibility to add references with an AQL that using object references

Another Use Case:

• Importing a network device which contains a list of "connected" mac addresses
• These should be linked to host systems where the mac address information is available in a list of Networkintefaces. So the mapping IQL would be something like "Host".Networkinterface"."Mac Address" In (${MAC Address{0}})

Workaround:

So to bypass this limitation, you can copy the "Mac Address" in your data source in another attribute called "Mac Address - Temp" (this a simple text attribute) and then filter your data source using this attribute and you can delete this attribute once all the objects are imported.

• Create a Text Field Attribute (Mac Address - Temp)
• Make sure this Attribute as similar value in your objects matching the  Mac Address
• In CSV File , have this column added (Mac Address - Temp)
• Then in Filter data source by AQL , you can use "Mac Address - Temp" IS NOT EMPTY to filter the records.