-
Notifications
You must be signed in to change notification settings - Fork 790
Description
When using the Filtered Rows feature in the Object Explorer, I prefer to put each condition on a separate line in the Data Filter dialog when I have multiple conditions or want to add an order by clause.
In past releases this worked great and the text made it to the query window as it was typed, however in recent releases (not 100% sure, but I think 9.6 may have been when the behavior changed) the text I type in the Data Filter dialog is being modified with the newline characters removed resulting in an error message in the Messages tab of the query window and no data shown.
To Reproduce
Steps to reproduce the behavior:
- Select a table in the Object Explorer
- Click on the Filtered Rows button
- In the Data Filter dialog, type multiple conditions separated by newline characters (no additional spaces)
- Click on the OK button
Expected behavior
I would expect the newline characters to be preserved in the query string passed to the query window and for the query to run without an error.
Error message
If you typed the following in the Data Filter dialog:
created>=current_date
and createdby='some_id'
This would result in an error like the following:
ERROR: syntax error at or near "createdby"
LINE 2: WHERE created>=current_dateand createdby='some_id'
^
SQL state: 42601
Character: 63
Currently running into this on Windows 11 in Desktop Mode with version 9.9.
Thanks.
Metadata
Metadata
Assignees
Labels
Type
Projects
Status