Solved

I would like to search for any users under home/users with a first or last name that contain a non-alphanumeric character. I've tried the following SQL2 but no luck: SELECT * FROM [rep:User] AS user WHERE ISDESCENDANTNODE([/home/users]) AND [profile/familyName] is not null AND [profile/familyName] LIKE '%[^a-zA-Z0-9]%' AND [profile/givenName] is not null ORDER BY [profile/familyName] 

How to set up an email with dynamic “To” field where the email can be sent to difference audiences based on some attribute ?

Hi guys, For pages and assets, once you publish(or republish) that content, the replication or distribution service will start the process of invalidating the dispatcher cache.But how can I start the process of invalidating the response cache of a persistent query? It seems that publishing the content fragment does not do the trick.(And I couldn't really find an answer in the documentation) Any help is appreciated, thanks!

Hi, hope you are safe and sound. I have 5 numeric fields, formatted as "%". Display patter: num{9.8'%'}|num{99.8'%'} Each field is limited to max. two characters with below script on change event: if (xfa.event.newText > 99) {xfa.event.change = "";} 6th field is "Total", where sum is calculated for those 5 fields. Calculate event for the "Total" field: this.rawValue = form1.Page1.Subform13.Subform14.Table4.Row1.Percent1.rawValue + ... form1.Page1.Subform13.Subform14.Table4.Row2.Percent5.rawValue; Is it possible to go through all 5 fields and delete only the value from the field I'm currently in, if the "Total" is exceeding 100%? e.g. "Percent1" = 55% + "Percent3" = 60%   -- delete 60% from Percent3"Percent3" = 25% + "Percent5" = 70% + "Percent4" = 6%  -- delete 6% from Percent4"Percent5" = 35% + "Percent2" = 90%   -- delete 90% from Percent2 like, any field combination and in any order? Thanks

Hello All, I am doing customization of Adobe CQ DAM Expiry Notification. To understand the existing logic of Adobe CQ DAM Expiry Notification , I have de compiled the bundle(com.day.cq.dam-dam-core). Then noticed Adobe CQ DAM Expiry Notification is a scheduler named: ExpiryNotificationJobImpl.java and we are using one helper class named: MailHelper.java inExpiryNotificationJobImpl.java. MailHelper.java is using com.adobe.granite.jobs.async.notification.email.EmailConfig class. While doing the modification I am having issue to import com.adobe.granite.jobs.async.notification.email.EmailConfig. First I have find out the dependency as shown below -  Then added the maven dependency in pom.xml file but it didn't get downloaded.I have searched com.adobe.granite.jobs.async.notification.email.EmailConfig api document also but couldn't see anything. Do we have replacement of com.adobe.granite.jobs.async.notification.email.EmailConfig?Is com.adobe.granite.

Last week a customer deleted an eVar that caused quite a stir. A calculated metric was using the eVar, and a Report Builder job was using the calculated metric. Needless to say, the Report Builder report failed, and we had to find out why. We discovered that the eVar was deleted. Rather than rebuilding the evar, the team decided to modify the calculated metric to remove the eVar reference. Issue fixed. 🙂But that raises a question. Is there a best practice to determine the reach of an eVar, prop, or event? For example, is there a known procedure to perform when decommissioning variables and events to prevent downstream reporting issues?

Hi Team,We have admin console url for our organization. how can we add the user to the admin console

Hi All, I am having a hard time figuring out if it is possible to copy and paste a Experience Fragment Template into another folder. When I try to do so, I will get this error. In the example below I was trying to copy and paste a Header(Experience Fragment) from "us" to the site folder in "Language Masters".   

Hi, my problem is a small but irritating one. I am sending a few scheduled projects (not reports) to a group of people as email pdf but for some reason copying and pasting e.g. 10 email addresses at once and adding those to a project recipient list does not work (I've tried several ways and my colleagues have the same problems). Now I have to type or individually copy each email recipient for scheduled projects every time by hand...So is there a way to successfully copy and paste or otherwise attach a list of email addresses to a scheduled project's mailing list? I see there is a some kind of mailing list option for reports but this is a project problem. Or is there a way to elsewhere create mailing lists that can be attached to projects? IF a report is the only way so how do I turn a project into a report?

Hello, Are there detailed, step-by-step instructions available for setting up https/ssl for an AEM 6.2 Forms JEE installation running on JBoss?  I recently installed the AEM 6.2 documentation Adobe has available but it doesn't seem to address this particular type of AEM installation.   And I haven't had much success searching the internet,  really can only find articles for AEM 6.3 and greater.  And a couple of these articles just state what a chore it was to get https/ssl configured on AEM 6.2 and earlier.  😞   Thanks a lot,Ray 

Dear Marketo community, I need to send a campaign to a specific user list. It is a transactional campaign, so it is also supposed to be sent to all users (unsubscribed, bounces, etc.). When I check smart list status (the only criteria is that a user is part of this list, nothing else), half of the users are blocked. My question: 1) Why are they blocked?  2) Will they still receive the email 3) If not, how can I make sure they receive the email?     Thank you in advance!  

Hello,The /authorize API does not work for any other scope than openid. To eliminate my code as the problem I tried it in the OAuth Playground and was able to reproduce the problem. I tried three scopes:1. openid2. openid,creative_sdk3. creative_sdkOnly #1 was successful in generating the token. All others failed with invalid_scope error.

Hello everyone, does anyone know how to create service user using yaml config (AC Tool) & How to get Resource Resolver for access jcr node.

Hi ! , After creating components and templates in CRX ,I couldn't create a page with newly updated template, Since the "Create Page" option isn't available [ Sites -> Create -> "Create Page" ]I've installed AEM twice and the issue persists, Kindly help ! :)

Hello everyone. I have a requirement to add the last published Date-time on a standard pageview event so that we can see when the last time a page was updated (keeping content up to date and relevant).  The developers can pass this in any format I need but I'm struggling to find any documentation around what format to use so that I can evaluate the hours/days/months between to setup different alerts (some content may need an alert triggering after a few hours, some a few days and most 6 months or so) Has anyone done something similar? if so in which format did you pass the Date time to an eVar/Event etc?

Hi team,I see s.AudienceManagement.setup() is not a function error as we have just upgraded app measurement and moved from custom library to managed by Adobe and trying to load AAM using AppMeasurement_Module_AudienceManagement JS with the function s.loadModule("AudienceManagement");because we want to load AAM conditionally. Do we have any updated AAM library to resolve this issue? 

Hi,We have many instances of below mentioned logs, though all them have just the OOB classes.Is there a solution to this (except for suppressing the logging)18.01.2022 15:58:21.717 *INFO* [Apache Sling Resource Resolver Finalizer Thread] org.apache.sling.resourceresolver.impl.CommonResourceResolverFactoryImpl Unclosed ResourceResolver was created here:java.lang.Exception: Opening Stacktraceat org.apache.sling.resourceresolver.impl.CommonResourceResolverFactoryImpl$ResolverReference.<init>(CommonResourceResolverFactoryImpl.java:538) [org.apache.sling.resourceresolver:1.7.2.B0001]at org.apache.sling.resourceresolver.impl.CommonResourceResolverFactoryImpl.register(CommonResourceResolverFactoryImpl.java:228) [org.apache.sling.resourceresolver:1.7.2.B0001]at org.apache.sling.resourceresolver.impl.ResourceResolverImpl.<init>(ResourceResolverImpl.java:105) [org.apache.sling.resourceresolver:1.7.2.B0001]at org.apache.sling.resourceresolver.impl.ResourceResolverImpl.<init>(Res

Hi, I am facing Http error 503 authentication support missing while opening publisher server.  In the logs file it is showing AuthenticationSupoprt service missing. Cannot authenticate request.Please find below the error screenshot: Could you please help me on this asap as it is a production publisher. 

Hi,Checking what can be better approach to implement countdown time so that:- On Day3 it displays message text X- On Day2 it displays message text Y- On Day1 it displays message text Z All these X ,Y , Z message should not be exposed to end user before time. We are planning to expose Product Promo codes each day which end use should not know before that date. Should we use Target in combination to Experience Fragment so that Target keep changing content based on Day3 , Day2 ..Day1.Or any other good approach anyone tried.thanks in advance. 

Hey there,I've been trying to calculate the number of times that a specific custom link was hit during a visit, using the segment builder. I'm not sure if what I've defined is the most accurate way of doing it. Does anyone have an opinion?  i.e : two filter criteria were selected during a visit: 

What is the best practice for nms:recipient schema while importing from different sources such as CRM & Gigya (with multiple profiles for a single user with same email id)  and some other resources as well. What approach is the best ? is it okay to have duplicate records to have different profiles with same email id with different external IDs. #AdobeCampaignClassic #Gigya #CRM #ACC

Any Links or resource available on " how to host and deploy adobe campaign classic tool ? "

Hi All,I want to download package which is created by package manager using cURL command.If anyone come across using this kind of command please share with me.I have tried below but not succeeded.curl -k -u "$USER_NAME":"$PASSWORD" -X GET "$URL""$PORT"/etc/packages/my_packages/testpackage123.zipurl -k -u "$USER_NAME":"$PASSWORD" "$URL""$PORT"/etc/packages/my_packages/testpackage123.zipThanks In Advance,Kishore

I am trying to get browser name in servlet but it is giving me all browser details. Is there any way to get accurate browser name ? String browserName = req.getHeader("User-Agent"); String secNa = req.getHeader("sec-ch-ua"); LOG.info("browserName !!!!!!!"+browserName); LOG.info("secNa !!!!!!!"+secNa);Below are log infoFF browser:-browserName !!!!!!!Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Firefox/91.0secNa !!!!!!! nullChrome brwoserbrowserName !!!!!!!Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36secNa !!!!!!!"Chromium";v="92", " Not A;Brand";v="99", "Google Chrome";v="92"Opera brwoser :-browserName !!!!!!!Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36 OPR/78.0.4093.147secNa !!!!!!!" Not A;Brand";v="99", "Chromium";v="92", "Opera";v="78"

Hello, I have 30 smart campaigns that I need to activate with a scheduled recurrence.  I see that those values are in the Update Smart Campaign API call, but I'm not sure I can edit those. I use the marketorestpython library (jepcastelein). That library does not include the update call. I'm hoping that I can update the campaign  and then activate it.   Thanks, Dennis