[data-export] Include a SOSL editor

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

185 stars 58 forks source link

[data-export] Include a SOSL editor #131

Closed ehsky closed 2 months ago

ehsky commented 1 year ago

Is your feature request related to a problem? Please describe.

I still use https://workbench.developerforce.com/ to create SOSL query's as i have not found a better alternative out there. Would be great to have this in the same plugin as Salesforce Inspector.

Describe the solution you'd like In the "Data-export" window i would like a button/switch/tab to go to a SOSL editor. In the SOSL editor i would like to be able to create SOSL queries as text input.

Describe alternatives you've considered

Extended SOSL version would be to give end users a UI to create the SOSL req similar to https://workbench.developerforce.com/.

dufoli commented 11 months ago

@tprouvot can you assign to me. I have well advanced (autocomplete 50%, execute 100%, design 0%) About UX, I have just add a checkbox SOSL. but we need a more better design to switch between SOQL and SOSL. Maybe we can autodetermine from query (SELECT or FROM => SOQL, FIND => SOSL)

tprouvot commented 2 months ago

Hi @ehsky This should be available soon in the beta version, would you like to do some tests ?

ehsky commented 2 months ago

Sorry for the late reply!

Downloaded the beta version and did some quick testing

Tested  

IN ALL FIELDS ✅ IN EMAIL FIELDS ✅
Wildcard ✅
AND, OR, AND NOT conditions ✅
Format(DateTime field)✅
ORDER BY ✅
ListView ✅

Remarks

WITH HIGHLIGHT - this did not work. But it also does not work in workbench.
WITH SNIPPET - half works. It returns a snippet.text section but is not highlighting the search terms. This works better then workbench as it is not supported there.

FIND {Best Regards} IN ALL FIELDS RETURNING Case(Id,  CaseNumber, Description) 
WITH SNIPPET

In a future version I would love to have field suggestions similar to SOQL.   

So far I’m very happy about current feature set 🙌

tprouvot commented 2 months ago

Thank you very much for testing @ehsky 🙏 👏 Yes I'm thinking about adding the suggestions also, just wanted to provide a quick way to support SOSL and GraphQL requests first.