Using the ParAccel DB connection, we are using the option to view the top 1000 rows in a table “Edit Table Data (Top 1000)”. This generates a query against the database for the full table, and the SQL doesn’t include syntax specific to the row limit. Can this be added so users don’t query the whole table.
Append "LIMIT 1000" clause to the query generated for the "Edit Table Data (Top 1000)" action if it is a ParAccel connection. If the user updates the Max Results value in the Table Data Editor, the LIMIT clause in the query will be updated when refreshing the data.
Issue #11107 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.6-4 |
No time estimate |
Append "LIMIT 1000" clause to the query generated for the "Edit Table Data (Top 1000)" action if it is a ParAccel connection. If the user updates the Max Results value in the Table Data Editor, the LIMIT clause in the query will be updated when refreshing the data.