Solved

Hi,I have the following queryvar clickQuery = xtk.queryDef.create(       <queryDef schema={vars.targetSchema} operation="select" >          <select >                                                          <node expr="distinct(@journalDistributionID)" alias="@clicksJD_id"/>            <node expr="date(@created)" alias="@clicksDate"/>             <node expr="count(@type)" alias="@clicksCount"  />              <node expr="count([@broadLog-id])" alias="@ID" />                                                                   </select>            <where>            <condition bool-operator="AND">           <condition expr="@type='1'" />           <condition expr="@type!='3'" />           </condition>            </where>          <orderBy/>                             <groupBy>        <node expr="@journalDistributionID" />          <node expr="date(@created)" />                   <node

Hi, I have found that table NmsBroadLogRcp is updated in batches For ex. likeUPDATE NmsBroadLogRcp SET iStatus=:1, iMsgId=:2, tsEvent=:3, tsLastModified=cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId=:4 AND iStatus=:5 AND ROWNUM<=5000 I'm looking for solution how to manage batch size to avoid too many loops.Those value is any defined parameter ? Thanks in advance

Hi All,As part of beautification of URL we have removed .html from publish in page i.e. URL would be www.test.com/publish. We are using AEM inbuilt 302 redirection where it is explicitly adding .html to redirected URL.please help if there is anyway to remove .html addition from default AEM redirect template.Thanks in advance!!

Hi Everyone,I have created XDP contains a repeatable section inside the repeatable section. It works well in the LiveCycle Designer.I have created an adaptive form by using XDP and XSD schema. when submitting the form all inner repeatable section shown in the first repeatable section.Example:I need a pdf file like below:Parent 1  Child 1  Child 2Parent 2  Child 3  Child 4but when submitting it shown likeParent 1  Child 1  Child 2  Child 3  Child 4Parent 2xsd schema:<?xml version="1.0" encoding="UTF-8"?><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="Repeatable-Schema"><xs:complexType><xs:sequence><xs:element name="Repeatable"><xs:complexType><xs:sequence><xs:element name="Repeatable-page1"><xs:complexType><xs:sequence><xs:element name="parent" type="parent" minOccurs="1" maxOccurs="100"><xs:complexType><xs:sequence><xs:element name="ob-

In Adobe Launch, Is it possible to revert the AppMeasurement version within the Adobe Analytics extension to previous versions? we are looking for functionality similar to what you can do in DTM?We have identified in DTM and in Launch that the current version of AppMeasurement 2.17, breaks certain functionality with our property/library. We are able to revert the changes in DTM however are unsure on how to do this in Launch.appreciate your help.

Hi All,I have a requirement to show the content, based on user's type/category. So, I'm planning to go with cookie approach and achieve this. But, can someone help me on the approach which I'm gong to follow and correct me if something will not works here!1) My application has login option. so, when user logged in I will set a cookie whether the user category is A, B or C. (CookieName=UserCategory & CookieValue=categoryA/B/C).2) Once the cookie has been set and I will trigger the mbox/At.js and In Target I will check the cookie (UserCategory) whether if it is A, B or C? Based on that I'm planning to show the content. Now, I had a doubts on how to set the cookie first (before calling mbox/at.js) and how to pass the cookie value to Target. And, where should I write the JS/JAVA code to fetch the cookies?Whether this cookie approach will works or not?Or, is there any other approach I can use it from OOTB?I using AEM 6.4 and integrate Target within that.Can you please suggest/help  me h

I want to use custom script for changing the view of my website. Since I would like to manipulate different parts of the webpage I don't want to use applyOffers. I wonder if there is any side effects to use custom javascript instead of using applyOffers? For example, other functions like trackEvent can still be useful?Is applyOffer function just used for manipulating the webpage?Thank you!I am using at.js v2.2.0

We have multiple mobile properties which were created at different times. Between the first property we create and the others something changed within Launch and now we struggle to get the configuration JSON.On the environment screen you can copy the id or code snippets. The environment file id was something like this:launch-HASH-ENV and you could easily get the JSON with: http://assets.adobedtm.com/launch-HASH-ENV.jsonThe environment file id of newer mobile properties look like this:COMPANYID/PROPERTYID/launch-ENVIRONMENTID-ENV but using this pattern with assets.adobedtm.com does no longer work and we get:"File not found." It seems even the API call itself does not work anymore:MobileCore.configureWithAppID(ENVIRONMENT_FILE_ID) Is this a bug or how are we able to load the configurations now?

Hi All,I have a composite component which has a parsys in which i can add or remove an already added component. now i have a use case as i add a component in that parsys, page should get referesh as i add a component in tab it create a respective tab in header. i just don't want to add listner to child element , just want to add event listner to composite component so if i drop any component in it that listner will kick off and page should get refresh?

Adaptive form request URL:localhost:4502/content/myform.html?foo=barPrefill service:@Componentpublic class FormPrefillService implements DataXMLProvider { ... }From FormPrefillService how can I access the request parameter "foo" from the request URL? Thanks

I have create workflow launcher which need to be trigger when new content fragment is created under /content/dam/myfragments folders.   But considering with in content fragment any nodes getting created under the parents node there are multiple workflow instance triggered for the same content. . I believe it should trigger only when Content Fragment completely created but not to each of its child node.     In workflow console I can see the launcher triggered for each of this path but it should trigger only for this content fragment "/content/dam/myfragments/mahamood-bio2"   /content/dam/myfragments/mahamood-bio2/jcr:content /content/dam/myfragments/mahamood-bio2/jcr:content/metadata /content/myfragments/mahamood-bio2/jcr:content/data /content/myfragments/mahamood-bio2/jcr:content/data/master /content/myfragments/mahamood-bio2/jcr:content/related   Please advice how to create launcher for Content Fragment.

Hi everyone,I'm currently working with a transactional eDM using SOAP UI for testing. This particular eDM has three pieces of content which are supposed to render under certain circumstances.The fields which are driving this, however, only have one value and if this value is not passed via the API, then the fields aren't passed at all.What I've been attempting to do is write conditional statements to drive the content of the email by checking if the field is present. eg.<% if (rtEvent.ctx.FIELDNAME1 == undefined || rtEvent.ctx.FIELDNAME2 == undefined || rtEvent.ctx.FIELDNAME3 == undefined) { %>CONTENT  I was testing this by removing the particular fields from the SOAP event to see if this simulated the field not being passed, however I'm unsure if this is the correct thing to do or not.Using 'undefined' doesn't appear to work. I have tried 'null' as well.Does anyone know whether what I'm attempting is possible? Is this the correct way / syntax to check for the absence of a field?

What is the best way to extract path diagram data?  I am currently expanding items 1 by 1 (there are more than 1 mil items to expand), and exporting these to CSV. Are there any faster way, especially once I've drawn the relevant metrics/ dimensions? EDITED:To elaborate, eg., a path flow has 1,000++ items on one of the Page columns - at the bottom of the Page column, I would need to click on "1,000+ more" continuously to view full list, then export it as CSV, and change filename to .xlsx to run it in Excel. Upon which, data warehousing is not uniformed in any given spreadsheet (Excel, Power BI). But that's a story for another time. Is there a way to export all data, even without clicking the "1,000+ more" expansion in the above scenario? - thank you -     

Hello,Is there a way to capture the very first visit of a certain web page?I could just create a trigger campaign and set the flow to only once, but that would just capture any visit after activation? How can I also ensure that any visit prior to activation is also accounted for?Ideally would like the logic to be:1. Trigger: Visits web page X2. Had Not visited web page X before that momentThank you,Ville

Hi,In Time spent per visit (seconds) metric, sometimes I get invalid  value on result:Source image file 20944 not availableI created a Calculated Metric to avoid this and get zero value in these cases, but I can't find the solution using Adobe functions.Anyone know any formula type is_invalid?Thanks!

I am trying to disable contexthub.commerce.cart.json. so that it will not load on page.I went to http://localhost:4502/etc/cloudsettings/default/contexthub/commerce/cart.edit.html and disabled the contexthub configuration. Yet, configuration is loading on the page.Is there other configuration that I should update. Please advise.

New Marketo user here, and I'm trying to understand how Marketo works.When a user enters a Marketo program, does Marketo take a snapshot of that user's data at the point of entry and use that to power the program?Or does Marketo use the user's most recent data to power the program?Ex: I have an onboarding program targeted to free users, but I'd like to remove them from the program if they become paid users. Would having a Remove from Flow step of "Paid = True" work to remove a user from the flow? Or would that not work since all users who enter the program are "Paid = False", and Marketo only has access to that data for the program?

Hi Guys, I have to delete approx 7k records in the quarantine list for the address which has mailbox full as the error reason. Please help me with the best way of deleting those addresses in a single shot. I am using a workflow to filter the data based on the market code(Coz its a different table) to delete it with the help of update data activity.Is this a right approach or is there an other way.Regards,Raaghu

I'm having an issue where instead of Marketo showing the default value when previewing an email, it shows ${drivername}. In the campaign I'm building, not all values set in velocity will exist in the JSON field. Some records may have a few while another has all.How do I code my velocity so that if a value I'm setting is missing from the JSON field, it is overlooked and the echo script I set in a token doesn't output ${drivername}, but outputs the default value "there", such as {{my.drivername:DEFAULT=there}}?##set defaults#set( $utm_source = "mkto-email" )#set( $utm_medium = "customer-engagement" )#set( $utm_campaign = "TXreferralsprogram" )#set( $messageHTML = "" )##check JSON and set vars#if( $lead.carpoolJSON.isEmpty() )#set( $lead.carpoolJSON = '[]' )#elseif( $lead.carpoolJSON )#set( $refData = '#set( $refData = ' + ${lead.carpoolJSON} + ' )' )#evaluate($refData)#end#foreach( $ref in $refData )#set( $referralURL = $ref[0].driverReferralUrl )#set( $driveruniqueUrl = $ref[0].driverUn

Hi everyone,I recently integrated Showpad with Marketo.Everything is running smoothly, but I'm wondering about the specific meaning of the new created filters.I have 3 new Showpad related filters on Marketo which are:- Has Showpad content- Was added to Showpad content- Received Showpad shareThe last one, I understand. After verifications, it appears to be a lead that received content but did not download / view it yet.Although, for the two other filters, I have the feeling that there is not much differences between them... I understand that they viewed the received content. I also have the same amount of leads (and the same leads of course) in both of them. Does anyone has an idea of which is what?Thank you,

Hello,I am trying to create a smart list referencing the 'Id' field and I cannot figure out how to filter by this field. I cannot find it and none of the choices that pop up for me with Id in the title are even close. Has anyone else run into this problem?Thanks,Virginia

I am using hidden fields in my forms for populating UTM Source, Medium, Campaign and SFDC Campaign ID down from the URL parameters. Weirdly, it's working for UTM Source, Campaign and our SFDC Campaign ID and pulling those down into our respective fields, but not UTM Medium. I also tried creating a custom 'Referrer' field which we want to use to include Sales people's names, but this hasn't pulled through either upon a form submit. It doesn't even pull the default value through... What could be going wrong? 

マルケト内にCSVでインポートする際に　年／月／日となっているものが、マルケト内のフィールドにインポートされた際に　年／日／月の順番に変わっている。ただし変わらない日付も。変化してしまう例　CSV内　2019／12／1　　マルケトフィールド内　2019／1／12変化しない例　CSV内　2019／7／21　　マルケトフィールド内　2019／7／21何かの設定が間違えている可能性がありますでしょうか？ご存知の方、同じような事例で解消済みの方いらっしゃいましたら教えて頂ければ幸いです。

Hi,I have created an AB test using the experience template (pop up upon exit intent).  The "last chance offer" popup fires properly within the edit activity phase while setting up the test.My site has geo-location functionality so upon entering, there is a popup in the top left that asks "______ wants to know your location.  Allow or Block"It seems that when this location popup shows, the AB test (exit intent) does not always fire. In addition, if I already have hit allow or block, then return to my site at a later time....the test actually works.  Ideally we need this to work ALWAYS, not when someone returns.  Is this a known issue?  Could there be another problem?  Has anyone had this occur and maybe have a workaround?Thanks in advance!

Hello all,I'm configuring my Offer module (space, category) but when deploying the offer space I'm getting the following error:XFR-180000 The file '/usr/local/neolane/nl6/datakit/eng/schema/.xml' does not exist on the server. Unable to load the document of identifier '' and type 'xtk:schema'.SOP-330011 Error while executing the method 'CompileRealTimeScript' of service 'nms:interaction'.(1:1) : Invalid document structureXML-110018 Error while parsing XML string ''SOP-330011 Error while executing the method 'ProposeOffers' of service 'nms:offerSpace'.[nms:webApp Error] SOP-330011 Error while executing the method 'CompileRealTimeScript' of service 'nms:interaction'.(1:1) : Invalid document structureXML-110018 Error while parsing XML string ''SOP-330011 Error while executing the method 'ProposeOffers' of service 'nms:offerSpace'.Could you tell me in detail how can I fix this error?Thanks,SalvatoreVapsy​Amit_KumarDebabrata.T​florentlb​Adhiyan C​Jean-Serge Biron​