Pivot Output Field Not Recognized In Rule Actions

  • 1
  • Problem
  • Updated 4 months ago
  • Acknowledged
Excuse the long post :) 

I used a pivot task on a dataset in bionic rules, pivoting on the field "Product Purchased" and outputting a date from the field Go Live Implementation:

I then confirmed that the results of this task are a list of dates for the go live of each product:

I therefore want to use this date field (12/12/1999 is just a default placeholder for time being) as a criteria to trigger a CTA but the field isn't being recognized as a date field, but rather as the values associated with the Product Purchased field that I had pivoted on:

I confirmed that the rule action is using the appropriate task output (called Merge 6):

Am I missing something here?  Am I unable to use the results of the pivot as criteria in my rule action?
Photo of Kate Green

Kate Green, Champion

  • 5,782 Points 5k badge 2x thumb

Posted 4 months ago

  • 1
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 3,254 Points 3k badge 2x thumb
Hi Kate,

When I tried creating a similar rule in my test org, I was able to see date filters. Please see the attached screenshot. 
Can you share the source object name and also check the data type of the field "Go Live Implementation..."?  I suspect the data type is other than Date.

Photo of Kate Green

Kate Green, Champion

  • 5,730 Points 5k badge 2x thumb
Hi Jitin - thanks for your response.  The source of the data set is an SFDC custom object called "Products and Services Purchased" and I have confirmed that this is a date field:

What's strange is that the output that I exported to S3 does contain Date values in the fields.  It's just in the action criteria that it's not being recognized.
Photo of Kate Green

Kate Green, Champion

  • 5,730 Points 5k badge 2x thumb
Hi Jitin - can you think of any ideas here?  I have followed up with support but haven't heard anything back.
Photo of Cameron Wright

Cameron Wright, Employee

  • 3,174 Points 3k badge 2x thumb
Hey Kate, I am escalating the ticket internally so we can get some answers here. Sorry for the delay. 
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 12,426 Points 10k badge 2x thumb
Hi Kate, Sorry for the inconvenience, there is no workaround for this issue. Our engineering team has accepted this as bug,will update you here once this is fixed.

Thanks for bringing this.