Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Search for data fields used in all workflows

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

30-01-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

01-02-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

Answers (5)

Answers (5)

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

31-01-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.

1681169_pastedImage_0.png

<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?

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

01-02-2019

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

Have a great weekend!

Best, Isabelle

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

31-01-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++.

Avatar

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
AC_Bella
Level 2

Likes

6 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
AC_Bella
Level 2

30-01-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.

1680325_pastedImage_0.png

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

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

961 likes

Total Posts

1,090 posts

Correct Reply

509 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

30-01-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