Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[data-export] Add Query Template to Options page #349

Closed
chanclement8 opened this issue Mar 13, 2024 · 3 comments
Closed

[data-export] Add Query Template to Options page #349

chanclement8 opened this issue Mar 13, 2024 · 3 comments
Assignees
@tprouvot
Labels
enhancement New feature or request

Comments

@chanclement8
Copy link

Is your feature request related to a problem? Please describe.
There will be times where i will need to create SOQL with the WHERE condition of field NOT LIKE '%abc%'. there are times where i dont remember the exact format and have to google for it.

Describe the solution you'd like
It would great if we can enhance the Template drop down to include a SOQL snippet for WHERE clause with NOT LIKE. Example below
SELECT ID FROM ACCOUNT WHERE (NOT Name like 'ABC%')

Describe alternatives you've considered
Quick google to search for the exact syntax

Additional context
image
@chanclement8 chanclement8 added the enhancement New feature or request label Mar 13, 2024
@tprouvot
Copy link
Owner

Hi @chanclement8 ,
You can add your own templates by following this article

https://tprouvot.github.io/Salesforce-Inspector-reloaded/how-to/?h=templa#add-custom-query-templates

@tprouvot
Copy link
Owner

Since this is not very user friendly I can add this option to the options page

@tprouvot
Copy link
Owner

Should be available in 1.23 and beta earlier !

image

@tprouvot tprouvot mentioned this issue Mar 15, 2024
Merged
6 tasks
tprouvot added a commit that referenced this issue Mar 15, 2024
@tprouvot
Add query template to option page (#355)
c4ce8d8 
## Describe your changes
Add query templates to Option page

<img width="895" alt="image"
src="https://github.com/tprouvot/Salesforce-Inspector-reloaded/assets/35368290/6e028e25-cb53-436a-8323-ee9920c15dc7">

## Issue ticket number and link
#349 

## Checklist before requesting a review
- [x] I have read and understand the [Contributions
section](https://github.com/tprouvot/Salesforce-Inspector-reloaded#contributions)
- [x] Target branch is releaseCandidate and not master
- [x] I have performed a self-review of my code
- [x] I ran the [unit
tests](https://github.com/tprouvot/Salesforce-Inspector-reloaded#unit-tests)
and my PR does not break any tests
- [x] I documented the changes I've made on the
[CHANGES.md](https://github.com/tprouvot/Salesforce-Inspector-reloaded/blob/master/CHANGES.md)
and followed actual conventions
- [x] I added a new section on
[how-to.md](https://github.com/tprouvot/Salesforce-Inspector-reloaded/blob/master/docs/how-to.md)
(optional)
@tprouvot tprouvot changed the title New SOQL Template for NOT LIKE [data-export] Add Query Template to Options page Mar 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@tprouvot tprouvot

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@chanclement8 @tprouvot