Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: User interface

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Copy as where

It would be very useful to be able produce where clause from copied horizontal selection from the results grid. For example from the uploaded image, where clause should be

WHERE CTA.TRANSACTIONDATE = '2021-06-27'
AND CTA.TRANSACTIONTYPECODE = 52
AND CTA.ITEMCODE = 1500012200
AND CTA.ITEMBARCODE = '8001841964966'
AND CTA.YOURCOMPANYCR = 104183
AND CTA.OTHERENTITY_CR = 46084

2 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Barbaros Saglamtimur shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jeff Humphreys commented  ·   ·  Report

    That's actually a very creative idea! Which is rare sometimes. I use the IN clause generator, and it's a similar vertical version, and without the actual column names.

    I can definitely see using this. An extension could be that if you select cells (can you select cells?) on different rows, it generates a group OR "(x in('a', 'b')", only using AND for values on the same row. Very no-code idea.