Skip to main content
Skip table of contents

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.

  1. Open your terminal and run the command: cd go/src/ra/grids/routes.

  2. Identify the route of the page you require. For instance, if the URL is https://aec-v10-project.wenergysoftware.com/well_completions, the route is well_completion (in singular form).

  3. In the terminal, execute the command ls to check for a file named well_completion.go.

  4. Open the file by running: nano well_completion.go.

  5. Although the code structure may vary, the SQL queries and filters you see are what is being utilized. You can search for the SELECT keyword by pressing Ctrl + 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.