Using greater than on a daysdiff enrichment | Community
Skip to main content
Level 2
October 2, 2022
Question

Using greater than on a daysdiff enrichment

  • October 2, 2022
  • 0 replies
  • 765 views

hello, im struggling with what i thought was a simple enrichment / segment workflow.

 

I have a daysdiff formula within an enrichment, its generating the output into what looks like a number.

However, i have a segment as the next activity, where I am trying to check if that column is greater than 0 and am getting the below errors - 

 

PGS-220000 PostgreSQL error: ERROR: invalid reference to FROM-clause entry for table "r0" LINE 1: ...ecipient N2 JOIN wkf46377387_61_1 W3 ON (W3.iId = R0.iRecipi...

^ HINT: There is an entry for table "r0", but it cannot be referenced from this part of the query.

 

Any ideas if this is a formatting thing?

Help appreciated!

 

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