SQL table editor show only 100 rows
Hi everyone.
I would like to know if there is a way to display only a certain number of rows in an SQL TABLE EDITOR, as I do not see a way to set it up as in a query, for example.
SELECT TOP 5 *...
Forum Discussion
Hi Marco,
You have two options to achieve your goal, but neither will allow you to edit the records—only to view them:
- Using a Grid View instead of a SQL Table Editor is the easiest option. The downside is that you cannot edit records in a Grid View. However, you can limit the number of rows in your data adapter.
- I’d say this option is a bit more creative. If your table is in the application database, you can create a view to limit the number of rows. Then, in your SQL Table Editor, you can use that view in the WHERE clause.
In this example, I'm creating a View based on the Member table. Notice that I'm adding the Row_Number field which will help you limit the output:
CREATE VIEW MemberView AS SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNum FROM Member;Then, in your SQL Table Editor, you need to query the View and use the Row_Number in the Where Clause:
Hope this helps!
Hi victortei.
I use the following table, XFW_PLP_Register, which contains too many rows, so I am unsure if this could affect performance. However, I have additional values that I use to filter this table, which are listed below. Regarding the use of a grid view, I need to maintain the editing functionality within the element.
XFW_PLP_Register
WHERE WFProfileName |!WFProfileCriteria_PLP!| And WFScenarioName = '|WFScenario|' And WFTimeName = '|WFTime|' BRString(PLP_ParamHelper, GetRegCriteria, Status=|!StatusListAll_PLP!|, RegID=|!SelectedRegisterIDDistinct_PLP!|) BRString(PLN_PLP_ParamHelper, GetPLPDeptSecurity, Status=|!StatusListAll_PLP!|)
Got it. So, you're using the People Planning Marketplace solution and, of course, want users to be able to edit the content.
Are you using the standard out-of-the-box dashboard, or are you building something custom?
Also, what’s the reason for limiting the number of displayed rows? The SQL Table Editor component paginates when there are many records, and you can also adjust the default value of rows per page to something that better suits your needs.