I am doing a Smart List where I need to show an item ordered last 2 months with status is SHIPPED | Community
Skip to main content
New Participant
April 22, 2021
Question

I am doing a Smart List where I need to show an item ordered last 2 months with status is SHIPPED

  • April 22, 2021
  • 2 replies
  • 2635 views

Hi guys,

 

I would like to ask for your help if you have known any velocity script wherein I can use to create a smartlist where the customer ordered an item/s for last 2 months and the status of that order is shipped.

 

Thanks in advance,

Sweden

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Katja_Keesom
Community Manager
April 22, 2021

Hi Sweden,

Sanford is absolutely correct. Can you give us a bit more information on how that information is stored in your Marketo instance? How you can set up your smart list depends on what your data looks like. Are your orders stored in a Custom Object or Custom Activity?

 

swedenmAuthor
New Participant
April 29, 2021

The data I am looking at is under the Custom Object -> Job Item

 

 

Michael_Florin-2
New Participant
April 29, 2021

The filter is called "Has Job Item". And on that filter you can put constraints like "Status = shipped" and "Order Date is in past two months".

 

Looks something like this for one of our Custom Objects:

 

 

Any field on your Custom Object is available as a filter constraint.

SanfordWhiteman
New Participant
April 22, 2021
Velocity is not used to create Smart Lists — it has no meaning in SL filters. Velocity is only parsed in email content.
swedenmAuthor
New Participant
April 29, 2021

Make sense. However upon looking for a filter that I can use for the Job item status I cannot find one so I though it will need a velocity for that filter to work.

 

Regards,

Sweden