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

MeMonty
Community profile MeMonty Level 1
Job title here
Location here
4 BADGES
Level 1

Level 1

Learn more
Joined the community 10-03-2017 1:10:16 AM
Offline
Top badges earned by MeMonty
Customize the badges you want to showcase on your profile
Passing date to querydef
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Classic
Hi,I have written a function (as shown below) to fetch all the deliveries on a day. For the same I am passing two dates today & tomorrow (with time part of 00:00:00). But I am getting an errorError while executing the method 'ExecuteQuery' of service 'xtk:queryDef'.Unable to parse expression '@created >= Tue Mar 28 2017 09:42:30 GMT+0000 (UTC)'.Element 'Tue' unknown (see definition of schema 'Deliveries (nms:delivery)').// ========== function getDeliveries() ==========function getDeliveries(para...

Views

1.5K

Likes

0

Replies

1
Re: Fetch a Label instead of the Value of an enumerated field
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Classic
Hi Linda,Thanks for your response.I have explained in a reply to Vipul ... what I want to do.As per you, are you suggesting to hard coded the lables in Javascript?Regards,Mahantesh

Views

1.4K

Likes

0

Replies

0
Re: Fetch a Label instead of the Value of an enumerated field
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Classic
Hi Vipul,Thanks for your response.I am planning to export the data ... campaigns > deliveries > delivery logs & tracking logs ... for all the campaigns into an external EDW database to analyse the effectiveness of each of the campaign/delivery.If I use the Export (use Labels) through series of query/enrichment activities, I can get the labels. But since I need an email subject as well in the export, I am switching from enrichment to Javascript to create a staging table with limited columns (para...

Views

1.4K

Likes

0

Replies

0
Fetch a Label instead of the Value of an enumerated field
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Classic
Hi,Suppose, I have a schema field based on an enumerated typeEnumerated datatype Column in the schema is defined of the type enumerated When I use the querydef on such a column, it will return the value as "0" or "1" or "2". Instead, I want to fetch their labels like "SMS" or "WAP Push" or "MMS", could you please advise.Regards,Mahantesh

Views

4.7K

Like

1

Replies

6
Re: Fetch a parameter field/value
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Classic
Hi Vipul,Thanks for your response.Could you please guide me, where (at what stage) & how can I achieve this in my workflow (explained in my initial post)?Regards,Mahantesh

Views

1.4K

Likes

0

Replies

0
Fetch a parameter field/value
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Classic
Hi,I have a built the following workflow to extract Campaigns, Delivery associated each Campaign, Delivery Logs of each of the DeliveriesStage-1 : Query CampaignThis extracts all the Campaigns. Output Fields: Campaign Id, Campaign LabelStage-2 : Enrichment with DeliveryThis extracts the Delivery associated with each of the Campaigns extracted in Stage-1.Output Fields: Campaign Id, Campaign Label, Delivery Id, Delivery LabelStage-3 : Enrichment with Delivery LogsThis extracts the Delivery Logs as...

Views

4.0K

Like

1

Replies

10
Re: Unable to load document of identifier 'temp:query6' and type 'xtk:schema'
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Standard
Hi Vipul,Thanks for your response.Yes, it worked.Regards,Mahantesh

Views

1.7K

Likes

0

Replies

0
Re: Unable to load document of identifier 'temp:query6' and type 'xtk:schema'
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Standard
Hi Vipul,Thanks for your response. I did as you mentioned and the error I had mentioned has gone but it is giving a different error now.Unable to read data from the base, the table has been purged or the current workflow configuration is no longer compatible with its structure.Display errors during data loading...When I clicked on this link, it is showing the detailed error messagePostgreSQL error: ERROR: relation "wkf1031459404_8_1" does not existLINE 1: ...(' || COALESCE(O1.sInternalName, '') ...

Views

1.8K

Likes

0

Replies

0
Unable to load document of identifier 'temp:query6' and type 'xtk:schema'
Avatar
Validate 1
Level 1
MeMonty
Level 1

Likes

4 likes

Total Posts

9 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
View profile
MeMonty
- Adobe Campaign Standard
Hi,I have built a workflow with a single query based on a single table. I have run the workflow and it shows some count (of records) in the result. When I used “Display the target” (in the context menu by right clicking on the Result arrow) to see the Result, I am getting the following error.The edit from initialization has failedUnable to load document of identifier 'temp:query6' and type 'xtk:schema'Could you please advise.Regards,Mahantesh

Views

4.0K

Likes

2

Replies

6
Likes given to