Product Communities

is there an API to query "select * from datasetName" or any other complex query to get the response of SQL result ?

My team and I have encountered this error a couple times now - Some larger emails with more personalization have mirror page URLs that are too long to function properly, with the error message that the length surpasses the supported character limit.Adobe seems to be working on a solution to extend this mirror page url character limit beyond the approx ~4000 character limit, though its not clear when that will happen. Still I'm curious how exactly AJO constructs that mirror page url, especially so we can plan around it until the limit is extended.Roughly, it seems like personalization attributes within the email content are hashed and then stored in that url? But I believe there's also some kind of signing that happens, and/or maybe other processes?Any info about how AJO constructs email mirror page URLs and the factors that contribute to its length would be greatly appreciated!

Hi Everyone - I did following implementation to enable permission sensitive caching in my AEM 6.5 instance:1. Created an AuthCheckerServlet at /bin/permissionChecker2. Added /auth_checker section in dispatcher file with uri mapped to uri in #1 above3. Added allowAuthorized ="1" in /cache section4. restarted dispatcher I verified following in dispatcher log:1. On dispatcher start, i see a message "Authorization checker: initialized with URL '/bin/permissionChecker'2. When i go to any secured page, i see following in dispatcher log:[Wed Oct 29 21:31:39 2025] [D] [xxx] Authorization checker: backend answered with status code: 403[Wed Oct 29 21:31:39 2025] [D] [xxx] No socket reuse: response body not fully consumed[Wed Oct 29 21:31:39 2025] [I] [xxx] authorization checker denied access: /mnt/var/www/html/content/abc/secure.html[Wed Oct 29 21:31:39 2025] [D] [xxx] cache-action for [/content/abc/secure.html]: NONE[Wed Oct 29 21:31:39 2025] [I] [xxx] "GET /content/abc/secure.html" 200 no

For each component, I need to create a new GraphQL query and share it with the consumer team.To streamline this process, I am preparing a technical mapping document for the module's GraphQL query responses and VD image. Is there an efficient way to generate documentation for GraphQL responses? Field Mapping Screenshot:  Note: I tried swagger API. It is helpful for only REST API Thanks!

Adobe Journey Optimizer Community Lens Newsletter  Your quarterly roundup of insights, events, and member highlights Subscribe to the AJO Community Lens Newsletter   Hello AJO Community!  Welcome to your quarterly roundup – a curated snapshot of what’s happening across the AJO Community. From standout member contributions and the latest product releases to trending questions, ideas, and on-going learning opportunities, this is your go-to guide to stay connected and inspired.  This newsletter will be published every quarter, bringing you the latest highlights and insights in one place.  We’d love for you to explore the threads, celebrate your peers, and share your own solutions and ideas. Your voice shapes the future of AJO. So, jump in, comment below, and keep the conversations going!    Member Spotlight  Thank you,@satheeskannak, for everything you do to make this Community so great! Your deep expertise and generous spirit have truly

I'm not seeing a way to do this, but just wanted to check first. And I'm just trying to work around a backlog of IT resources... So is it possible to do regular expressions within a processing rule? As an example, I basically would want to do something like this one where I could pull out the third value in a string separated by some common character(s). In this case, the characters are -_- and there are two of them so it would need to know its after the second occurrence.  

Problem Statement For certain AJO use cases, an email delivery may need to be sent, where the profile may not yet exist in AJO. As an example, let's say you are sending an order confirmation email to a new subscriber. The confirmation email needs to be sent immediately, but the customer registration went to your CRM, which might only sync to AJO daily. This could also apply to other use cases like registrations and double opt-in. If your journey uses profile data, but the profile doesn't exist yet, you won't have an email address to send to. So you'll need another method to deliver the email.   Solution Overview This guide will cover how to execute an event-based delivery in a journey, which can handle both scenarios where the profile does or doesn't exist yet. As a result, you will be able to deliver an email regardless of if the profile has synced from another source like a CRM. To enable this, we will need to specify the Email Address used in the journey. While you'd usually u

Popping up different Dynamic Chat dialogues for known SFDC Contacts vs. SFDC Leads is a basic ask. It’s a smidge trickier than you might expect, though, for 2 reasons:   (1) you can’t sync SFDC Type from Marketo to the DC database(2) you can’t sync SFDC Is Deleted, another key component   Don’t worry, it’s still easy.   Mirror SFDC Is Deleted Create a custom Boolean field SFDC Is Deleted Mirror. Keep that field updated with a simple trigger campaign:   Sync SFDC Contact ID, SFDC Lead ID, and the new mirror field With the mirror field in hand, you have everything you need to reproduce SFDC Type in Dynamic Chat:   Build your audience criteria Now you can match SFDC Contacts:   And SFDC Leads:   Not too intimidating, right?  

In Adobe Experience Platform - Data Collection, under Rules, I’ve created a rule that triggers on page load (any element). Within this rule:I’ve added a Core - Custom Event.I’ve set the necessary variables, including:eVar2 to capture the Page URL.I’ve added the Adobe Analytics - Send Beacon action with s.t() to send a page view beacon.This setup is successfully capturing eVar2 values for all pages, as confirmed via Omnibug.However, in Adobe Analytics Workspace, when I create a report with:Dimension: eVar2 (Page URL)Metric: VisitsI see the following output:www.example.com/page1 - 5 Visits www.example.com/page1/subpage1 - 5 Visits www.example.com/page1/subpage2 - 3 Visits Unspecified - 3 Visits Problem: Why is "Unspecified" showing up?Even though Omnibug shows that eVar2 is being populated, "Unspecified" in Adobe Analytics usually means that eVar2 was not set or persisted at the time the beacon was sent.

Hi everyone! Back at Summit in March, we heard about non-labor resources coming to Workfront. Has anyone seen any updates on this? It's a key thing for our team as we manage a large equipment inventory, and I'd love to streamline our systems. Thanks!

Hello!  I have Document Version report that filters by pending decisions and a specific active stage.  This was previously working fine, but now it is not removing the proofs where a decision has been made on the stage. As if its no longer considering that stage inactive. The stages are typically unlocked, though if no more decisions are required and its moved on to the next stage, it should still not be pulling in. What am I missing? Thank you! 

I have a document report which shows all files within a task folder called Final Files. However on occasions our team is creating subfolders and the report is not picking up any of the files that sit within those subfolders. The subfolder names are not consistent and therefore unable to pick up with an AND: for an additional folder name.I am currently using this text mode which works if the files are sitting directly under the Final Files:EXISTS:a:$$EXISTSMOD=EXISTSEXISTS:a:$$OBJCODE=DOCFLDEXISTS:a:documentID=FIELD:IDEXISTS:a:folder:name=Final FilesEXISTS:a:folder:name_Mod=eqprojectID=XXXXXXX Any help would be really appreciated.projectID_Mod=in

I got this message when trying to log onto my Workfront dashboard:Error 500-006The page isn't loading correctly. Please check your login and try again. If you continue to get this message, contact customer care and reference: EIM Instance Id 002e0042-b4f4-11f0-9e9b-ebb14ea46d7fDoes anyone have any idea how to resolve this?Thank you.

Hey there! Last week, I noticed an issue where MVTs targeted to exactly one page were instead showing sitewide on the Property. Curious, has anyone else has experienced the URL scope being ignored? I'd love to hear if others have seen the same issue recently or found a cause or workaround.Thanks in advance!

1. Is it possible to copy a section of one journal and paste it into another?2. Is it possible to create something like a block consisting of several conditions that we can use in all other journals?Example: I check the time and date before sending an email. These are a few conditions. I'd like to have this check in all my journals.I don't want to define it every time in every journal

Requirement:Currently, the Sling Distribution Forward Agents utilize the Apache Sling Distribution Packaging – Vault Package Builder Factory to export packages. However, I want to configure a custom Package Builder that can export or replicate files in their native format instead of using the Vault packaging mechanism.In other words, the goal is to export the content as-is — for example:If the file is a JSON, it should be exported as a JSON file.If it’s an HTML file, export it as HTML.If it’s an image, export it as an image.At present, the default Vault packaging exports the data in a binary (vault) format, which is not desirable for this use case.I would like to understand whether this can be achieved through configuration or if it requires a custom code implementation, so I can proceed accordingly.Currently using the default vault packaging in my forward agent :  

Hey Workfronters! It's me, Teddy, your unofficial (but very determined) Workfront mascot-in-training! I'm on a mission to earn my official Adobe Workfront sponsorship - one task, tip, and treat at a time. ❤️ This Halloween, I'm putting my best paw forward to show I've got what it takes to keep projects running smoothly --even with pumpkin lattes in hand and spooky deadlines lurking around every corner.  Now its your turn!Share below: Your favorite Workfront tip or trick that helps you slay your daily monsters (a.k.a. overdue tasks).Or your Workfront-themed Halloween costume idea - the more creative the better!Help Teddy prove that teamwork (and a little fluff) makes the dream work! 🐻✨ Stay pawsitive and keep your projects on track-or-treat! - Teddy the (Aspiring) Workfront Mascot @kurt_jones @cynthiaboon @lesliespier 

Hello, I currently have a subgroup within a main group. I would like to remove this subgroup from the list and turn it into a main group. Is there a way to do this?

Has anyone tried swapping review tasks for approvals for light users? The main issue I see with this workaround is that My Approvals in Home doesn't show due dates or bucket approvals by due today, past due, etc. which is critical for our heavy users who may have 10+ approvals in their queue if we moved review tasks to approvals. We could pull a report to show due dates, but then users wouldn't have the decision buttons in the same location as the due dates and we need the process to be as streamlined and straightforward as possibleIf you have other workarounds for having light users complete tasks/approvals, please let me know.  Background:We're trying to find solutions to the high cost of the new Workfront license structure for standard licenses since the majority of our roughly 100 users have worker licenses to mark done with their part on tasks with only 3 PMs. We were told our costs would roughly triple if we have the majority of our users move from worker lice