search

forcedotcom / SFDX-Data-Move-Utility

SFDMU is a cutting-edge Salesforce data migration tool for seamless org population from other orgs or CSV files. It handles all CRUD operations on multiple related objects in one go.
BSD 3-Clause "New" or "Revised" License
438 stars 73 forks source link

[QUESTION] - Have multiple queries for 1 object (account) and then pull contacts for all those #804

Closed riekusr closed 1 month ago

riekusr commented 2 months ago

I want to create a usable sample set, therefore i want to grab 100 accounts from each type for example.

Example for accounts I want 200 total, 100 of each type: Select Id, Name from Account WHERE type='1' limit 100 Select Id, Name from Account WHERE type ='2' limit 100

Then I want to have all contacts of the fetched accounts.

What works:

But this means It isn't very modulair and I need to repeat a lot more objects for every 'type' of account.

Is there a way to run Account queries first, and then reference the fetched accounts to do the rest of the related operations?

hknokh commented 2 months ago

Hello, @riekusr

Thank you for reaching out. I will do my best to assist you as quickly as possible and will keep you updated on my progress.

Cheers

hknokh2 commented 2 months ago

Hello No it's not possible. Each object set acts as an independent job within a specific run.

github-actions[bot] commented 2 months ago

This case has been marked as 'to-be-closed', since it has no activity for the 3 days.
It will be automatically closed in another 3 days of inactivity.

github-actions[bot] commented 1 month ago

This case has been closed, since it has no activity for the last 6 days. Feel free to reopen it, if you need more help.