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 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.