nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to use text (not JSON) entity properties in JQL?

Yuriy Marchenko

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!

Accepted answers

All comments

Veronique DUFOUR

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

Yuriy Marchenko

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

Veronique DUFOUR

@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 ""

Yuriy Marchenko

"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

Rhys Diab _Rogue Wombat Software_

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.

Yuriy Marchenko

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-core

jql

atl-dev

jira-app-development

property

atl-orange