The Table Widget in OpenLIT is designed to display raw or structured data in a readable, paginated table format. It’s perfect for logs, event traces, audit trails, or any dataset you want to explore row by row.

​
📌 Use Cases

  • Displaying raw logs or error records
  • Viewing user activity, API calls, or event data
  • Showing detailed reports or audit trails
  • Exploring top rows of a complex query result

​
🛠️ How to Add a Table

Example:

SELECT
  user_id,
  action,
  timestamp,
  properties
FROM user_events
WHERE event_time BETWEEN {{filter.timeLimit.start}} AND {{filter.timeLimit.end}}
ORDER BY timestamp DESC
LIMIT 100

​
⚙️ Features

  • Horizontal and vertical scrolling
  • Choose colors theme
  • Dynamic bindings for time ranges or filters

Use dynamic filters like {{filter.timeLimit.start}}, {{filter.timeLimit.end}} to make the stat card responsive to dashboard-level controls.

​
✅ Best Practices

  • Use aliases for column names for readability (AS user_email, AS created_at)
  • Limit unnecessary columns—focus on actionable fields
  • Use {{filter.timeLimit.start}}, {{filter.timeLimit.end}} to make tables dynamic