View & Edit Script

View & Edit Data Report Script

Access and modify the underlying SQL query in Tepun AI Report Builder.

Viewing the Script

1. Open the Report — Navigate to data report
2. Click View Script — Open script viewer
3. Review SQL:
   • SELECT: Columns retrieved
   • FROM/JOIN: Tables and relationships
   • WHERE: Filter conditions
   • ORDER BY: Sort configuration

Editing the Script

1. Click Edit Script — Enable editing
2. Modify Query:
   • Add columns: SELECT *, new_column
   • Add joins: LEFT JOIN related_table
   • Add conditions: WHERE amount > 1000
   • Add calculations: price * quantity AS total
3. Validate — Check for errors
4. Save Script — Apply changes

Learn about exporting and scheduling.