search

jetstreamapp / jetstream

A better way to work on Salesforce
https://getjetstream.app/
Other
88 stars 18 forks source link

Sort Fields by Created Date in Manage Permissions View #900

Open LoganGanieanyReddit opened 5 months ago

LoganGanieanyReddit commented 5 months ago

A lot of times I will update FLS after a deployment in the Manage Permissions tab. It would be nice if we could sort the fields by created date so It's easier to find the fields that need updated

paustint commented 5 months ago

I did some digging on what this would take and it looks like the created/modified fields are not available on the query being used to fetch all fields regardless of current user's permission.

This will take some additional work to figure out options for obtaining this information and combining with results.

For the implementation, I was thinking to add a gear dropdown menu where the user can toggle on an option to show dates within the table.

SELECT QualifiedApiName, Label, DataType, DurableId,
    EntityDefinition.QualifiedApiName, FieldDefinitionId, NamespacePrefix, IsCompound, isCreatable, IsPermissionable
FROM EntityParticle
WHERE EntityDefinition.QualifiedApiName IN ('Account')
    AND IsPermissionable = TRUE
    AND IsComponent = FALSE
ORDER BY EntityDefinitionId ASC, QualifiedApiName ASC
LIMIT 2000
OFFSET 0
LoganGanieanyReddit commented 5 months ago

Would be really handy!! Thanks Austin