Forum Discussion

Marco's avatar
Marco
Contributor II
23 days ago

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 *...
Dashboards
victortei's avatar
victortei
New Contributor III
23 days ago

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.

 

Marco's avatar
Marco
Contributor II
22 days ago

Hi victortei, Where is this configuration located? I use the component sql table editor

  • victortei's avatar
    victortei
    New Contributor III
    22 days ago

    It's on the SQL Table Editor component itself. I'm on version 8.4, not sure if this is something new.

    • Marco's avatar
      Marco
      Contributor II
      22 days ago

      Oh, that must be it. I am currently using version 6.3