ElegantInsights
AI settingsSQL Column Detail

SQL Column Detail

Controls column selection in SQL queries.

Last updated on

Default: balanced · Type: Concise, Balanced, Detailed

Controls how many columns the assistant selects in generated SQL. Concise returns only the critical columns needed to answer the question; Balanced is the standard level of detail; Detailed adds extra helpful columns for context and enrichment. Fewer columns generally mean smaller, faster reports.

What changes

Concise selects only the essential columns; Detailed adds extra context columns and joins (Site, Agent, Ticket Type).

Concise

sql
SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    ts.TStatusDesc AS [Status]FROM Faults fJOIN TStatus ts ON ts.TStatus = f.StatusWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

Detailed

sql
SELECT    f.FaultID AS [Ticket ID],    f.Symptom AS [Subject],    a.aareadesc AS [Customer],    s.SDesc AS [Site],    u.UName AS [Agent],    ts.TStatusDesc AS [Status],    rt.RTDesc AS [Ticket Type],    f.DateOccured AS [Date Opened]FROM Faults fJOIN Area a ON a.AArea = f.AreaIntJOIN Site s ON s.SSitenum = f.SiteNumberJOIN Uname u ON u.UNum = f.AssignedToIntJOIN TStatus ts ON ts.TStatus = f.StatusJOIN RequestType rt ON rt.RTID = f.RequestTypeNewWHERE f.FDeleted = 0    AND f.Status <> 9    AND f.DateOccured >= @startdate    AND f.DateOccured < @enddate

Where to change it

Set this under Profile → Prompt settings in the app. See all AI settings.

Custom Instructions

Add your own specific requirements for the AI assistant.

SQL Comments

Include /* */ explanatory comments.

On this page

Where to change it