Created
December 29, 2021 05:18
-
-
Save hmboyd/f178816cad11cf9cc4732e6e30d1486b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ON TRIGGER ( | |
NOT behavior.[Close session] | |
AND session(parameter.[Page URL] LIKE '%uclahealth.org/FORMURL%') | |
AND NOT session(parameter.[Page URL] LIKE '%uclahealth.org/THANKYOUURL%') | |
) | |
SELECT | |
Latest(parameter.[Page URL]) FILTER ( | |
WHERE | |
parameter.[Page URL] LIKE '%uclahealth.org/FORMURL%' | |
) | |
WHERE | |
NOT parameter.[Page URL] LIKE '%uclahealth.org/FORMURL%' | |
AND NOT parameter.[Page URL] LIKE '%uclahealth.org/THANKYOUURL%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ON TRIGGER ( | |
NOT behavior.[Close session] | |
AND parameter.[Page URL] LIKE '%uclahealth.org/THANKYOUURL%' | |
) | |
SELECT | |
parameter.[Page URL] | |
WHERE | |
parameter.[Page URL] LIKE '%uclahealth.org/THANKYOUURL%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ON TRIGGER ( | |
NOT behavior.[Close session] | |
AND behavior.[View Page].[Page URL] LIKE '%uclahealth.org/FORMURL%' | |
AND NOT behavior.[View Page].[Page URL] LIKE '%uclahealth.org/THANKYOUURL%' | |
) | |
SELECT | |
Latest(parameter.[Page URL]) FILTER ( | |
WHERE | |
parameter.[Page URL] LIKE '%uclahealth.org/FORMURL%' | |
) | |
WHERE | |
NOT parameter.[Page URL] LIKE '%uclahealth.org/FORMURL%' | |
AND NOT parameter.[Page URL] LIKE '%uclahealth.org/THANKYOUURL%' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment