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

Scriptrunner - Custom CQL Script functions

Justin Volden May 04, 2017

Has anyone written a custom cql script in scriptrunner that takees a phrase and then does an or search on each word? When searching via the confluence API is tries to match all words in the phrase, I'm looking for a way to return partial matches.

 

Thank you

1 answer

1 vote
Jonny Carter May 15, 2017

Something like this should do just that:

 

import com.atlassian.confluence.pages.PageManager
import com.atlassian.confluence.spaces.SpaceManager
import com.atlassian.sal.api.component.ComponentLocator

def spaceManager = ComponentLocator.getComponent(SpaceManager)
def pageManager = ComponentLocator.getComponent(PageManager)
String phrase = params[0]
def words = phrase.tokenize()
def ids = []

spaceManager.allSpaces.each{ space ->
    pageManager.getPages(space, true).each{ page ->
        boolean bodyOrTitleContains = words.any{ word ->
            page.bodyAsString.contains(word)  || page.title.contains(word)
        }
        if (bodyOrTitleContains) {
            ids << String.valueOf(page.id)
        }
    }
}

return ids

As a side note, you could approximate that with functionality with the built-in CQL text field. You'd have to break up your phrase, but depending on your use case, that might be easier.

text ~ "word1" OR text ~ "word2" OR text ~ "word3"

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

2,413 views 11 28
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