Questions tagged [responsys]
37 questions
0
votes
2 answers
freemarker if statement sequencing
I'm trying to write an #if statement with a sequence of numbers. Basically, if a certain field matches any of a subset of numbers (shown below with || or operators) then assign it as "bayarea", elseif a different subset, then a different name, etc.…
Kera Mogilevsky
- 1
- 1
0
votes
1 answer
Oracle Responsys RPL: How to skip sending an email if items have been deleted from table
I have the following RPL code in an email:
<#data ALERTS as alerts>
<#filter USER_ID1=CONTACTS_LIST.CUSTOMER_ID_1>
<#fields AD_ID_LIST1>
<#assign cellCount = 0>
<#list alerts.AD_ID_LIST1?split(r'\s*,\s*', 'r') as idString>
<#data AD_TABLE as…
XD4
- 103
- 1
- 2
- 11
0
votes
2 answers
PhantomJS -headless browseer
I have to automate a test case in which a list in a particular dashboard is created. We decided to use PhantomJS headless browser. Since I am new to it, I tried creating test myself. Following are the steps I followed just to open the target…
Shilpa
- 103
- 1
- 9
0
votes
1 answer
Responsys - How to field merge multiple rows on one column using RPL?
Basically, I need to field merge a field in a certain table. Let's say TableA.Col1.
The syntax ${TableA.Col1} works perfectly. However, it only shows the first row of data in the table, whereas, I need to field merge the second row of the data as…
thebeast22
- 103
- 3
- 11
0
votes
2 answers
Grab abandoned carters from the last hour in Oracle Responsys
I'm trying to grab people out of a table who have an abandon date between 20 minutes ago and 2 hours ago. This seems to grab the right amount of time, but is all 4 hours old:
SELECT *
FROM $A$
WHERE ABANDONDATE >= SYSDATE - INTERVAL '2' HOUR
…
AndyD
- 1
- 1
0
votes
1 answer
Oracle Responsys Syntax for date calculation
I have a hard time working with Oracle Responsys, Im trying to put a condition of less than 3 years from today-workdate, I have a timestamp called workdate
select * from $A$ where…
Sailormoon
- 259
- 1
- 5
- 23
-1
votes
2 answers
Can I sum the count of two columns from two different tables?
I'm trying to add together the counts of two different tables and group them by the same variable
Here is what I have so far:
SELECT a.storenumber,
Count (howmanytotal) AS total_counts_store
FROM (
SELECT…
Sarah Harrison
- 1
- 1