tprouvot / Salesforce-Inspector-reloaded

Chrome extension to add a metadata layout on top of the standard Salesforce UI to improve the productivity and joy of Salesforce configuration, development, and integration.
https://chrome.google.com/webstore/detail/salesforce-inspector-relo/hpijlohoihegkfehhibggnkbjhoemldh
MIT License
215 stars 66 forks source link

[data-export] Select all fields on an object for a SOQL Query #388

Closed BL-isidle closed 6 months ago

BL-isidle commented 6 months ago

Is your feature request related to a problem? Please describe. I need to backup a set of records before performing mass update or delete and want to capture a csv of all the fields on it... Presently I need to switch to a different tool to get the query or manually select each field one by one

Describe the solution you'd like Add a "button" or even better a "Picklist" under "field suggestions" to select all available fields (with different flavors below).

Describe alternatives you've considered Possible options 1 - (Simple and common) Loop through all of the fields and make a comma separated list. [Just this would be a big improvement and I think the data is already available] 2 - (Better) Generate a list of all fields the running user has access to, checking for FLS visibility first [It is relatively common for deprecated fields to be hidden via FLS, even from admin but they still physically exist] 3 - (Reach) - Add a list of "editable" fields [Since formula fields only present a calculated value but do not store a value themselves, they cannot written to and therefore has is nothing to "roll back" if an update was performed mistakenly & need to load the data back.

Some objects have MANY of these fields and the update will fail trying to write to a read-only field]

Additional context Yes, FIELDS(ALL) works if there is less than 200 records but it is very common to need to update more than that... Also IMO the logic is too simplistic for some use cases (e.g. ignores FLS and editable)

Other tools have something simular to this (workbench, data loader, XL-Connector)

image

tprouvot commented 6 months ago

Hi @BL-isidle, It is already possible, I added a new section in the documentation