Join autocomplete order & table aliases

Answered

I know this might sound a bit silly but I like my joins to be like this:

> join table_a a on a.id = b.table_a_id

But datagrip autocompletes them like this:

> join table_a a on b.table_a_id = a.id

Is there a way to change the order?

 

Also, is it possible to add custom aliases to tables when using the autocomplete?

Let's say I have the table cellphones, I would like that the autocomplete always used cell as an alias, instead, sometimes I get c or c2.

 

Thanks,

Fran

2 comments
Comment actions Permalink

Be attentive to our release notes :) https://www.jetbrains.com/datagrip/whatsnew/#code-completion

There is a setting:

 

Custom aliases are also here, and it's described at the same NEWS page as well!

1
Comment actions Permalink

Awesome, thanks for the answer!

Will begin reading them :)

0

Please sign in to leave a comment.