Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do you search an attribute of type textarea?

I chose to create an attribute of type textarea because the text could be long.  

What is the IQL to perform a "contains" search on this attribute?

Queries like the following do not work:

  • Notes LIKE "TEST"
  • Notes IS EMPTY
  • Notes IS NOT EMPTY

1 answer

LIKE & NOT LIKE should work. You can also use startsWith & endsWith

You'll also want to make sure those attributes are indexed for quicker results, otherwise the search can be slower.

https://documentation.mindville.com/display/INSSERV/IQL+-+Insight+Query+Language#IQL-InsightQueryLanguage-Operators

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

386 views 3 17
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you