SOQL Dashboard Engine

A Rails engine that provides a dashboard interface for querying Salesforce using SOQL.

Features

  • Query Salesforce objects using SOQL
  • View results in a user-friendly dashboard
  • Audit trail for all SOQL queries with user tracking
  • Easily mountable in any Rails application

Installation

Add the engine to your application's Gemfile:

gem 'soql_dashboard'

Then run:

bundle install
rails generate soql_dashboard:install
rails soql_dashboard:install:migrations
rails db:migrate

This will create the necessary database table:

  • soql_dashboard_audits - tracks all query executions for audit purposes

Mounting the Engine

In your application's config/routes.rb:

mount SoqlDashboard::Engine => '/soql_dashboard'

Usage

  • Visit /soql_dashboard in your browser to access the dashboard.
  • Select a Salesforce model and run SOQL queries.

Development

To work on the engine:

cd engines/soql_dashboard

Run tests:

bundle exec rspec

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

MIT