Insight: Filter data source by IQL not working

Paul Tierney September 24, 2018

I have what I think is a very simple filter on my csv import, but I get an error when try to import: "import data mapped to OTA label is empty".

My filter is Cat = Add-on.  When I remove the filter the import does not have an error.  Filter and simple configuration screenshot below.

image.png

I have tried many different ways but cannot get this filter to work.  Using Insight 5.5.14.1.  Thanks, - Paul

 

1 answer

1 accepted

3 votes
Answer accepted
Paul Tierney September 24, 2018

OK, have found my own answer (wish I had before posting this!).  filter must be Test=Add-on (not Cat = Add-on)  I thought left side had to be data source field, but apparently is the Insight field.  And that works.

Steve Letch June 12, 2019

Having fun trying to get this working.

 

I want to import all the models from the asset spreadsheet refined by Manufacturer = Apple but any time I filter it doesn't work :(

 

Screenshot 2019-06-12 at 16.08.47.pngScreenshot 2019-06-12 at 16.10.42.png

Jon Hill
Contributor
July 5, 2019

@Steve Letch , I think the problem you're facing is the same one I just figured out after a few days of banging my head against the wall:  according to https://documentation.riada.io/display/ICV70/General+Import+Concepts, it's not possible to use the Filter data source by IQL feature to filter referenced objects.  In Paul's case, I'm guessing that Test was a text field.  In your case, it looks like Manufacturer is a reference.  

 

In my case, I'm trying to filter by "Operating System" Like Server, but Operating System is a reference.  My workaround will be to add a field named OS Name that will be a text field, run a periodic bulk update of OS Name to be the same as "Operating System"."Name", and update my import to filter by "OS Name" like Server.

Steve Letch July 6, 2019

@Jon Hill I had an hour long screenshare with the makers of the plugin so have a much better idea of how it works now.

 

I now have a really sweet Insight setup with users and devices cross referncing all sorts of things.

 

I also have a nice LDAP sync going which pipes into the Service Desk tickets.

Steve Letch July 6, 2019

If you need more clarification on their slightly confusing ways i'll post a bunch of screens and attribute examples on monday from the work lappy

Like # people like this
Mario October 25, 2019

-

Tomáš Vrabec
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 3, 2019

Thanks for hint! Run into same issue with referencing IQL filter, but thanks to this thread, solved in the minutes by creating Hidden atribute. Thanks guys. 

Luis Plaza
Contributor
May 25, 2022

"hiddenEnvt" NOT IN ("LINUX","STORAGE","RSA","IOS","OS400","VMWARE","WIN","UNIX","Z/OS")

 

Also fails when there are not values within that set trying to load a csv file. The rest of mapping-impots conditions like "hiddenEnvt" = "LINUX" work fine

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events