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