Unknown Value - IQL

[Arkadiusz Baka]

Hi,

what will be IQL query to find all object where value in User(Jira) attribute is "Unknown"

User="Unknown" - doesnt work

[Vincent MARX · Accepted solution]

Hi,

You can find "Unknown" users with this IQL query (where "User" is the attribute name) :

"User" IS NOT empty AND "User" NOT LIKE ""

[Arkadiusz Baka]

It's work. Thx

[Cornelius Gillner]

Holy Cow! After wrestling with this for ours and giving up hope after reading this:

https://confluence.atlassian.com/jirakb/how-to-identify-user-attributes-with-unknown-value-in-insight-1115133990.html

... you saved me!
I have to be honest, I don't really understand why it works but it does.

[Julia Gracia]

Hi,

Try with User is empty

[Arkadiusz Baka]

It's doesn't work. User is empty show only rows without value

[Marina Veselić]

Same problem here. We have to do an excessive workarround. If we want to find all the objects with the "Unknown" user value, we need to export them in csv. If we want to delete the values we need to import those objects with an empty value for the user field. 

Woould be greatful for a better solution.

Cheers,
Marina