Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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 to use text (not JSON) entity properties in JQL?

Hi everyone,

 

We've been using some entity (project, issue) properties, having text values in there worked perfectly fine, the conditions in the descriptor work fine, the REST API, etc.

Now the time has come to add a webhook for issue updates and we need to use the entity properties we have (with text inside, not JSON) to filter out once we don't care about.

The problem is the documentation explains how to index the properties with JSON values...

Does anyone happen to know how to index such fields or is there a way to use them for JQL search without indexing?

Any information helps, thank you!

2 answers

I've encountered this problem too.

I resorted to saving everything that needs indexing in JSON. 

Not having to store these properties as JSON to use them in JQL searches would be helpful.

Thanks Rhys, it's good to know I'm not alone in this situation 🤗

@Yuriy Marchenko could you add an example of a property and an example of the king of JQL you're trying to use?

Properties:

- Issue property (key: "com.railsware.SmartChecklist.checklists") with some text value e.g. "Hello, World!"

- Project property (key: "com.railsware.SmartChecklist.isDisabled") with "true" value

 

I can't find in the documentation how the JQL should look like so these are just guesses:

`issue.property[com.railsaware.SmartChecklist.checklists] is empty`

`com.railsaware.SmartChecklist.checklists is empty`

`project.property[com.railsware.SmartChecklist.isDisabled] is empty`

I'm looking for issues of projects with blank/empty "com.railsware.SmartChecklist.isDisabled" property

@Yuriy Marchenko I think it will look something like this
project.property["com.railsaware.SmartChecklist.checklists"] is empty

I'm not sure about how it should be written between the ""

"com.railsware.SmartChecklist.checklists" is an Issue Property, we can ignore it, sorry for combining 2 examples.

The main goal is to find issues in projects that have "com.railsware.SmartChecklist.isDisabled" project-property empty or null, or not "true"

❌ project.property[com.railsware.SmartChecklist.isDisabled] is empty

❌ project.property[com.railsware.SmartChecklist.isDisabled] is null

❌ project.property[com.railsware.SmartChecklist.isDisabled].value is empty

I'd keep on guessing if I only knew it's possible :D 

Sorry for my mistake ...
I'm only guessing on my side too but I see that the "" are not in your last post.
Maybe something like this?
project.property["com.railsware.SmartChecklist"].isDisabled is empty

@Veronique DUFOUR Thanks for trying :)

Unfortunately, this is the very article I've mentioned in the question, it describes how to index for searching property with a JSON value, not text.

In the example, they got something like

{
  content: "Hello, World!"
}

as the "tasks" property value. 

If only I could easily migrate the property values we use from

"true" 

to, say, 

{ value: "true" }

but I can't.

Using the REST API for such a migration will help, but I will use it only if I find no other way around.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Confluence

Introducing External Collaboration for Confluence

We’re excited to introduce external collaboration for Confluence, now available in early access. It is available to preview for Confluence Cloud Premium and Enterprise customers. (If you're not on ...

229 views 0 8
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