since ‎10-03-2017
‎10-12-2019
MeMonty
Level 1
Passing date to querydef MeMonty - Adobe Campaign Standard
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...
1329
Views
0
Likes
1
Answers and Comments
Re: Fetch a Label instead of the Value of an enumerated field MeMonty - Adobe Campaign Standard
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
1090
Views
0
Likes
0
Answers
Re: Fetch a Label instead of the Value of an enumerated field MeMonty - Adobe Campaign Standard
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...
1095
Views
0
Likes
0
Answers
Fetch a Label instead of the Value of an enumerated field MeMonty - Adobe Campaign Standard
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
4417
Views
1
Like
6
Answers and Comments
Re: Fetch a parameter field/value MeMonty - Adobe Campaign Standard
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
1063
Views
0
Likes
0
Answers
Fetch a parameter field/value MeMonty - Adobe Campaign Standard
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...
3585
Views
1
Like
9
Answers and Comments
Re: Unable to load document of identifier 'temp:query6' and type 'xtk:schema' MeMonty - Adobe Campaign Standard
Hi Vipul,Thanks for your response.Yes, it worked.Regards,Mahantesh
1076
Views
0
Likes
0
Answers
Re: Unable to load document of identifier 'temp:query6' and type 'xtk:schema' 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, '') ...
1193
Views
0
Likes
0
Answers
Unable to load document of identifier 'temp:query6' and type 'xtk:schema' 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
3304
Views
2
Likes
6
Answers and Comments
Likes given to