Advanced Search SQL Helper

You can use FortiAI to generate an Advanced Search (SQL) Query from natural language question, fix SQL errors and summarize Query results.

To generate a Query:

1. Go to Analytics > Advanced Search.

2. Click the FortiAI () drop-down and select Generate SQL.

3. In the dialog box, enter your desired query and click Generate.

4. In the FortiAI Chat window, FortiAI will show the generated SQL Query. You have two options from the FortiAI dialogue header:

   1. Click Replace Original Query () to replace the existing query with the generated query.

   2. Click Copy Query to Clipboard (). You can paste the query later.

5. Click Run to execute the query.

To fix a Query syntax error:

1. Click the FortiAI () drop-down and select Fix Errors.

2. In the FortiAI Chat window, FortiAI will show the generated SQL Query. You have two options from the FortiAI dialogue header:

   1. Click Replace Original Query () to replace the existing query with the generated query.

   2. Click Copy Query to Clipboard (). You can paste the query later.

3. Click Run to execute the query.

To summarize query results,

1. Make sure you have successfully run a query and Query Results are showing.

2. Click the FortiAI () drop-down and select Summarize Results.

3. In the FortiAI Chat window, the results will be summarized.