Timeline for I want to search the list of SQL Query Activities which uses my target data extension in Select statements without explicitly storing them in DEs
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2023 at 16:26 | comment | added | vis_1019 | Thanks for the resources Jonas :) | |
| Jun 29, 2023 at 10:46 | comment | added | Jonas Lamberty | your question has indeed been answered: salesforce.stackexchange.com/questions/49814/… / - you will probably never find your exact usecase answered in a 500 character comment. If the linked answer doesn't help, you have to familiarize yourself with the various docs: ssjsdocs.xyz/contact-builder/dataextensions/retrieve - developer.salesforce.com/docs/marketing/marketing-cloud/guide/… developer.salesforce.com/docs/marketing/marketing-cloud/guide/… | |
| Jun 28, 2023 at 18:41 | comment | added | vis_1019 | I tried creating a new question, kind of got a notification saying it's a repetitive question / already answered. However, my query involves combination of solution within same ask which is not repetative I believe. I tried some workaround, my lack of knowledge is ssjs pulling me back. Kindly request you to help on the same. | |
| Jun 28, 2023 at 17:43 | comment | added | Jonas Lamberty | recommend to open a follow up question. I am probably the only person on stackexchange reading it here, vs. the whole community will see a new question ;) | |
| Jun 28, 2023 at 16:53 | comment | added | vis_1019 | A follow up question: Is it possible to pull the folder path of searching Data Extension within the same solution. In the sense can we combine the solution for searching the list of query activities using DE name and display the folder path of specified DE within same script. I am new to SSJS and could use some help. Thanks in advance. | |
| May 16, 2023 at 12:04 | comment | added | vis_1019 | Thank you Jonas! This really helped a lot. | |
| May 16, 2023 at 7:36 | vote | accept | vis_1019 | ||
| May 15, 2023 at 7:10 | comment | added | Jonas Lamberty | if you are looking for FROM which DE it pulls, then you need to look at the querytext. If you are looking at which DEs it writes into, in fact you have to look at dataExtensionTarget and can also use exact matching, as it is a genuine field and not free text. | |
| May 13, 2023 at 7:35 | comment | added | vis_1019 | Great! Thank you Jonas Laberty. As it searches querytexts as a whole, can we just limit it for identifying target Data Extensions and respective activity name similar to [Data Extension Inventory]:(sfmarketing.cloud/2020/05/20/…) (gortonington.com/sfmc-data-extension-inventory-take-2). | |
| May 11, 2023 at 7:49 | history | edited | Jonas Lamberty | CC BY-SA 4.0 |
added 43 characters in body
|
| May 11, 2023 at 7:13 | history | answered | Jonas Lamberty | CC BY-SA 4.0 |