Discussions

Insight (OBIEE) Tips: SQL quick tip

Otilia Antipa-Oracle
Otilia Antipa-Oracle Product ManagerPosts: 91 Employee
edited May 6, 2022 2:33PM in Eloqua

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")

Got any SQL tips for Insight users?

Post edited by JodyMooney-Oracle on

Comments