Using greater than on a daysdiff enrichment | Adobe Higher Education
Skip to main content
Level 2
October 2, 2022
質問

Using greater than on a daysdiff enrichment

  • October 2, 2022
  • 0 の返信
  • 765 ビュー

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!

 

このトピックへの返信は締め切られました。