Scriptcase Help Center Help Center
Home
English en
Language
en English pt_BR Portuguese (Brazil) es Spanish
Home
Categories
What’s New in Scriptcase
  • Discover What’s New in Scriptcase 10
  • API Configuration for Use with Scriptcase AI
  • Getting a ChatGPT (OpenAI) API Key for Scriptcase AI
  • Getting a Gemini API Key for Scriptcase AI
Scriptcase
  • Error connecting MySQL 8 database
  • How to connect to MySQL 8.0
  • Updating Scriptcase's PHP
  • Configuring the timezone in PHP
  • Execution of reCaptcha Displays Error - MacOS
  • GoJS Library is no longer available
  • Manual Update - Linux
  • Adding new columns in the table for Calendar
  • Manual update of Scriptcase on Windows
  • Manual Update - Mac OS
  • PHP functions necessary for ScriptCase
  • Setting password recovery in Scriptcase
  • Installing Scriptcase with PHP 7.0 on Windows
  • Installing PHP 7.0 - Mac
  • Resetting the Production Environment Password
  • Installing PHP 7.0 - Linux
  • Solving Source Guardian version problem
  • PDF generation displays message: 'Not Found'
  • Request license for new installation
  • Examples for diagrams
  • Request a new license
  • How to perform a publication
  • Dividing fields into blocks
  • Creating new themes for Scriptcase
  • Creating custom menus
  • Macro sc_block_display
  • Creating and Using a library in Scriptcase
  • How to perform a deployment on Scriptcase - Advanced
  • How to perform a deployment in Scriptcase - Typical
  • Deletes my application, can I recover it?
  • Using the Database Builder
  • Field with Validation Image
  • Hotkeys on Scriptcase
  • Using Languages in Scriptcase
  • Report on the Application List Scriptcase
  • Project Search
  • Generating Diagnosis in Development
  • Melhorando performance do banco de dados com MySQL Tuner
  • CEP Type Field
  • Import and Export applications on Scriptcase
  • Tips for HelpCase
  • Registering your License on Scriptcase
  • Using sc_ajax_refresh()
  • Place menu background image
  • How to create a button link
  • Converting Projects to Scriptcase 9
  • How to create an edit link
  • How to create a capture link
  • How to create a field link
  • Using two search applications to access a form
  • Oracle Connection - Scriptcase 9 - Linux 64 Bits
  • How to switch between themes dynamically through the Menu app
  • PHPSpreadSheet library with Scriptcase
  • How to create an application link
  • Add a record to another table from a condition
  • Notifications in Scriptcase
  • Using a TAB application with several applications and with a single parameter
  • Hide new grid button at runtime
  • Example animation inside scriptcase
  • Change the charset to view the records.
  • Summary by Developers in Scriptcase
  • Multithreading in Scriptcase
  • Scriptcase customization
  • Creating Custom Buttons
  • Express Edit
  • Default values in Scriptcase
  • Using friendly URL
  • Data dictionary
  • Open PDF in the Browser
  • Installing Firebird 3.0 service and database administrator in Linux
  • Access Import
  • Error sending mail: stream_socket_client()
  • Filtering data within a grid
  • Limit number of records to be displayed in the Grid
  • Use of the log in Scriptcase
  • Restoration of Scriptcase from the devel folder
  • Verification of libraries installed in Linux production environment
  • Changing Phrases in the Scriptcase Menus
  • EXCEL Import
  • CSV Import
  • Filter on Form Aplication
  • Enable mbstring extension in CentOS
  • Install multiple versions on the ScriptCase server
  • Fatal error: Allowed memory size
  • Restore Backup
  • Updating the environment from your Scriptcase 9 to PHP 7.3
  • Restarting Scriptcase's apache
  • Backup
  • Correcting access error for the Scriptcase database
  • System error, missing file api-ms-win-crt-runtime-l1-1-0.dll
  • Configurar IIS7 con PHP 7.0.30
  • Change user "admin" permissions
  • Connection error: error_profile_test_module
  • Incompatibility errors with after PHP 7.0
  • Change Time Zone in the php.ini
  • PHP extensions
  • PHP error level - error_reporting
  • Installing Scriptcase in XAMPP with PHP 8.1 - Windows
  • Gantt Chart
  • Enabling hotkeys on Scriptcase
  • Creating a Dashboard application
  • Crear menú de aplicación
  • Using ajax: onChange events
  • Calendar By User
  • Configuring Generation of PDF
  • Creating a field that verifies values in another table
  • Setting Up a Proxy in Scriptcase
  • Application Diagram – Graphiz Installation on Debian based Linux Platform
  • The size of the backup file is larger than supported by PHP
  • Manual Installation of Scriptcase 8
  • Setting Scriptcase on windows 2003 with IIS 6.0
  • Instalando o PHP no IIS - Windows 2000/XP
  • Generating Credentials for Authentication with Facebook
  • Fixing the problem of Zendid Execute Permission
  • How to create a LDAP Database on Windows Server
  • New export formats in Chart applications
  • Using tags in the Chart search
  • How to create a simple LDAP Database on Linux
  • Using inline buttons in the Advanced Grid Search
  • Email Export in Charts
  • Enabling Nested Grid export on XLS
  • Using tags in the grid search
  • Setting the Group by level in PDF exports of the Grid chart
  • Connection to MSSQL database (SQL Server)
  • Enable ZendGuard Loader - Linux
  • Enable ZendGuard Loader - Windows
  • Setting environment manually PHP 5.4 - Linux
  • Parallel Installation of Scriptcase
  • Configurando ambiente manualmente PHP 5.4 - Windows IIS
  • Enable ZendGuard Loader - MacOs
  • Setting environment manually PHP 5.4 - Mac OS X
  • Setting environment manually PHP 5.4 - CentOS
  • Setting environment manually PHP 5.6 - Mac OS X
  • Setting 'config.php'
  • Setting environment manually PHP 5.6 - Linux
  • Setting environment manually PHP 5.6 - Windows
  • Using Ajax Processing(Refresh)
  • How to change the application's state in run time
  • Show Question Message with SweetAlert - sc_alert
  • Show Warning Message with SweetAlert (warning) - sc_alert
  • sc_alert - Show Information Message with SweetAlert (info)
  • sc_alert - Show Confirmation Message with SweetAlert (success)
  • sc_alert - Show Error Message with SweetAlert (error)
  • Dynamically change the theme of a project with the sc_set_theme macro
  • Setting environment manually PHP 5.6 - CentOS
  • Setting environment manually PHP 7.0 - Windows IIS
  • Change Database Context – MSSQL
  • 'No tables found in database access' error while trying to import Access data.
  • Informix Connection - Scriptcase 8.1 - Linux
  • DB2 Connection - Scriptcase 8.1 - Linux
  • Oracle Connection - Scriptcase 8.1 - Linux
  • MSSQL Server Connection - Scriptcase - Mac OS X
  • Filtering Connection Database - Oracle
  • Manipulate a button display dynamically
  • Using macros sc_begin_trans, sc_commit_trans and sc_rollback_trans with Alert Message
  • Hide certain fields in a Grid by means of various conditions
  • Using the macro sc_date_dif_2
  • Using the macros sc_begin_trans, sc_commit_trans and sc_rollback_trans
  • Example of sc_apl_conf
  • Using the sc_field_display macro
  • Macro sc_error_continue
  • Executing SQL statements (Insert, Update and Delete)
  • Macro sc_date
  • DB2 connection - Scriptcase
  • Connection with MSSQL Database
  • How to use local storage in your browser
  • Update a widget based on another widget.
  • Cambiar el estilo de un campo dentro de un Formulario Registro Unico
  • Filter Oracle Connection
  • Sample Bank Billet
  • How to make a report in PDF using code
  • Navigate between tab dynamically
  • Displaying username in the Menu Header
  • Create a folder using PHP code
  • jbcmotos.myscriptcase.com, ola
  • Enabling DropBox API
  • Fatal error: Uncaught GuzzleHttp\Exception\RequestException
  • How to change the width of your application.
  • Necessary libraries to install the Scriptcase in Windows 7
  • Enabling Amazon S3 API
  • Enabling Google Drive API on the Google Console
  • How to configure a new rule in the Save grid option
  • How to change the log module table
  • Using the sc_confirm macro
  • How to add themes to an existing project
  • Adding Google Fonts to a Theme
  • What is ScriptCase?
  • How to generate auth_code and token_code
  • How to edit records from a capture link.
  • Fixing session issue when logging into Scriptcase
  • See how to generate recaptcha credentials
  • Manual Password Reset
  • Defining extensions for upload type fields
  • Authentication with Facebook from a Control application
  • Generating Credentials for Authentication with Twitter
  • Configuring Email API in ScriptCase
  • Security Module Two-Factor Authentication - Google Authenticator
  • Configuring SMS API in ScriptCase
  • Enabling Two-Factor Authentication (2FA) in the Security of our Project
  • Configuring the Google Authenticator API in ScriptCase
  • History and Version Increment in ScriptCase
  • Manual Backup
  • Hide/Show "New User" field on login screen with HTML template
  • Hide/Show "Retrieve Password" field on login screen with HTML template
  • Hide/Show "Remember Me" Field on Login Screen with HTML Template
  • Fatal error: Array and string offset access syntax with curly braces is no longer supported
  • Install ScriptCase PHP 7.3 on a XAMPP in Linux
  • Installing Scriptcase in XAMPP with PHP 7.3 - Windows
  • Installing Scriptcase PHP 7.0 in a Xampp on Windows
  • Install ScriptCase PHP 7.0 on a XAMPP on Linux
  • Install ScriptCase PHP 8.1 on a XAMPP on Linux
  • Scriptcase Installer for Windows - PHP 7.3
  • How to Register my Scriptcase
  • Automatic installation of Scriptcase - PHP 7.3 Linux
  • Installer for macOS - PHP 7.3
  • Installing PHP 7.3 - macOS
  • Installing PHP 7.3 - Linux
  • Installing Scriptcase with PHP 7.3 on Windows
  • How to use the Accent insensitive option
  • How to configure Amazon S3
  • Connecting with Firebird on linux - PHP 7.3
  • Connecting with Firebird on macOS - PHP 7.3
  • How to find my serial in Scriptcase
  • Connecting with Firebird on Windows - PHP 7.3
  • Getting Credentials on Stripe
  • Creating your credentials in Mercado Pago
  • Getting Credentials on Braintree
  • Finding my serial on the site
  • How to do a Offline Registration
  • Creating Your Credentials for the Google Sheets API
  • Creating a Field grouping
  • Creating the Google Maps API Key
  • Update of the security module synchronization application
  • Setting environment manually PHP 8.1 - Windows IIS
  • Security module password recovery error
  • Offline Documentation
  • Retrieve password
  • Resolving email sending issues with the sc_mail_send macro on Linux or Mac.
  • How to Generate the Report for PHP Migration
  • Updating the Security Module to Support the New LDAP
  • Upgrading the Security Module: how to migrate from the old to the new
  • Enabling the Google Identity Service Library
  • Updating the Security Module to Support Google Login
  • wkhtmltopdf update
  • Fixing the Oracle Connection Error: ORA-12154
  • Corrigindo sincronizar aplicação no módulo de segurança
  • Compatibility Adaptations for PHP 8.2
  • PHP 7.x to PHP 8.2 Migration Guide
  • Installing PHP 8.1 - Linux
  • Instalando
  • Installing PHP 8.1 - MacOS
  • Generating the reCAPTCHA keys
  • Updating the cacert.pem File in the Scriptcase Environment
  • Installing Scriptcase with PHP 8.1 no Windows
Host
  • How to install WordPress?
  • How to update WordPress?
  • How to migrate your local Scriptcase to your hosting account
  • How to select the main PHP version for your hosting service
  • How to check Bandwidth Usage?
  • How to install and access Scriptcase in your hosting account
  • How to install a application with Softaculous
  • How to install Auto SSL certificate
  • How to blacklist a IP address
  • How to install SSL certificate
  • How to protect a folder with username and password
  • How to protect your Website's images from an external Website
  • How to check disk usage
  • How to use the Google Public DNS
  • How to change language of your cPanel
  • First steps with hosting: Registration
  • How to change cPanel style theme
  • First steps with the Hosting: access
  • How to update your contact informations
  • How to change my cPanel account password?
  • How to block any IP address
  • How to change the timezone of your host?
  • How to restrict Directory Access by IP address
  • How to disable directory browsing
  • How to protect .htaccess file?
  • How to connect a FTP account
  • How to create a file in File Manager
  • How to create a FTP account
  • How to edit a file in FIle Manager
  • How to use File Manager and upload a file
  • How to perform a database restoration with Jetbackup
  • How to perform a restoration of Folder and Files with JetBackup
  • How to perform a restoration of a CronJob with JetBackup
  • How to perform a restoration of Email Accounts with JetBackup
  • How to receive JetBackup notifications
  • How to perfom a Full Account restoration with JetBackup
  • How to restore Firebird backup from the terminal?
  • How to see the JetBackup queue
  • How to perform a restoration of a DNS Zone with JetBackup
  • How to perform a restore of a SSL Certificate with JetBackup
  • How to create a table in PhpMyAdmin?
  • How to export your database in phpMyAdmin?
  • How to change database charset - MySQL
  • How to create a VIEW in phpMyAdmin?
  • How to create Procedure in phpMyAdmin?
  • How to import a database in PhpMyAdmin?
  • How to access PhpMyAdmin in your hosting?
  • Error "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"
  • Import a CSV file to MYSQL in PHPMYADMIN
  • How to remove a domain or subdomain redirection
  • How to remove Parked(alias) Domain in cPanel
  • How to remove a Subdomain
  • How to remove an addon domain
  • How to change the DNS to Scriptcase Host
  • How to prevent your email from being classified as Spam
  • Authenticate an email account in the Gmail WEB
  • How to Park(alias) a Domain in cPanel?
  • How to add a domain in your hosting service
  • How to use GMAIL SMTP in hosting applications
  • How to change the password of a email account
  • How to forward emails
  • How to reset the password of your email account
  • How to setup a email client with a hosting email account
  • How to use the emails of hosting account with a external SMTP server
  • How to create a autoresponder email
  • How to access your email account from Webmail
  • How to check Bandwidth Usage?
  • How to perform a publication in your hosting service?
  • How to access your account with SSH
  • How to upload a firebird database to your hosting acount
  • How to check your hosting disk space
  • How to create a Web Disk account
  • How to create and change the Firebird password
  • How to connect to firebird database on hosting
  • How to create firebird database on your hosting
  • Cron Jobs
  • GLOBAL EMAIL FILTERS
  • Indexes
  • Directory Privacy
  • Email Disk Usage
  • Visitors
  • Email Routing
  • Customize error pages
  • Select PHP Version
  • Default Address
  • Configure Greylisting
  • Creating a MySQL Database
  • Virus Scanner
  • Track DNS
  • Remote Dtabese Access
  • Forwarders
  • TXT record
  • MIME Types
  • Track Delivery
  • Email Filters
  • Spam Filters
  • PostegreSQL Databases
  • MySQL Database
  • How to import/export a MySQL database
  • Snapshots
  • How to import/export a PostgreSQL database
  • JetBackup Settings
  • How to add a domain redirect
  • Leech Protection
  • Jetbackup 5 - Overview
  • Jetbackup 5 - Full Backups : How to restore your cpanel account
  • JetBackup 5 - Home Directory : How to restore file and folders
  • JetBackup 5 - Cron Jobs : How to restore Cron Jobs
  • JetBackup 5 - Databases : How to restore a database
  • JetBackup 5 - Database Users : How to restore a database user
  • JetBackup 5 - DNS Zones : How to restore a DNS zone
  • Hotlink Protection
  • JetBackup 5 - Email Accounts : How to restore an email account
  • JetBackup 5 - Manage Account : How to add an email to receive notifications
  • JetBackup 5 - View Downloads : How to view download history
  • JetBackup 5 - FTP Accounts : How to restore an FTP account
  • JetBackup 5 - Queue
  • Manage API Tokens
  • Raw Access
  • MultiHP Manager
  • Analog Statistics
  • How to create email accounts
  • Optimize website
  • Autoresponders
  • E-mail deliverability
  • How to prevent your server's IP from ending up on a blacklist
  • How to create a subdomain in cPanel
  • How to associate the user with the PostgreSQL Database
  • How to create a PostgreSQL database
  • How to Synchronize User Privileges - PostgreSQL
  • How to create a PostgreSQL database
  • How to create a user for PostgreSQL database
  • File Transfer via FTP
  • How to Fix Permissions on Your Hosting
  • Establishing remote connection to the MySQL database
  • How to Create an Upgrade/Downgrade Request
  • How to open a ticket.
  • How to update Scriptcase
  • How to Add SPF, DKIM, and TXT Records in cPanel
  • How to Import a Large Database via SSH
  • How to use the Setup Python App
  • How to generate a MySQL backup using mysqldump
Home Scriptcase Limit number of records to be displayed in the Grid

Limit number of records to be displayed in the Grid

Open in
View as Markdown
Open in ChatGPT Open in Claude
Á

Álvaro Moura

Last updated on Jul 9, 2026

To limit the number of records to be displayed, we will use the Limit function within the query where they bring the data of a certain table.

For example in this way:

Then only 5 records are shown:

Back to Scriptcase
Made with Chatwoot Chatwoot