Solved

I have an array based date column called Billinvoicedate which is of date type.I want to calculate and fetch all the yesterday records for that particular date column.But i am constantly getting error while trying different sort of sql queries. e.g. select * from pe_cust_ren_sub where DATE(_pe.rensub.BillinvoiceDate ) =DATE(CURRENT_DATE -1 ) I am getting error as  follows:1:43:06 PM > ErrorCode: 08P01 queryId: cf72f42b-687e-4b26-a821-af1d7b20f241 Unknown error encountered. Reason: [cannot resolve 'CAST(pe_cust_ren_sub ._pe.`rensub`.`BillInvoiceDate` AS DATE)' due to data type mismatch: cannot cast array<date> to date; line 4 pos 7; 

Hello,Is there a way to add more columns to the My Tasks widget on the Home page? Currently, only 11 options are displayed. Refer to attached image. Thanks, 

I realized that all the links to our privacy statement don't work in our nurture program streams. This is about 100 emails. Is there a way to go and fix the one broken link or do I have to go into every email and change them manually? 

Hi All , I want to fetch list of all workflows which are in paused state and finally stop their execution and change their state to finished .How i can do this . Thanks in advance. 

I am looking to report on the Planned Duration of a Project vs the Actual Duration. I know I can look at the planned duration of the template, but I'm looking specifically to report on the planned duration of the project (since the templates are just a starting point/ some projects do not use templates).  Is there a way to do this?

Hi,I am using one of the email templates in the design studio and re-fashioning, re-branding.How can I get it so that an admin who creates an email within Marketing Activities & injects the content into the email template can have the ability to turn off/on or hide/show the content sections? The content variables on the right side of the screen for:PreheaderHeaderHeroPhotoLSo on & so forth...FooterTo have that top-level content management system when plugging in the content for the email instead of having everything in there and they manually have to carefully delete all sections they do not need.Please advise how I can do that without affecting or damaging the base template in the design studio as the admin changes out content from campaign to campaign when utilizing that base template.Thank you. 

Is it possible to create such a data structure in order to iterate over this in AJO? Everytime I create something I am not allowed to save it. 

I need to create an audience based on the previous page condition using Site Pages. Previous page is one of the affiliate sites where they do not have Adobe Target implemented.For example, if my previous page is facebook.com, and I need to target visitors who are clicking on facebook.com and landing to my site (my site has Adobe Target implemented). Once they land to my site (from facebook), I want to show the test content.My questions is –  do I need Adobe Target to be implemented on facebook.com for the previous page targeting condition to work in audiences?

We are working on a hybrid ntegration with Adobe Target Delivery API and we ran into problems with our company firewalls.Currently, in our environments all requests to external services are blocked by default and we need to request opening communication towards specific IPs. We have tried to look up what IPs we should specify in our firewall rules but the documentation doesn’t specify the Adobe servers the SDK seems to be using.Documentation: How Do I Allowlist Target Edge Nodes? | Adobe TargetFurther docs: IP Addresses Used by Experience Cloud | Adobe Experience Cloud Services(nothing about mboxedge37 on either of these pages) Our at.js config:    clientCode: "OURCOMPANY",     serverDomain: "OURCOMPANY.tt.omtrdc.net", The above seems to translate to:https://mboxedge37.tt.omtrdc.netwhich is not listed in the documentation. We are not sure how this address is being built and where does it come from (we assume it’s from the CNAME of ourco

I am following this tutorial, to create a dispatcher for the first time. 1 - I downloaded the dispatcher module `dispatcher-apache2.4-darwin-arm64-4.3.5.tar.gz` from adobe.2 - Extracted `dispatcher-apache2.4-4.3.5.so`, renamed it mod_dispatcher.so, and put it in /private/libexec/apache2.3 - Added it to the httpd.conf file (see below).When I run `sudo apachectl start` at timestamp 13:38, my added "mod_dispatcher.so" doesn't load, and there is no "can't be opened" pop-up as per tutorial. I know this because if I check the status with `apachectl configtest`, I get: ```[Wed Jul 20 12:05:08.912784 2022] [so:error] [pid 43824] AH06665: No code signing authority for module at /private/libexec/apache2/mod_dispatcher.so specified in LoadModule directive.httpd: Syntax error on line 190 of /private/etc/apache2/httpd.conf: Code signing absent - not loading module at: /private/libexec/apache2/mod_dispatcher.so```Looking at the video comments, a few are experiencing the same issue. Do

Hello friends, I've used Adobe Analytics (product admin, Workspace, tag manager, etc) since Omniture, I chose to focus 2025 to revamp my Adobe related career by getting into CJA (thinking also AEP/SDK and Target) I'm trying to decide which CJA certification will help me get a job sooner.I happen to enjoy both tech and business sides of analytics and being that I have experience in the field, I wonder if I should go for Adobe Customer Journey Analytics Developer Expert, although harder wondering if it can increase my chances as I could potentially do good if interviewed for Adobe Customer Journey Business Practitioner Professional roles,  or if doing biz practitioner is the fastest way to get my foot in the door. Does each certification leads to different paths, one business the other technical? I'd also like to learn about market demand, salaries and growth opportunities based on Q1 2025 predictions. Thanks! Rafael

I trying to run a report that shows 2024 projects with Proofs that have 4 or more versions. I am not able to do it with regular reporting, any idea on how to do this with TextMode?

Hello,i have a workflow where i create a json array using javascript activity and i want to  create a new adobe campaign list (using js code) and add to it all the data in my json array  using "javascipt acitivity" or "update list" activity.can you please show me how i can achieve this operation in my workflow.  this is the code of my Js activity : var arrayOfObjects = [{ "id": 28, "Title": "Sweden" }, { "id": 56, "Title": "USA" }, { "id": 89, "Title": "England" }];vars.arrayOfObjects = JSON.stringify(arrayOfObjects);  Regards !

I am trying to compare data on average time spent for all projects tied to a template. Does anyone know how to run a report based on template and all projects with time, by task, associated with that template?

Hi Team,Do we have the concept of temporary purchaseID with WebSDK as well like we have in AppMeasurement. Through this feature Adobe uses information from the hit to create a “temporary purchaseID ” if the hit doesn't contain the  purchaseID variable. This temporary purchaseID only applies to the visitor of the hit. The previous 5 temporary purchase ID’s are stored for each visitor ID per report suite. In case temporary purchaseID match any of the last five stored temporary purchaseIDs , the image request is considered a duplicate purchase.Does AEP WebSDK provide this capability or do we need to explicitly provide the purchaseID on every purchase event for serialization purpose?

Hello all, I'm hoping someone can assist me with a calculated field question. My goal is to be able to create a pie chart which shows a breakdown by percent of the segments we support. he data is being gathered via  multi-selection drop down lists. In order to create the chart I need to add groupings to my report but you can not group data from multi-selected fields. My solution is to create a calculated field populated by the selection in the multi-selected field.  For instance if the field Name is "Cat" and the options in the fields are "black", "white" "tabby", etc.  If any of those options or all of those options are selected, then my calculated field pulls in "Cat".  My grouping in the report could be "Cat".    Can anyone assist with the calculated field formula?  Thank you very much.   

I'm adding some fields to the abc:recipients (recipient's extension) schema. It currently has 01 PK in the base recipient schema. I need to add an attribute from the extension also as PK.  So both are not a combined PK, rather individual PKs.Is this ok? This is how I have set the codinterno field as PK:<key internal="true" name="codinterno_pk"><keyfield xpath="@codinterno"/></key>  

I have one user who constantly adds his updates to his initial request instead of the project. I explained to him that we need him to post his updates in the project updates, and gave him a tutorial on how to do that. Today he sent screen shots showing me he can't access the project updates, and so far I haven't been able to figure out why. He's got Contributor access, and I always grant project access to requesters when I convert them. Is this something affected by the new licenses? Am I overlooking something?

Hi all, I found this article in Community - https://nation.marketo.com/t5/knowledgebase/statistics-section-on-a-marketo-landing-page-asset/ta-p/299879, and was trying to understand how Page Views can be pulled in a Smart List report to see who viewed a Marketo landing page from our database. I tried to pull a Smart List report using a filter "Visited Web Page" with Web Page : contains : landing1.gehealthcare.com/USC-HCD-HCD-RSNA-2024-Health-Imaging-eBlast-COV-GA-24-11-Landing-Page, but I ended up getting no people in my smart list. The page on the Landing Page Statistics section has 3,506 views. Surely, I must be doing something wrong when pulling the report. Kindly help,Dillon

Unable to add existing user to current proof. I'm using the Share > Add Recipients option, the name/email comes up but nothing happens when I click on it. I've rebooted and tried in both chrome + safari.  When I searched the community board, the "workaround" provided was "Use another method to share the proof."  Anyone else experience this issue / have a solve?     

Hey community! I was wondering if anyone has any frameworks for translating license optimizations to cost savings? For example, we implemented pseudonymous profile data expiration to our CDP instance with a contracted limit of 20m and reduced our license usage from nearly 90% to 55%. Is there a way to translate the % reduced to $ saved?

Since Recipients table already has a PK, I cannot make my field a PK so it is unique.So I cannot use:autopk (boolean): if this option is activated (autopk=“true”), a unique key will be automatically defined. This option may only be used on the main element of the schema. Warning, Adobe Campaign only guarantees that the key generated is unique. It is not guaranteed that the key values are consecutive and incremental.

I have a file coming in for a daily load which has a date time field formatted YYYY.MM.DD HH:MM:SS.  Is there a way in AJO to format the field as it comes in so it can be read in.  Currently it reads as null and looking at the documentation it needs to be in one of the accepted formats, which this isn't.  I've tried several of the functions and it continues to be read as null. Thanks

Hi, I'd like to start sending new values to an already created list2 variable that isn't in use. The configuration in Analytics is currently as follows: . We've got an existing custom event configured in Data Collection that tracks and action and send information to Analytics about the user selection within a dropdown on page. This information about the customer choice is sent to Analytics via a standard eVar. All ok with the event and the population of the existing eVar. Now we've got the requirement to send, along with the existing eVar, the same values but in this case to the lis2 variable. I've tried to start sending the required values to the list2 variable using the custom code feature within the very same event as follows:  I'm using the same custom dimension that I've used for the standar eVar (already working fine) but I can't see the list2 variable when I check the Analytics' server call in the console.  I've tried with this other

Hi there, is there a feature where I am able to create calculated fields within journey like conditional node or action node. Mainly, I would like to create touchpoints to identify the offers and load it to our contact history to track for downstream reporting tool.