Solved

I am running aem sql 2 query in java.query : SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE([/content/apples/en]) AND s.[sling:resourceType] = 'apples/components/page/article' ORDER BY s.[published] DESCI am using javax.jcr.query.Query query API to generate a query. I am also Session session = resolver.adaptTo(Session.class);QueryManager queryManager = session.getWorkspace().getQueryManager();javax.jcr.query.Query query = queryManager.createQuery(sqlStatement, javax.jcr.query.Query.JCR_SQL2);query.setLimit(limit);query.setOffset(offset);QueryResult result = query.execute();In result i am able to getting 10 results with starting from offset. But if want actual full request set of the query Can you suggest me correct way to get it. I am trying to implement pagination logic. in result set. I have to result back  first 10 results and total count of the query.Please suggest correct way to implement this using SQL2 query.

Hey everyone,We have a form for people to update their email preferences one but we realized that the Fields we chose initially are labeled wrong. Instead of the default 'Subscription - Educational' fields from Marketo, we are using custom ones we made for all other forms. However, we didn't update it for this particular form. When I went in to change the Fields, I noticed that the Value property was removed (see photos for what I mean). We want to add the 'Value' and 'Label to Right' property. How can we rectify this situation? Our forms are designed so that the Label property stays blank and the Value property shows the information since we use rich text.Thanks!

Hello!I am setting up a subscription management page and want leads to be able to see their current settings before opting to change them. If they haven't visited the page before, the form selections show up empty like in the screenshot below.My question is: is there some custom code that I can use to update the form with that lead's current field values once the email address field is filled-in? Has anyone approached this another way?Thanks!

I'm working on a large website that I am certain gets more Visits than Entries. I am working off very simple segments that are just Page/Page Name = x. I don't understand why my Visits and Entries are coming out equal?

When I run a predicate query with sling:resourceType= apples/components/page/article and orderby=@jcr:content/cq:lastModified&orderby.sort=descI get results with  sling:resourceType= apples/components/page/article but I dont see sort order working.http://localhost:4502/bin/querybuilder.json?path=/content/apples/en&property=sling:resourceType&property.value=apples/co… path=/content/apples/en&property=sling:resourceType&property.value=apples/components/page/article&orderby=@jcr:content/cq:lastModified&orderby.sort=descIs there any issue with my query? Can some one help me with that

In the 6.5 release notes there is this item:Expose lists of Content Fragments via Content Services with the Content Fragment List Core Component.The link goes to the development branch of core components and not the master or current release (2.3.2). Is this an oversight in the 6.5 release notes that didn't get removed when this new component wasn't included in the March core component release or do the core components need to be updated on github to show this component is no longer in development?i have a client that could use this functionality but it doesn't appear its officially part of the current core component release and is not in the 6.5 GA release.

Hi,While our DB has many tables that are using their own custom sequence, xtknewid is still being used by a select few large tables. What I've found is that while there is a fair few new records inserted, it pales in comparison to the rate of which xtknewid is increasing (eg. if 2 million new records are inserted using xtknewid in total, the sequences still goes up by 20 million or so).This leaves the most likely conclusion that the cache value of xtknewid is contributing to this growth (it is currently set to 30) and decreasing it to a smaller number will solve this problem. What I want to find out is what is a session in the context of Postgres inside ACC? At the moment, the cache is set to create 30 new records inside the DB per session.

Hi All,I am able to search with in a path for multiple properties with OR condition group predicate (Search with path if prop1 or prop2 exists)http://localhost:4502/bin/querybuilder.json?path=/content/app/path&group.p.or=true&group.1_property=color&group.1_property.operation=exists&group.2_property=font&group.2_property.operation=exists&p.hits=full&p.limit=-1But the correct syntax is not known for multiple paths and properties (Search with path1 or path2 if prop1 or prop2 exists). Reference document for predicates gives a way to specify nested groups but for multiple properties not sure.group.p.or=truegroup.1_group.path=/content/geometrixx/engroup.1_group.type=cq:Pagegroup.2_group.path=/content/dam/geometrixxgroup.2_group.type=dam:AssetAny pointers would be helpful. Thank you.Sandeep

I downloaded and authenticated the new 3.0 Analytics health dashboard, and am super excited to use it, but does anyone know how to select a login company? My org has multiple login companies, and the dashboard seems to select one at random every time I authenticate, and I can't find a way to select one. Is this possible?

Can someone help me out? We have a general form for events, so when creating our registration campaign for each event, this is how I have set it up. I have played around with different scenarios with no luck. Seems redundant, however it seems to be a 50/50 shot as to whether people actually go through the flow steps. They become part of the program, however they never end up going through the flow steps. Support has said its a system timing issue which shouldn't happen often, however it is happening every time. I feel like I am always running back-fill campaigns! Do others experience this and if so, how do you solve this problem? I should also mention, we have a small database and not many trigger campaigns running. Thanks in advance!

Hey guys, I am working with Adobe analytics and adobe launch integrating with AEM, and I am getting some trouble with integrating Activity Map metrics on aem pages, I already tried to follow the articles and got nothing at all, I think that this could be something to do with UsersGroup on Analytics.If someone please could provide me a updated article It probably would help a lot.

Hi All,I'm facing issue with this above API class, I'm working with AEM 6.3 SP2  version. Is this api deprecated ? Because of this my jsp is not getting compiled. Any suggestion will be helpful.

Hi,AS per release notes of AEM 6.3, com.day.cq.security.profile.ProfileManager API is deprecated in this version.Could you please tell me replacement for this or any other way of getting profile?

Hi Team,I have a requirement where I need to add a custom footer to the aem/start.html page.I saw the below code in "/libs/granite/ui/components/shell/page/page.jsp " where there is a globalfooter being referred to but I do not see one in the start up page.Resource globalFooter = resourceResolver.getResource("/mnt/overlay/granite/ui/content/globalfooter");if (globalFooter != null) {%>       <%for (Iterator<Resource> it = globalFooter.listChildren(); it.hasNext();) {        %><div> Footer Inside Loop Here</div><sling:include resource="<%= it.next() %>" /><%    }}Can somebody help to add a custom footer to the aem landing page ("aem/start.html")Thanks,Debasis

We have two Marketo forms in a single page and display of forms will be controlled based on mktoPreFillFields, something like thisMktoForms2.whenReady(function (form){if(typeof mktoPreFillFields != "undefined" && !jQuery.isEmptyObject(mktoPreFillFields)){/* Show form2 and hide form 1 */ }}With the new Marketo Form Pre-fill Feature upgrade​ we had to use Sanford Whiteman's solution for Pre-fill of forms. Unfortunately Pre-fill of forms is happening after the above function is executed and only form1 is getting displayed every time. As there are two MktoForms2.whenReady() functions , is there a way to control the flow between the two like pre-fill executes first and then the above one? Any suggestions are welcome. Thanks in advance!

Recently we have done AEM in place upgrade from AEM6.3 to AEM6.4. once the upgrade is completed with 6.3 custom code(built using the uber-jar.6.3) we observed that the 6.3 bundles are up and running in AEM6.4 without compiling and building with uner-jar6.4.is it is the right behavior 6.3 bundle status is active in AEM6.4 environment? please suggest.

Hi guys,I want to use typology rules to limit the number of deliveries for an email within a week. But I want that some "operational" deliveries skip this rule. Is there a way to flag these so they won't be on the typology rule? And how can I set it so it only skips the limitation rule but not the other typology rules.thank you!

Hi there,I met an issue when sending out emails via my personal server.I set the server configuration per the guideline but still failed to send out the email. (The SMTP server is installed, I can correctly send/receive letters using methods other than Adobe.)The proof status is stuck at "start pending".And below is my MTA setting for serverConf.xml:<mta args="-tracefilter:nlmta" autoStart="false" dataLogPath="" debugPath="" dnsRequestLogDelayMs=""       errorPeriodSec="300" initScript="" logEmailErrors="true" logLevel="2" maxMemoryMb="1024"       maxProcessMemoryAlertMb="1800" maxProcessMemoryWarningMb="1600" minConnectionsToLog="100"       minErrorsToLog="1" minMessagesToLog="1000" notifRelay="" processRestartTime="06:00:00"       purgeDataLogDelay="15" retryLostMessages="true" runLevel="10" statServerAddress=""       statServerTLSSu

Hi, We want to achieve auto-suggest search box, suggestion should be obtained through search and promote. And suggestion is restricted to particular pages.Can you guide. Thanks,Nikunj

I've got a program where I created a link tag for an email. When someone clicks on the link and goes to the webpage and fills out the form, I add them to a list based on whether the tag was present in the URL. Am I correct in thinking I can just use a trigger: fills out form on specific webpage and add a filter: opened the specific email I sent and then add them to the list? Will this do the same thing as my initial scenario? Is one way better than the other?

How to Add Adobe Analytics SDK for iOS project via Carthage?

I'm working on a new email template and I'm trying to figure out if I've messed up my global variable or if I need to log a support ticket.We want a global variable for the email background color so I created the variable Email Background Color and have reference it on line 207 to set the color. However, when we open the email in the editor it is not showing up as a global variable. I've got my code below if anyone has any suggestions on what may be happening.<!doctype html><html lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><head><!-- Marketo Variable Definitions --><meta class="mktoColor" id="emailBackground" mktoname="Email Background Color" default="#000000" mktomodulescope="true"><meta class="mktoImg" id="heroBackgroundImage" mktoname="Background Image" default="http://go.schedulinginstitute.com/rs/090-EZX-133/images/tie-dye-background.jpg" mktomodulescope="t

Hello, I'm wondering if anyone has any insight into what the BAAAM error "Conflict" might mean. All the data matches what is shown in the Marketplace and 80% of the Create Segments BAAAM I just ran ran correctly. Anybody else ever work through a conflict with BAAAM?Glenn

I advertised taking a survey in my last email, and had someone fill it out. In the survey, I did not ask for contact information. So now I want to go into Marketo and track who the person was that filled out my survey. I've created an "Email Link Performance Report" that went along with the email campaign, so I can see what links were clicked by a certain amount of people. But I can't figure out how to see specific names that clicked on the links.

I am using AEM 6.2. I am getting a lot error notifications in AEM inbox. planning remove these notification from CRXDE .Anyone can help me that find out where it is stores inside the CRXDE?.