Query finding the concatenation of currentuser() with a string

[Muriel DONNET]

Hello,

My question deals with the concatenation of currentuser() (e.g. m000001 or m200000) with a string (e.g.: _toto).

The field Analysis of some our JIRA issues contains these concatenations (e.g. m000001_toto or m200000_toto).

I'd like to find them with a JIRA query.

I was able to write the queries for each of the values m000001 or m200000 of currentuser():

Analysis ~ "\" [~m000001]_toto \ ""

Analysis ~ "\" [~m200000]_toto \ ""

But how can I write the generic request with currentuser()?

Analysis ~ "\" currentuser()_toto \ "" does not work.

Thank you for your attention.

Best regards,

[Antoine Berry]

Hello @Muriel DONNET ,

To my knowledge you cannot do such a thing. If you are on server, you might want to create a custom JQL functions briefly explained here. If you do not need to run you query in the jira search function, you can more easily build it and execute it in a script.

I do not have a cloud instance but maybe you could play around with automation.