Grid SQL query for the pages without Debug Grid
Whenever you need to retrieve the SQL query that the grid uses to fetch the displayed data, please follow these steps.
๐ Instructions
Before proceeding, ensure you have access to the SSH path of the project or non-production environment.
Open your terminal and run the command:
cd go/src/ra/grids/routes.Identify the route of the page you require. For instance, if the URL is
https://aec-v10-project.wenergysoftware.com/well_completions, the route iswell_completion(in singular form).In the terminal, execute the command
lsto check for a file namedwell_completion.go.Open the file by running:
nano well_completion.go.Although the code structure may vary, the SQL queries and filters you see are what is being utilized. You can search for the
SELECTkeyword by pressingCtrl + W, and continue pressing it to find subsequent instances of the keyword.
You can also verify the same files using SSH in VS Code to connect.