search

ljay79 / jira-tools

Project Aid for Jira - Google Spreadsheet Add-on for Jira Integration
GNU General Public License v3.0
112 stars 46 forks source link

enhancement - reference cells from within JQL query. #245

Closed jkirschling closed 4 years ago

jkirschling commented 4 years ago

I have a query like this - =JST_getTotalForSearchResult("Sprint = 'Sprint 20.1'")

I want instead to reference the sprint name from another cell like =JST_getTotalForSearchResult("Sprint = F1")

Is there a way to escape or reference cells from within the query function?

If not, it would be a very useful feature enhancement!

ljay79 commented 4 years ago

Hi @jkirschling , you can actually do this with the google sheet function CONCAT. Sample: =JST_getTotalForSearchResult(CONCAT("Status = "; B1))

ljay79 commented 4 years ago

@jkirschling were you able to check my response and test it?

jkirschling commented 4 years ago

Thanks for responding - I haven't, since I no longer work there :) - I'll pass this tip on to my friend who I was trying to help before I left and see if I can get a response.