Custom sql user parameters - db2 dialect

Avatar
Matej Ugrin
Created

Hi,

I have tried to define my own user parameter but I cannot get it working to prompt a dialog when running a query. Examples in the pics. Datagrip version 1.0.3.

Query editor and parameter definition:



Thank you

Votes

0

Share

5 comments
Avatar
Andrey Dernov
Created

Hello Matej,

Try this pattern:

\$\{([^\{\}]*)\}

Works for me:

0
Avatar
Matej Ugrin
Created

Thanks Andrey but in my case regex are still not working.

 

0
Avatar
Andrey Dernov
Created

Does it help to move it on top of the pattern list?

Please attach your File | Export Settings... jar if issue remains. Thanks.

0
Avatar
Matej Ugrin
Created

Unfortunately it still does not work. My current version is Datagrip  145.404-2.

Which type of setting do you need for debuggin?

0
Avatar
Matej Ugrin
Created

Problem was solved by removing a not working regex that was probably preventing a match from other expressions. In my case the offending regex was ?\d+

0

Please sign in to leave a comment.