Product Communities

I need help with a calculation, and I'm sure I'm missing something obvious.I have a calculated field to determine the difference between a custom date field and the project planned completion date: WEEKDAYDIFF({plannedCompletionDate}, (ADDWEEKDAYS({DE:First Offer Date},-15))).I included the field in a report and added conditional formatting for it (>=0 [Green]; >=-5 [Yellow]; <-5 [Red]).  This works fine.Then I wanted to try to account for holiday exceptions in our schedule.  I added a calculated column in the report (I wanted to try it out here before changing my calculated field): valueexpression=ROUND(WORKMINUTESDIFF({plannedCompletionDate}, (ADDWEEKDAYS({DE:First Offer Date},-15)))/480). The underlying calculation works; however, rounding the calculation results in positive values.  How can I round the result and still maintain any negative values?  Thanks.

We are migrating our AEM instance from AEM 6.5 to AEM as a Cloud Service (AEMaaCS). In our current implementation, we use a JCR Event Listener that listens to all component changes. Whenever inheritance is canceled for a component, the listener adds the property:cq:isCancelledForChildren = trueto the parent node.Problem:During the migration assessment using BPA (Best Practices Analyzer), we found that JCR Event Listeners are flagged as an issue because they are not recommended in AEMaaCS due to performance concerns.Question:What is the best alternative approach in AEMaaCS to achieve the same functionality? Some potential options I’m considering:ResourceChangeListener – Can it effectively replace the JCR Event Listener for this use case ,but it is also getting flagged in bpa report?Workflow Launcher – Would this be a viable alternative to automatically add cq:isCancelledForChildren = true when inheritance is canceled?sling jobs – Could a scheduled job periodically check and up

Hi.  Is there a way to identify if a hit in the hit_data.tsv file is a late-arriving hit?  We currently do not receive late-arriving hits and we are assessing how our data loads will need to change if we enable this.  Thanks in advance.

Hi, I need to count of records , for example, I have 3 transaction in my database activity after split I am getting total number of records show up on arrow (as normally we see) so now I need to get these counts and either put that number in temp schema or any excel file (for reporting purpose) please let me know, thanks for your support.  GUPTAA

Hi Team,I have to add a new field in the help section and open that filed in new window  which is likeFor that, I can simply overlay the /libs/granite/ui/content/shell/help/items/home to /apps/granite/ui/content/shell/help/items/home and provide the custom fieldsBut the problem is all the icons under help open in same window, but I want the custom button to open in a new window,How can I do that? Thanks @kautuk_sahni  @arunpatidar  @lukasz-m  @veenavikraman 

W e are experiencing significant issues with data tracking in Adobe due to our cookie implementation. As a result, a large portion of our data dropped, making it unrepresentative of actual performance. This has raised growing concerns among stakeholders regarding the accuracy and reliability of Adobe data.As we need to ensure compliance, we are unable to make any changes to our cookie settings on our end. Given this constraint, could you advise if there is a solution to fix this? 

Hi,I'm trying to pull the project owner name into a custom field on a form.  Owner name is not an option in the fields, but ownerID is.  I was able to use syntax for the name and it shows it in the calculation result (see image) but gives an error and won't let me save the expression.Any ideas on how to bring in the owner name into a field?   

Hi All,  I am trying to use a currency value from a custom object as a token in an email and can't seem to figure out the right Velocity Scripting to have it format correctly. I want the value to appear in the email formatted as $123.45. Can anyone let me know what adjustments I should make to the script?  #*${dSServiceEventDetails_PROD_cList.get(0).sVCTotalAmount}*# #*${dSServiceEventDetails_PROD_cList.get(0).sVCROClosedDate}*# #set($sortedList = $sorter.sort($dSServiceEventDetails_PROD_cList, "sVCROClosedDate:desc")) #if(!$sortedList.isEmpty()) #set($mostRecentEvent = $sortedList.get(0)) #set($mostRecentTotalAmount = $mostRecentEvent.get("sVCTotalAmount")) $mostRecentTotalAmount #else Call our sales team for your offer! #end Thanks for your help!  Marc

What is the most effective way to check if customer has adequate consents but during journey? Condition Node? What are your methods?

I am dealing with several types of data from Adobe Analytics, but discovered certain discrepancy.We are using CID with URL to track the campaign traffic. Now for two separate reasons I capture data in 2 different way.1st Way:Tracking Code ------- Unique Visitors 2nd Way:Tracking Code ------- Unique Visitors -------- Bounce Rate ------- Avg Time Spent Now I am seeing difference in "Unique Visitors" in 2 dataset. Numbers are less in 2nd way, is the difference is due to the separate parameters in 2 cases? Or there might be  some error in data?RegardsUtsav 

Every time I open workfront and go to timesheets on my windows 11 pc using Google Chrome, it appears to shake violently. It looks like the 2 scrollbars keep appearing and disappearing. It occurs until I change the width of my browser to around 50% of my monitor width.It's been happening for a month or 2.  It's a very distracting UI bug, that I hope someone is going to fix. I have attached a couple screenshots of what keeps switching, between 1-small_scrollbar.png and 2-full_screen_scrollbar.png.It seems like it can't decide whether to use the fullscreen browser scrollbar or the one for the timesheet table.  Please fix this, so I don't get epilepsy.  3 months ago the site didn't used to do this.  There was some change pushed out that broke this.

 I am configuring a custom form, one of the fields is called Media, within this option there is an option called In-person, when you choose this option the option place where it is taught is displayed (a simple text box) and then you must proceed to the next option called start date (date field)The problem is that when the option (lugar donde es impartido) is displayed, another option also appears that should not appear.I am attaching the configuration of the field, I cannot find where the error is. I hope you can help meRegardsHugo

Hi, I am trying to extract some information from the AJO datasets, and I would like to know some more details about some of the fields.For example, what are all the values that can shows under _experience.customerJourneyManagement.messageDeliveryfeedback.feedbackStatus and what is their meaning> I can see stuff like sent, delay, error, exclude. I would also expect something like bounce, but what else?Is there a DETAILED documentation on these tables and what they contain?Please note I already saw this one: Journey Optimizer Schemas, and the descriptions are very brief and do not answer my question. So my question is: ca I find somewhere a more detailed description of the fields, especially the ones with a finite number of valid values, like feedbackstatus above?Thanks

oneTrust token expires within a year in source connection. has anyone tried any automation to pull the new token from OT and update it using AEP API(or other way) to AEP, so that no one has to do it manually if the frequency of token expiry is year or less ? Are there any best practice recommendation to avoid manual re-update of token in source connection?

I would like to parametrize particular attribute of request body of Custom Action. Is it possible??  

Is there any materials out there talking about the Workfront to Sharepoint integration? I'm having a heck of a time getting my IT department to help me get this sucker connected and now I have to figure it out. I'm looking for ANYTHING on this. I've done everything the pages can teach me but it's still not right. It seems as though they are pointing people to a specific Sharepoint folder inside of Sharepoint instead of the root folder. Can anyone share information with me on this? Thank You,Deb

I am using StringAgg(<value>,";") but is giving error when run campaign. Anybody tell me correct syntax.

Hi, I have created a mapping set to map all the attributes coming as part of a csv file. Then using this mapping set in a dataflow to load all the data in a dataset (Experience Event). In my csv file I have couple of date time attributes containing values like "2025-02-16T14:39:13.000", "2025-02-16T07:14:36.000" etc. In my XDM schema corresponding columns/attributes are defined of type "DateTime". When I run my dataflow I do not get any error but these date time columns shows null values in the dataset. All other attributes shows correct values in the dataset. After this behavior I tried to update my mapping set with following date() function but still the values are coming as Null for those date time columns: Data Mapping Test 1:{"sourceType": "ATTRIBUTE","source": "date(trim(action_ts_utc), 'yyyy-MM-dd HH:mm:ss')","destination": "_tenant.actionTimestamp"} Data Mapping Test 2:{"sourceType": "ATTRIBUTE","source": "date(trim(action_ts_utc), 'yyyy-MM-dd T HH:mm:ss')","dest

Hi there, We have a scenario where our email system and our AA instance are wildly off. I know comparing between two platforms always leads to issues however there is no trend whatsoever between the two systems. We decided to run a test, an email campaign that would only be sent to select internal users, and test on a multitude of devices, browsers etc. The email would contain a number of links to products and has unique campaign info that we can use to know that it is only our data. We found that all users using desktop were tracked as expected, so no issues there. However on mobile, only 3 of the 8 tests we did reached AA. In instances where we clicked on the email link from a mobile browser, seemed to reach AA ok. However, if we clicked on the links from outlook or gmail apps, there were more issues with receiving the data in AA. My question is - does anyone know of any issues surrounding email app clicks and how that works with AA tracking? The link clicks have opene

Hi,I'm using Azure (Legacy) for our data feed and we have a folder within our container. I don't see any setting to set the folder path. I tried to put "container/folder" in the container box but doesn't seem to work. Is there a way to set the path?  

Hi, I am trying to start a workflow on the basis of asset creation event in dam. It is working perfectly fine in AEM cloud local server but post deployment it is not working , though when i am starting the workfloww from workflow model , workflow is working fine . i am attching the code here, what can be the issue. Please guide me on this. What can be the alternative. @ankurahlawat-1 @arunpatidar  @erika_antkowiak  package com.disney.core.listeners;import com.day.cq.dam.api.DamEvent;import com.day.cq.workflow.WorkflowException;import com.day.cq.workflow.WorkflowService;import com.day.cq.workflow.WorkflowSession;import com.day.cq.workflow.exec.WorkflowData;import com.day.cq.workflow.model.WorkflowModel;import org.apache.sling.api.resource.LoginException;import org.apache.sling.api.resource.Resource;import org.apache.sling.api.resource.ResourceResolver;import org.apache.sling.api.resource.ResourceResolverFactory;import org.osgi.service.component.annotat

Hello fellow experts, I am about to take my Adobe Marketo expert - business practitioner exam. I am wondering what type of Questions can be asked on below topics: Given a scenario, define the next stepIdentify the root cause of a problemDemonstrate/apply the correct configuration to Engagement ProgramsIdentify and apply the appropriate use of the PMCFPerform and analyze an A/B test strategyUse Webinar provider information in an event programIf anyone can share some light on these topics, it would be great to hear. I have already taken the practice test, just looking for some more information on this. marketo certified expert exam Questions 2024 ThanksFaizal

I'm investigating a form issue where hitting the submit button triggers a form submission event even if the form is not submitted and we have a form error event fired right after. So in the debugger we see form submission event -> form error event in subsequent hits.I'm trying to isolate these instances by building a visit level segment, but I'm not sure if this working properly. Which option would fit best my requirement?All visit level, options:[Form success event exists] Then [Form error event exists][Form success event exists] Then within 1 Hit [Form error event exists][Form success event exists] Then within 1 Pageview [Form error event exists]I created a report using Form success event as the metric and compared these three segments.Questions:Is the "Then" operator on his own referring to subsequent hits or does it include scenarios where the second hit in the sequence happens at any point after the first one? So within the visit if visit level and for a  visitor at visito

Hi Community, I new to Adaptive forms. We have a requirement to create Adaptive forms on AEM 6.5.21.  We have both custom template and form ready on local AEM 6.5.21, but on installing it on higher env, we can this error:Errorlog:org.apache.sling.scripting.sightly.SightlyException: Identifier body.js cannot be correctly instantiated by the Use APIat org.apache.sling.scripting.sightly.impl.engine.extension.use.UseRuntimeExtension.call(UseRuntimeExtension.java:76) [org.apache.sling.scripting.sightly:1.4.22.140]at org.apache.sling.scripting.sightly.impl.engine.runtime.RenderContextImpl.call(RenderContextImpl.java:72) [org.apache.sling.scripting.sightly:1.4.22.140]at org.apache.sling.scripting.sightly.libs.fd.af.components.page2.aftemplatedpage.afpagecontent__002e__html.render(afpagecontent__002e__html.java:89)at org.apache.sling.scripting.sightly.render.RenderUnit.render(RenderUnit.java:53) [org.apache.sling.scripting.sightly.runtime:1.2.6.140]at org.apache.sling.scripting.

Hi, Are there any OOTB table components with sort, filter, and column search options?Or suggest how we can achieve it?