omniphx/adminite

Adminite is a new SOQL, SOSL query editor application providing Salesforce developers and administrators with context-aware auto completions and more.

Adminite

Development

Setting up a Connected App

1. Log into to your Salesforce org
2. Click on Setup in the upper right-hand menu (Classic)
3. Build > Create > App
4. Under Connected Apps, click "New"
5. Create an app with the following settings:

• Connected App Name
• API Name
• Contact Email
• Enable OAuth Settings under the API dropdown
• Add the following scopes:
  • Access and manage your data (api)
  • Access your basic information (id, profile, email, phone)
  • Perform requests on your behalf at any time (refresh_token, offline_access)
  • Provide accesss to your data via the Web (web)
• Set callback URL to:

  http://localhost:42834/callback
  http://localhost:29562/callback
  http://localhost:38853/callback
  http://localhost:40011/callback
  http://localhost:44774/callback
  http://localhost:47599/callback
  

• Require Secret for Web Server Flow - checked

Run locally

1. yarn install
2. Create a .env file and your consumer key/secret:

ELECTRON_WEBPACK_APP_SALESFORCE_CLIENT_ID=<your-consumer-id>
ELECTRON_WEBPACK_APP_SALESFORCE_CLIENT_SECRET=<your-consumer-secret>

3. yarn dev

adminite's Issues

Autodetect query object

If no object is entered you could use a regular expression on the query content to find the last instance of from (to avoid subqueries in the earlier part of the query) and then regular expression the next full word you could see if that matches the list and auto-detect if one wasn't specified in the query and update.

Pagination should account for filtered records

Zeros appear as blank instead of "0"

Resizable columns

Add ability for SOSL search

Allow a hot key for query execution

As a user it would be nice to be able to execute a query via keyboard shortcut.

Can't set percent field to null

When editing fields via adminite, I can't set a populated field to null and save (0 only).

Export extra columns from data output

When exporting, additional columns for "attributes" and "key" are added into the CSV that are unrelated to the data or query.

Allow client to be updated automatically/manually

When a new version of adminite is released, user can be prompted to update or have an option for users to manually update to the latest version.

Environment Authentication Leads to Ever-Loading Authentication Page

Steps to reproduce:

1. Go to Adminite
2. Click New environment (top left option)
3. Set value for Name, Environment
4. Click Connect
5. See Browser window/tab open to authenticate
6. Sign in or Choose user for that appropriate environment
7. See Browser forever-load until times out

Expected Outcome:

1. Environment is authenticated and available as selection in Adminite (This works!)
2. Browser tab closes or stops loading ¯_(ツ)_/¯

Add version information

Recommending adding the version somewhere in the app so you can check related to bugs.

Allow tabs inside query editor

As a user I would like to be able to format my queries, it would be nice to be able to use tabs inside the query editor.

Object field list

When writing queries, I often have to figure out what the field name is for what I'm looking for. There's intellisense on the object names but not the fields. A nice feature (outside of the autocompletion) would maybe be if you selected an object in the query (ex double click, perhaps identifying also subquery relationships too) you could somehow pull up the complete field list to see all the fields (kind of similar to workbench dropdown). Sometimes fields have prefixes etc that make the autocomplete less useful vs just checking the list.

New query window window focus

Upon opening a new tab (via button or potentially hotkey) the input focus should be put in the query window by default.

Feature: Pagination at top

Currently pagination is only at the bottom of the results. It would be useful (especially with higher page counts) to have pagination at the top as well to avoid having to go to the bottom of the results.

Mass update/delete

Ability to mass update or delete rows and columns

Export performance

I've noticed a few times that export performance (after choosing type and folder) can be very slow intermittently. This was on a Mac and trying to open finder/etc just has it spinning and adminite is frozen. It seems to happen after querying (and potentially) exporting a previous large dataset. Closing that large dataset tab doesn't seem to improve (guessing some memory leak perhaps). Save time was 2 minutes for a file that contained 60 rows. Previous export was 55k rows. Closing and reopening it executes basically immediately.

Export Query to Excel on PC

Currently, when exporting a query on a Windows Machine, the file is saved in downloads as an "Internet Explorer" Type file, rather than an Excel/CSV. This makes it difficult to transform/do anything with the export. PLEASE MARTY FIX IT NOW I KNOW YOU DON'T HAVE A LIFE OR GIRLFRIEND OR ANYTHING SO JUST DO ITTTTTTTTTTTT

Blank out connection name when creating a new connection

When on an existing connection, when going to create a new connection, the name will automatically populate with a previously created connection.

Darkmode

Might be able to toggle with https://github.com/ant-design/ant-design-dark-theme

Export issues for relationship values

When querying on values through the lookup, the export shows as [object Object] instead of the actual value (ex. Custom_Object__r.Field__c). In the UI it shows the correct value.

Syntax highlighting

Syntax highlighting in queries for words such as SELECT/FROM/WHERE/LIMIT/AND/Quotes

Load/History tables should allow sorting and filtering

After exporting a file, provide option to show in folder

Export additional options

Currently the only export option is CSV but often times I need to share these files with less savvy users and they prefer Excel. Adding the ability to choose exporting to say CSV, EXCEL, PDF would be nice additions.

Sub query rows remain expanded after running a new query

1. Run a query

SELECT Id, (SELECT Id FROM Cases) FROM Account

2. Expand rows with subqueries
3. Run a new query without subquery

SELECT Id FROM Account

4. Expanded sections should collapse

AND/OR clauses should not indent when using "Format" feature

Add fields top check doesn't check all

On the new add fields option if you check the top checkbox it doesn't do anything. Ideally it would check or uncheck all the selected fields. The only way to add all the fields is to manually check them.

remove floating 'x' under query box

There is an 'x' character floating in limbo under the query box

Shareable Saved Queries

As a SF Admin, I would love to be able to share my saved queries with others so that I do not need to copy and paste the queries to my amigos.

Clickable hyperlink result values

It would be great to have any fields set as a hyperlink/url (perhaps just detect starting with http:// or https:// have a clickable link similar to how Id values do to open up the link in a browser.

Persist open queries when adminite is closed

As a user, I sometimes close adminite without saving my queries. It would be nice to be able to re-open adminite and have the queries persist from the last session.

Ability to open multiple windows

Implement the ability to open multiple windows/orgs to query from

Fields should not be editable in Aggregate queries

Saving will crash the app

Export should be disabled until query complete

Currently you are able to click export while it's still paginating the results down which can lead to having an incomplete export. I would recommend disabling the button while the query is still running.

Bulk Update cannot update more than 200 records at a time

I queried the contact object using this type of query:
SELECT Id, Name, Email, AccountId
FROM Contact
WHERE EMAIL LIKE '%gmail.com'

I pulled over 1k results and set the max page size to 200.
I go to update and click bulk update -> and update the account id.
I click apply and the accountid turned yellow.
Then I click save changes and nothing happened.

I am curious if I am doing it right?

Bug: Add Fields - Selecting Fields from Multiple Filter fields selection Doesn't Apply when invalid query statement in editor

Uber-low priority and definitely on the user....but logging for posterity

Preconditions:

1. Selected object in target object bar
2. Query Editor contained an invalid query "Select ID"

Steps to reproduce:

1. Click Add Fields
2. Enter value in 'Filter fields' bar
3. Select a field
4. Enter different value in 'Filter fields' bar
5. Select a field
6. Click Apply
7. See "Since your query is not valid, this will overwrite your current query. Are you sure you want to proceed?"
8. Click Yes
9. Nothing happens

Add ability to query with Tooling API

Rename columns

Open org from application

Highlight searched words

https://github.com/bvaughn/react-highlight-words

Settings for how tab is handled

This is an alternative to #31 for the shortcut execution. Currently the tab key actually inserts a Tab but I never use it for that and always use it for the Tab + Enter to execute the query (not supported in adminite). Depending on the other item, it would be nice to have some user/local preferences such as tab actually tabs to the query button vs \t and other potential preferences.

Ability to save/view historical queries

Implement the ability to save specific queries or go back and reference historical queries.

Toggle Switch for Intellisense

I am hoping that, like your previous project Soqoolio, that you have a toggle where we can turn off intellisense. More often than not, it gets in the way of me writing out SOQL or SOSL and I prefer to sometimes have it turned off.
Thanks!

Ability to delete an existing connection/org

Add the ability to remove a connection or org.

Rename a Connected Org

As a SF admin, I would love the ability to rename and reorder my environment connections so that I can re-enter a more descriptive connection label and not rely on the username

"fi" / "fl" text formatting

Very minor issue but if you type fi (ex. file) in the query editor, the view updates and shows the fi smaller and running into each other. It also happens with lowercase FL. Looks to be related to autoformatting. Doesn't affect functionality, just readability.

Ability to Insert All Fields of an Object in SOQL Query

As an SF admin, I would love the ability to insert all available API field names of an object into my SOQL query so that I don't need to reference a separate browser tab of said object and manually enter the fields.

UI responsiveness with large queried datasets

If you return larger datasets (ex. column search with 13k records) the UI responsiveness seems to slow down (for example when trying to go update the query there's a multi-second lag).

I found if I opened a new query tab however it's snappy so it must be issues with that specific view vs the app as a whole.

Certain queries causing app to crash

When running an aggregate/group by query pasted in it shows a little red circle in the corner (guessing it's validating query formatting even though query runs fine in workbench soqooli) and when I run it it just goes white almost immediately like it crashes.

When I took out the where clause it would run a little longer and then go to a white screen. When I took off the count and just returned the Id it worked. I'm thinking it's something in processing the aggregate values. I tried aliasing the count and that failed as well.

SELECT count(id) from Action_Sheet__c where reference1__c.reference__2.value__c IN ('0013Z000')

This was after the latest update