You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Insight (OBIEE) Tips: SQL quick tip

Received Response
in Eloqua 7 comments

Recently, I was looking into a blind form submit challenge where anti-malware protections were causing a lot of fake form submits. We wanted to make sure that in form submission data reporting, we were only getting the valid data.

Based on the email recipients and the use case, we decided to only report on the last form submit from a given contact.

OBIEE SQL filter to achieve this:

"Form Data"."User Form Submit ID" = MAX( "Form Data"."User Form Submit ID" By "Contact"."Eloqua Contact ID")


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!