since ‎10-03-2017
‎10-12-2019
MeMonty
Level 1
Passing date to querydef
Avatar

MeMonty

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

Views

1.4K

Likes

0

Replies

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

MeMonty

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

Views

1.2K

Likes

0

Replies

0
Re: Fetch a Label instead of the Value of an enumerated field
Avatar

MeMonty

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

Views

1.2K

Likes

0

Replies

0
Fetch a Label instead of the Value of an enumerated field
Avatar

MeMonty

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

Views

4.5K

Like

1

Replies

6
Re: Fetch a parameter field/value
Avatar

MeMonty

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

Views

1.1K

Likes

0

Replies

0
Fetch a parameter field/value
Avatar

MeMonty

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

Views

3.7K

Like

1

Replies

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

MeMonty

MeMonty
- Adobe Campaign Standard
Hi Vipul,Thanks for your response.Yes, it worked.Regards,Mahantesh

Views

1.2K

Likes

0

Replies

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

MeMonty

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.3K

Likes

0

Replies

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

MeMonty

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

3.4K

Likes

2

Replies

6
Likes given to