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

Dropping Data from a Temp Table

Avatar

Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tarquinius
Level 1

29-01-2021

Hi,

 

I have a continual delivery workflow that is looking for an External signal to activate.

As part of the workflow, I pull in a List for lookups against c1.4 million rows. Not ideal but best way of circumventing an issue. 

The workflow runs and sends the emails.

However the list never seems to get dropped but holds the data in a temp table (temp:readGroup). Is there anyway of dropping this data via a JS node once the email has sent? It's putting strain on the server since the workflow never really 'ends' continually eating memory when not needed etc.

Hope that makes sense!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile

Avatar
Validate 1
MVP
_Manoj_Kumar
MVP

Likes

111 likes

Total Posts

310 posts

Correct Reply

97 solutions
Top badges earned
Validate 1
Contributor
Ignite 1
Shape 1
Give Back 5
View profile
_Manoj_Kumar
MVP

30-01-2021

Hello @Tarquinius ,

 

First open the list and get the SQL table name from the content tab.

 

The you can use this code in the JavaScript activity in the end of the workflow:

sqlExec("TRUNCATE TABLE TABLE_NAME_HERE");

 

Thanks,

Manoj

 

 

Answers (3)

Answers (3)

Avatar

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

57 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
saikatk2447661
Level 3

10-02-2021

Hi @Tarquinius ,

 

  1. Put an end block after cont. delivery block.
  2. Use this in the advanced tab of end block:
sqlExec("drop TABLE "+vars.tableName);

vars.tableName with contain the temp table name that gets created in backend database. It will have name like wkf1163548174_64_1

 

Thanks,

Saikat

 

Avatar

Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tarquinius
Level 1

29-01-2021

Thanks for the response @adithyacs86 

Sorry. I may not have explained myself very well though! 🙂

 

The list is reused over and over each time the workflow is triggered. The problem is when the data is loaded into a temp table within the workflow, it's not getting dropped once the workflow has completed (probably because the workflow has a continual delivery and therefore never truly 'ends'). I don't want to purge the list - just the temp list load from the workflow (temp:readGroup by the looks of it).

 

I was hoping there might be a bit of JS code I could use in a node to simply purge the data in the table (temp:readGroup).

 

Thanks

Avatar

Avatar
Affirm 5
Level 3
adithyacs86
Level 3

Likes

22 likes

Total Posts

110 posts

Correct Reply

5 solutions
Top badges earned
Affirm 5
Validate 10
Validate 1
Give Back 5
Give Back 3
View profile

Avatar
Affirm 5
Level 3
adithyacs86
Level 3

Likes

22 likes

Total Posts

110 posts

Correct Reply

5 solutions
Top badges earned
Affirm 5
Validate 10
Validate 1
Give Back 5
Give Back 3
View profile
adithyacs86
Level 3

29-01-2021

Hi @Tarquinius , 

 

If I understand correctly,  we have the OOTB functionality in the List Update activity to purge the list entirely. 

 

adithyacs86_0-1611927309847.png

which can be used after the delivery is sent out.

 

Thanks,
Adithya