Solved

I am trying to build a report that shows information from our offer schema (label, start date, end date, HTML Rendering, etc.) based on use input of offer name and date.  I.e. user enters the offer name or start and end date and they are able to see the offer information. I am defining local variables and then using the query to filter by the defined variables.  Searching by offer label works fine but start or end date throws the following error. ORA-210000 Oracle error: ORA-00932: inconsistent datatypes: expected DATE got NUMBER WDB-200002 SQL statement 'SELECT O0.sLabel, O0.sName, O0.tsEnd, O0.tsStart, O0.sCode, X1.sLabel FROM NmsOffer O0 JOIN XtkFolder X1 ON (X1.iFolderId = O0.iCategoryId) WHERE (O0.sLabel LIKE :1 || :2 || :3 ESCAPE '\') AND (O0.tsStart <= trunc(:4, 'ddd')) AND ((X1.sName LIKE :5 || :6 || :7 ESCAPE '\') AND (O0.sLabel NOT LIKE :8 || :9 || :10 ESCAPE '\') AND (O0.sLabel NOT LIKE :11 || :12 || :13 ESCAPE '\') AND (O0.sLabel NOT LIKE :14 || :15 |

Hi , Wanted to know if there is any possibility to integrate javascript with junit  for writing test cases. Thanks

Hi, I have configured a data feed file in analytics. Some of the columns selected are as below, and I selected " BrowserBrowser_typecolor_depthcolumn_headersconnection_typecountryeventhit_dataoperation_systemspluginssearch_engines The compression format as "Zip", packaging type as "Single File", and destination as S3.I'm able to receive a zip file with data. However, when I unzip, the data is shown as multiple seperate files (each for one column) instead of a single report. Is it possible to receive all data as a single file? Regards,Sri

Hi,I have a requirement to-1)path based slinghttpservlet to execute some business logic and set attributes a, b in the slinghttpservletrequest2)Use the above set slinghttpservletrequest attributes, i.e a and b in sightly code.Please suggest how can slingMOdel with adaptable as slingHttpSErvletRequest could be used for the above usecase

Hi , When we have live-copy for assets , does asset references update on page rollout?  Thanks,Deepikaa

Hi Team,After deploying new packages in the "author", I am getting the below error very often, when I try accessing the custom application pages:             Also, when I encounter the above error in my custom application pages, I get the same error while trying to access some of the AEM pages as well (like, "/welcome.html" or "/sites.html" or "/start.html"). In many instances, I am getting the same error in "publish" as well (after replicating the pages).This was initially a showstopper, until I came up with a solution for this. After clearing the script cache (accessible through  <server>/system/console/scriptcache), the pages load fine.              Now my question, I want to know the root cause for this issue, so that I can fix it on a permanent basis. This issue is absolutely erratic in nature.

Hi Team, We got a request to implement below customization content fragment in AEM6.4. Could you please provide your suggestion/advise on this. 1) Add a paragraph text under a text field (granite/ui/components/coral/foundation/form/textfield), which provide some key notes about the text field( like "*Note the text field value much exactly match the value set up in the xyz system...") and we don't want to use field description and it need to be a paragraph. 2) We have a dropdown in the content fragment and we need to show/hide other fields in content fragment based on the dropdown value. ThanksSeran.

How to get File Attachments from adobe adaptive form to maven project?

Hi All,I have two email deliveries in my workflow. Is there a way in which I can restrict the no of emails each deliveries can send per day. For example, delivery-1 can send 1000 emails per day and delivery-2 can send 100 emails per day. I don't want the restriction to be based on no of emails sent per profile, but no of deliveries sent per email delivery activity. Thanks and Regards,Rahul

Hi, Our website has 2 different domains. So if we have 1 Launch property and 1 report suite for both the two different domains, would my MCIVD will remain the same across the two different domains or would it change.

Hi, my freeform tables used to display the scroll bars on the right of the table, but in the past few weeks this has disappeared even though the data is 30 rows (whereas below screenshot only shows 14 rows). I can only see the other dates if I drag the bottom of the table to make it longer. Previously I was able to use the scroll bar. Any solution?  Thanks 

Hi,As previously we were creating clientLibs under /etc/designs, and to allow these styles in dispatcher : we use to allow something like# design and template assets /0050 { /type "allow" /glob "GET /etc/designs/*" } # collected JS/CSS from the components and design /0051 { /type "allow" /glob "GET /etc/clientlibs/*" }  Now, since we moved all the clientLibs specific to component level.exmaple:  /apps/myproject/clientLibs or /apps/myproject2/clientLibs2 or /apps/myproject3/clientLibs3 In that case how to allow all the clientlibs in dispatcher.any file, ClientLibs i.e. under the /apps folder to different different component. Thanks @kautuk_sahni  @arunpatidar 

Ex: I edited two components on a page and I want to publish only one component edits today and another component edits tomorrow. Do we have any solution without creating page versions?

Hi,how to find the title which is repeated among two different content path using querybuilder in aem 6.5.i need this result as com.day.cq.search.result.SearchResult result. i am using this result object for pagination, total cound , exeution time in search results.i have tried with below approach- i have using the below constrainsts and getting the results then assign to one list and finding the repeated title then using result list. but while doing pagination and total count its giving worng data.predicate:1_group.1_path=/content/med/en/hm/pa/comm1_group.2_path=/content/med/en/hw/pa/comm1_group.p.or=truep.limit=10p.excerpt=falseorderby.sort=descp.offset=0,2_property=jcr:content/policy-details/number2_property.value=D-666orderby=@jcr:content/policy-details/versiontype=cq:Pagebut i want to achieve this in query itself. could you please give me right direction.Thanks in advance.

We have recently implemented Experience cloud for our Native Apps , right now we want to capture mid value into traffic and conversion variables , is there any way we can achieve this?

Hi Team, I am facing this error every time  try to login. Can someone help. 

Hello all,Are there any function on Campaign that support AES GCM (No padding)?Can you provide me an example to encrypt/decrypt a string?@jonathon_wodnicki @kapilkochar @milan_vucetic @anita_punmiya @jyoti_yadav @jean-serge_biro & Community Thanks in advace,Salvatore

Hiya All, I have a client who has a large number of leads without email addresses.  They are going to do a direct mail to try and garner at least some of these email addresses.  We do have these leads loaded into Marketo (yay for using the API)   The plan is to have a unique code in each letter that a lead can enter into a form.  If the code is valid, It'll then populate what we do know about the lead, and get them to update details and fill in an email address.  If the code is invalid, we'll let them know and get them to try re-entering.     Has anyone done this, and if so HOW did you make it all work.  If no one has done this, what might a solution look like?   BTW - NO - We will not be using the Marketo Lead ID.  the code will be a random set of letters and numbers meaning people can't just guess at the next number in the sequence to mess with other peoples data.   Cheers   Jo

Hi Team,I'm getting this error, please suggest how can I resolve this.

Hi, I tried using the below custom code to capture dropdown selection values as data element. It works in console but when i input the code as a data element and check the _satellite.getVar() for this data element, it just returns an empty value "". My Javascript is basic and i am fairly new to Adobe Launch so step by step instructions with visuals would be great.Thank you var selectElm = document.querySelector("#order_retailer_name")selectElm.addEventListener("click",function(){var elm = this;var selectedElm = elm.options[elm.selectedIndex].textContent;return selectElm;});

Hi, We are trying to change the domain of target cookies(mbox, mboxEdgeCluster). Currently the domain is for example : a.com we are trying to change it to a.b.com.Can someone help me on how to change the domain of these cookies. Thanks 

i need to export all the processing rules in the context data to simplify data elements and dimension. Can anyone advise me how to do this?example :  s.context.Data['section']="sales" map to evar2, evar3, prop5

I am looking for ACS Rest Api which can help me in downloading and installing packages in other words rest api's for exporting, importing and installing packages. Any directions would be helpful.

Once after building our dita maps (say more than 1000 articles) in AEM, how to make external applications(not in aem) to query to get the required results out of 1000? and also the response from AEM should be sent to those external applications in xml or json format. 

Hi,I have created a footer component that shows n number of links and hides all the other with a show hide button to show the remaining links based on user click. The first component authored works fine but the rest of the components authored are not responsive at all and the toggle functionality fails to work if the same component is authored multiple times on the page.Please find the below sample code of the component:HTML Code:<div data-sly-test="${wcmmode.edit}" data-sly-unwrap><div data-sly-use.clientLib="${'/libs/granite/sightly/templates/clientlib.html'}" data-sly-unwrap><clientlib data-sly-call="${clientLib.all @ categories=['author.widget.multifieldpanel']}" data-sly-unwrap/></div></div><div><div class="outer"><div class="title" id="alen">${properties.mtitle}</div><div data-sly-use.myClass="${'com.utilities.widgets.Multifield' }" data-sly-unwrap><div data-sly-list="${myClass.myHashMap}" data-sly-unwrap><div d