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

[swedenm]

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

[SanfordWhiteman]

Velocity is not used to create Smart Lists — it has no meaning in SL filters. Velocity is only parsed in email content.

[swedenm]

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

[Katja_Keesom]

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?

[swedenm]

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

[Michael_Florin]

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.

[swedenm]

Thanks for this reply 🙂 I think I got what you meant now. Really appreciate all the replies.