Solved

Hi, Does anyone able to retrieve cq:lastReplicated in JSON output as String? I am using Query builder to retrieve query result. ValueMap properties = hit.getProperties() if (properties.get("cq:lastReplicated") != null) { LOGGER.info("Published Date" + properties.get("cq:lastReplicated").toString()); contentObject.addProperty("publishDate", properties.get("cq:lastReplicated").toString());}Output coming as :Output coming inJSON as : "publishDate": "java.util.GregorianCalendar[time=1707236418257,areFieldsSet=true,areAllFieldsSet=true,lenient=false,zone=sun.util.calendar.ZoneInfo[id=\"GMT-05:00\",offset=-18000000,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2024,MONTH=1,WEEK_OF_YEAR=6,WEEK_OF_MONTH=2,DAY_OF_MONTH=6,DAY_OF_YEAR=37,DAY_OF_WEEK=3,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=11,HOUR_OF_DAY=11,MINUTE=20,SECOND=18,MILLISECOND=257,ZONE_OFFSET=-18000000,DST_OFFSET=0]",Please let me know if I

I am trying to create a calculated field in a custom form that will show me the average turn around time form Project Initiation To Approved Go Live date on all completed projects.  I cannot figure out how to get two expressions in the calculated field.  I know one would be DATEDIFF({DE:Approved Implementation Date},{DE:Project Initiation Date})but I don't know how to add the expression to get the average.  Any suggestions?

We are importing bulk Issues into Workfront for an upcoming onboarding of Projects. Usually, each one generates 3 different associated notifications. We don't want users to be burdened with mass notifications.I know there is a Project status that can be used "Planning" so modifications can be made to the Project that won't send out notifications. Is there a similar status that can be used for Issues?

Hi Team, i need help on this below question 1) When I check the dashboard report in Adobe Campaign Classic, it appears empty—even though the delivery is correctly linked. We’re using a custom target mapping, so I’m trying to determine whether this issue is related to access permissions or a problem with the campaign configuration. Can someone help me identify the root cause? attached screenshot . 2) I send daily emails to around 10,000 customers. I want to implement a rule to exclude any profile that has already received more than 3 emails within the same week from receiving additional emails.   Note : without control from typology because i dont have admin access  

Hello community, I need to obtain a list of workflows that have been successfully executed in a month. Do you know if there is a way to do this? I am using the workflowlog table, extracting the records that contain the text ‘workflow is being run’ to obtain those that have been executed, but I cannot find a way to exclude those that ended in error since I cannot find an execution ID, and if a workflow has been executed several times during the day, I cannot differentiate which execution the error belongs to in the workflowlog table.. Thanks

can we keep common farm file code in a seperate file and reference it in siteA_farm.any and siteB_farm.any ? Below document says we can have a 'includes' folder in conf.d folder .Do we have similar for conf.dispatcher.d ?https://experienceleague.adobe.com/en/docs/experience-manager-cloud-service/content/implementing/content-delivery/validation-debug#flexible-mode-file-structure 

I use the Workfront extension for InDesign and every time I generate a proof it gives people weird roles. For instance, some people are given "Reviewer & Approver" while others are given "Reviewer." I'm sure it has something to do with their role in the system, but I'd like for everyone I add to be a "Reviewer & Approver" and for me to be a "Reviewer" (I don't need to submit a decision on proofs I create). Is there some way to change that? At the moment, I have to open the proof in workfront and manually change the roles in the proof workflow every time I create a proof from the extension and it gets annoying. I've tried making templates, but each proof I create has different approvers so I can't always forsee what groups of people to include in a template and I don't necessarily want a million templates. To my knowledge, setting proof recipient roles within the extension is not currently possible, but it would be a great feature. If no workaround for this exists, can

Issue starts after AEM 6.5.23 service pack installation.The file upload field stopped popping up on the "Upload Zip" option of design importer.The error is due to sanitization of html which contained a non standard html attribute "coral-fileupload-select". Is this something adobe should fix as issue is with coral fields which are used in AEM but are non standard?  

Hi,I have a timesheet report that is shared with management.   We noticed that depending who runs the report, they don't see the same people.   For example, when I run the report for 'this quarter', I see timesheets for 14 people.   When one manager runs it, they get the same thing but then a different manager only sees 12 people.  I have checked to make sure they don't have any different filter or view on.   I didn't think there was permissions/sharing for timesheet profiles but maybe there are somewhere?  Also, the 2 people that don't show are the system administrators.  Any ideas why the difference in the report or any permission that I am missing somewhere? Thanks Heather 

Hi all, I'm sure I'm missing something super simple but I'm trying to use a calculated field, formatted as a number, to pull in the difference between our planned start date and actual completion date on our task reporting form for tasks named review. The formula I'm using is:  IF(CONTAINS({name},"review"),WEEKDAYDIFF({plannedStartDate},{actualCompletionDate}),"") but it isn't working as expected. Does anyone have any suggestions on how to further troubleshoot? 

Do we have Send Time Optimization (STO) in AJO under Campaigns ? if yes, is there a criteria only after which its enabled in the UI ?

What happens when you use duration in a wait step without specifying the time?For example: Wait 4 hours, wait must end Mon-Friday. Send email.If someone enters the wait step on Saturday at 9 a.m., when will they receive the email? Right at 12:00 am Monday? Or would it be Monday 4 hours after they entered the wait, at 1 p.m. Monday?

I'm creating a Workfront to Jira scenario using the Jira Cloud Create a record Module.  It keeps erroring on the "reporter" field of t he module.  I have tried mapping it to both the Sponsor name and the email address of the sponsor but when I run the scenario I get an error:[400] Specify a valid value for reporterDoes anyone know what could be wrong?  In Jira the reporter is a character name. Thanks in advance  Frank

Hi everyone, I’m facing a challenge I haven’t been able to solve yet. I have an Experience Event dataset that contains multiple rows per ID, and I need to transform it into a Profile dataset by aggregating all rows for a given ID into a single row, using arrays to store the values. Here’s an example of the schema:Experience Event Dataset_entity.fg.ID _entity.fg.name _entity.fg.score _entity.fg.normalizedScore _entity.fg.version Timestamp Target Profile Dataset_entity.ID _entity.fg[].name _entity.fg[].score _entity.fg[].normalizedScore _entity.fg[].version extSourceSystemAudit.lastUpdatedDate I’m trying to write a SQL query that would group all rows by ID and transform the values into arrays, but I haven’t found a working solution yet. Has anyone faced a similar use case or could share an example of how to achieve this transformation using SQL in AEP? Thanks in advance,Regards,Samy

We have an web event dataset which is profile enabled and ECID is an identity field. Now for record class datasets (Person, Account), we do not have ECID present . Now question is in Customer Profile store, will records for those ECID coming from Web Event Data will appear or not? 

Hi something very odd going on. If i send a journey email communication i can see the outbound email as sent within the events on the profile lookup. If I send a campaign, the emails send but do not appear on the profile event tab. if i then run sql against the AJO tables, specifically the ajo feedback table and look into the identitymap ( i do the search by using the customer email address), for the journeys there are namespace entries in the map, but not for campaigns. and both are using the same namespace IDs for the sends has anyone come across this before? 

help me how to define an mirror page url function with ajo api triggered marketing email templates, using below reference<% if ( document.mode != 'mirror' && document.mode != 'forward' ) { %><p align=center><font style="font-family: Verdana, Arial; font-size: 10px">If you are unable to view this message correctly, <a href="<%@ include view='MirrorPageUrl' %>" _label="Mirror Page" _type="mirrorPage">click here</a></font></p><% } %>

Hi Everyone, I am working on push configuration in AJO.I have enabled AJO profile dataset (profile enabled), AJO event dataset (profile enabled), Analytics dataset (not profile enabled) and other checkbox also enabled in datastream.But I am seeing in assurance session that AJO is not enabled. App data is flowing in Analytics but its not getting recorded in AEP dataset. Can any suggest, what's causing issue.  

Hi Adobe Team & Community, I'd like to know if there's a successful use case on all the data points and potential variables to consider in building buying groups in AJO B2B. How this may have been mapped out in a brief would be ideal. Specially, what are the data points to consider across all scenarios when combining the individual components for Buying Groups:                                                                                                                                  Solution Interest: The specific product, service, or group of products/services that the buying group is considering purchasing.Account Audience: A targe

I'm working on AJO API Triggered Campaigns, well I'm trying to write a logic populate the personalization values from API JSON Payload on a HTML Template using below logic and json paylaod!Question: help me how to define and populate the value for "name"  form below json payload at each iterated individual array level for an example if countProducts = 1 then i want to print the value of attribute (name) at array level[1] with in the html template in this case the level[1] name value = "Super Socks"AJO logic:{% let countProducts = count(context.products) %}{{#each context.products}}{%#if countProducts = "0"or countProducts = "null"%} <p>You have no products to display.</p>{%else%}  <li>Product: {{this.name}}</li>  {%/if%}{{/each}}{%#if (toString(countProducts) = "3" )%} <li>Product: {{context.products.name}}</li>{%else%}  <p>You have no products to display.</p>{%/if%}Results:JSON:{  "c

Hi Team, I would like to hide the Profiles folder under Customer Management for a specific user on Adobe Campaign Classic V8 Web User Interface? PFA screenshot for reference.Could someone guide me with the steps to achieve this? Thank you in advance. Kind Regards,Anushka K

We have a dynamic email that we send to our prospects that is built based on the country and will keep the corresponding links for each country and region. I am seeing a person click a link in this email that wouldn't be served to them based on the region/dynamic rules. Could this be something of a bot clicking links that aren't truly visible to the person? I have checked the email a bunch, and I am not seeing any link reference to this link on the email that they were dynamically sent.

We’ve observed that the Bulk Export API returns an HTTP status of `200 OK` even when the response body contains an error. For example, we received the following response:when using a bulk api i.ebulk/v1/leads/export/{ExportID}/file.json { "requestId": "4aac#17c", "success": false, "errors": [ { "code": "603", "message": "Access denied" } ] } Despite the `"success": false` flag and error code `603`, the HTTP status was still `200 OK`. This behavior is misleading and complicates error handling, as it suggests the request was successful when it clearly wasn’t. We’d like to understand:- Is this the expected behavior for the API?- Are there plans to align HTTP status codes with the actual success/failure of the request?- What is the recommended best practice for detecting and handling such errors?Thanks

Hi AJO experts!We have the following problem: we are using events to trigger customers into an audience. Then, we are creating journeys to send email containing links to a landing page where the user can submmit comments. We plan to capture those comments, and each email must correspond to one unique comment submissionThe issue is that we need to use this data to configure a parameter in the URL of our landing page so that, when the user submits a comment, we can send this information back to our environment as a token.Is it possible? I see two potential solutions1) Use a journey to update the profile with this information and the use audiences as triggers in the journeys.2) Use events as triggers so I can use the data to personalize and create the journey with a wait activity until its time to send the journey. Is Adobe planning to allow personalization using information from events?

I'd like to have a user's phone number format as (xxx) xxx-xxxx in a report.I tried the suggested text mode below, but it returns only 7 out of 10 numbers. it's missing the middle three numbers.valueformat=HTMLtextmode=truevaluefield=phoneNumbervalueexpression=IF(ISBLANK({phoneNumber}),"",CONCAT("(",LEFT({phoneNumber},3),") ",MID({phoneNumber},4,3),"-",RIGHT({phoneNumber},4))) Any ideas what I'm doing wrong?