Search for data fields used in all workflows | Community
Skip to main content
AC_Bella
AC_Bella
Level 2
January 30, 2019
Solved

Search for data fields used in all workflows

  • January 30, 2019
  • 6 replies
  • 5394 views

Hi y'all,

I hope one of you is able to help me

I have to change the name of a field in a data schema. That field is used in several workflows (queries, enrichment, extraction...). When I change the name in the data schema I need to adjust the queries and so on. Is there a way to get a list of all workflows which use the edited field? I do not wanna go through every single activity of each workflow (we have lots!).

The only thing I managed so far is a list of all workflows with the text of queries... I am thankful for any hints!

Best,

Bella

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Didn't realize that was possible, xtk still surprises me. Alright follow these steps:

  1. Create a new workflow folder, right-click it, properties, restriction tab, check this folder is a view, ok, ignore warning
  2. Add a filter, data contains old field etc
  3. Select all workflows that appear, paging display as needed (click double-arrow under scrollbar)
  4. Right-click, actions, export in a package, export now, copy to vs code or notepad++ (notepad can have issues with utf-8)
  5. Save to desktop as backup file
  6. Replace-all to change the old fields to the new ones
  7. Save to desktop as new file
  8. Import new file to Campaign
  9. Delete workflow folder from 1

6 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity Advisor
Community Advisor
January 30, 2019

Hi,

Use generic query editor (under Tools at top menu) to search xtk:workflow, the ‘data’ field. Put folder/@fullname in the result fields.

Thanks,

-Jon

AC_Bella
AC_BellaAuthor
Level 2
January 31, 2019

Hi Jon,

thanks for your quick reply! Unfortunately, that is not what I needed. Your suggestions returns the path were the workflows can be found. But I need to know which workflows have the field I changed, first.

For example: I need to rename EMAIL_NUTZUNG. After the change I have to adjust all workflows which use that field. So far I only managed to get this: of all workflows the text of one query.

Not really helpful since I have to check every single query in the list and I can't see whether the field EMAIL_NUTZUNG is used in other activities of the workflow too...

Any ideas?

Thanks,

Bella

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity Advisor
Community Advisor
February 1, 2019

Add internal name to the result fields.

For activity-level search, edit the workflow xml (ctrl-f4 when viewing), then find-all the text by pasting into vs code or notepad++.

AC_Bella
AC_BellaAuthor
Level 2
February 1, 2019

That helps a little, thanks!

But the other problem remains: if a workflow has several queries the generic query editor only returns the text of one. The following one has 5.

<col>

    <val>WKF1049</val>

</col>

<col>

    <val>Abfrage: ANZ_PRD_KREDIT_KART gleich 0</val>

</col>

<col>

    <val>Onboarding_ITPPC-17</val>

</col>

Do you know how I can get the text of all queries in a workflow?

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    February 1, 2019

    Didn't realize that was possible, xtk still surprises me. Alright follow these steps:

    1. Create a new workflow folder, right-click it, properties, restriction tab, check this folder is a view, ok, ignore warning
    2. Add a filter, data contains old field etc
    3. Select all workflows that appear, paging display as needed (click double-arrow under scrollbar)
    4. Right-click, actions, export in a package, export now, copy to vs code or notepad++ (notepad can have issues with utf-8)
    5. Save to desktop as backup file
    6. Replace-all to change the old fields to the new ones
    7. Save to desktop as new file
    8. Import new file to Campaign
    9. Delete workflow folder from 1
      AC_Bella
      AC_BellaAuthor
      Level 2
      February 1, 2019

      Thank you so much, Jon! That's exactly what I needed! You saved my day!!!

      Have a great weekend!

      Best, Isabelle

      Terms & ConditionsAccessibility statement

      Loading footer...