Expressions du Créateur de Contraintes

La liste suivante contient des expressions spécifiques qui peuvent uniquement être utilisées dans éditeur d’expression manuelle du Créateur de contrainte dans Selligent :

• lookup([SCOPENAME], all/any())
  

  Exemple : lookup([ORDERS],all(eq([CURRENCY], 'euro')),lookup([ORDERLINES],all(gt([QUANTITY], toint('5'))))))
  = Recherche si l’utilisateur détient une commande (commandes dans la liste liée 1:N) avec une devise égale à l’euro et une ligne de commande (lignes de commande dans la liste liée 1:N) dont la quantité est supérieure à 5.

• linkClickedBefore(Journeyid, actionid, linkid, datetime)
  

  Exemple : linkclickedbefore('1000000115','8','101',todatetime('2018-11-28 16:25:12','yyyy-MM-dd HH:mm:ss'))
  

• not(linkClickedBefore(Journeyid, actionid, linkid, datetime))
  

  Example : not(linkclickedbefore('32929','3','0',todatetime('2018-12-04 10:15:57','yyyy-MM-dd HH:mm:ss')))
  

• linkClickedAfter(Journeyid, actionid, linkid, datetime)
  

  Exemple : linkclickedafter('1000000115','8','101',addrelativetonow(0,1,5,10))
  

• not(linkClickedAfter(Journeyid, actionid, linkid, datetime))
  

  Exemple : not(linkclickedafter('32929','3','0',todatetime('2018-12-04 10:16:27','yyyy-MM-dd HH:mm:ss')))
  

• linkClickedBetween(Journeyid, actionid, linkid, datetime, datetime)
  

  Exemple : linkclickedbetween('1000000115','8','101',todatetime('2018-12-25 16:27:00','yyyy-MM-dd HH:mm:ss'),todatetime('2019-01-01 16:27:00','yyyy-MM-dd HH:mm:ss'))

• not(linkClickedBetween(Journeyid, actionid, linkid, datetime, datetime))
  

  Exemple : not(linkclickedbetween('32929','3','0',todatetime('2018-12-04 10:16:43','yyyy-MM-dd HH:mm:ss'),todatetime('2018-12-04 10:16:43','yyyy-MM-dd HH:mm:ss')))

• linkClicked(Journeyid, actionid, linkid)
  

  Exemple : linkclicked('1000000115','8','106')

• not(linkClicked(Journeyid, actionid, linkid))
  

  Exemple : not(linkclicked('32929','3','0'))

• contentClickedBefore(Journeyid, actionid, datetime)
  

  Exemple : contentclickedbefore('1000000115','21',subrelativetotoday(0,3,10,0))

• not(contentClickedBefore(Journeyid, actionid, datetime))
  

  Exemple : not(contentclickedbefore('32929','3',todatetime('2018-12-04 09:54:09','yyyy-MM-dd HH:mm:ss')))

• contentClickedAfter(Journeyid, actionid, datetime)
  

  Exemple : contentclickedafter('1000000115'.'21',todatetime('2018-11-28 16:43:26','yyyy-MM-dd HH:mm:ss'))

• not(contentClickedAfter(Journeyid, actionid, datetime))
  

  Exemple : not(contentclickedafter('32929','3',todatetime('2018-12-04 09:54:09','yyyy-MM-dd HH:mm:ss')))

• contentClickedBetween(Journeyid, actionid, datetime, datetime)
  

  Exemple : contentclickedbetween('1000000115','21',todatetime('2019-01-01 07:00:00','yyyy-MM-dd HH:mm:ss'),todatetime('2019-02-01 00:00:00','yyyy-MM-dd HH:mm:ss'))

• not(contentClickedBetween(Journeyid, actionid, datetime, datetime))
  

  Exemple : not(contentclickedbetween('32929','3',todatetime('2018-12-04 09:59:43','yyyy-MM-dd HH:mm:ss'),todatetime('2018-12-04 09:59:43','yyyy-MM-dd HH:mm:ss')))

• contentClicked(Journeyid, actionid)
  

  Exemple : contentclicked('1000000115','21')

• not(contentClicked(Journeyid, actionid))
  

  Exemple : not(contentclicked('32929','3'))

• contentSentBefore(Journeyid, actionid, datetime)
  

  Exemple : contentsentbefore('1000000115','21',addrelativetotoday(0,7,0,0))

• not(contentSentBefore(Journeyid, actionid, datetime))
  

  Exemple : not(contentsentbefore('32929','3',todatetime('2018-12-04 10:01:30','yyyy-MM-dd HH:mm:ss')))

• contentSentAfter(Journeyid, actionid, datetime)
  

  Exemple : contentsentafter('1000000115','21',todatetime('2017-01-05 00:00:00','yyyy-MM-dd HH:mm:ss'))

• not(contentSentAfter(Journeyid, actionid, datetime))
  

  Exemple : not(contentsentafter('32929','3',todatetime('2018-12-04 10:01:45','yyyy-MM-dd HH:mm:ss')))

• contentSentBetween(Journeyid, actionid, datetime, datetime)
  

  Exemple : contentsentbetween('1000000115','21',subrelativetonow(12,0,0,0),todatetime('2019-01-01 10:30:00','yyyy-MM-dd HH:mm:ss'))

• not(contentSentBetween(Journeyid, actionid, datetime, datetime))
  

  Exemple : not(contentsentbetween('32929','3',todatetime('2018-12-04 10:01:59','yyyy-MM-dd HH:mm:ss'),todatetime('2018-12-04 10:01:59','yyyy-MM-dd HH:mm:ss')))

• contentSent(Journeyid, actionid)
  

  Exemple : contentsent('1000000115','21')

• not(contentSent(Journeyid, actionid))
  

  Exemple : not(contentsent('32929','3'))

• contentViewedBefore(Journeyid, actionid, datetime)
  

  Exemple : contentviewedbefore('1000000115','21',todatetime('2018-06-06 16:54:00','yyyy-MM-dd HH:mm:ss'))

• not(contentViewedBefore(Journeyid, actionid, datetime))
  

  Exemple : not(contentviewedbefore('32929','3',todatetime('2018-12-04 10:03:59','yyyy-MM-dd HH:mm:ss')))

• contentViewedAfter(Journeyid, actionid, datetime)
  

  Exemple : contentviewedafter('1000000115','21',todatetime('2018-12-06 23:55:00','yyyy-MM-dd HH:mm:ss'))

• not(contentViewedAfter(Journeyid, actionid, datetime))
  

  Exemple : not(contentviewedafter('32929','3',todatetime('2018-12-04 10:04:13','yyyy-MM-dd HH:mm:ss')))

• contentViewedBetween(Journeyid, actionid, datetime, datetime)
  

  Exemple : contentviewedbetween('1000000115','21',todatetime('2010-01-01 00:00:00','yyyy-MM-dd HH:mm:ss'),todatetime('2019-01-01 00:00:00','yyyy-MM-dd HH:mm:ss'))

• not(contentViewedBetween(Journeyid, actionid, datetime, datetime))
  

  Exemple : not(contentviewedbetween('32929','3',todatetime('2018-12-04 10:04:27','yyyy-MM-dd HH:mm:ss'),todatetime('2018-12-04 10:04:27','yyyy-MM-dd HH:mm:ss')))

• contentViewed(Journeyid, actionid)
  

  Exemple : contentviewed('1000000115','21')

• not(contentViewed(Journeyid, actionid))
  

  Exemple : not(contentviewed('32929','3'))

• contentDeliveredBefore(Journeyid, actionid, datetime)
  

  Exemple : contentdeliveredbefore('1000000115','21',addrelativetonow(0,0,25,30))

• not(contentDeliveredBefore(Journeyid, actionid, datetime))
  

  Exemple : not(contentdeliveredbefore('32929','3',todatetime('2018-12-04 10:02:47','yyyy-MM-dd HH:mm:ss')))

• contentDeliveredAfter(Journeyid, actionid, datetime)
  

  Exemple : contentdeliveredafter('1000000115','21',todatetime('2018-11-28 17:00:00','yyyy-MM-dd HH:mm:ss'))

• not(contentDeliveredAfter(Journeyid, actionid, datetime))
  

  Exemple : not(contentdeliveredafter('32929','3',todatetime('2018-12-04 10:03:06','yyyy-MM-dd HH:mm:ss')))

• contentDeliveredBetween(Journeyid, actionid, datetime, datetime)
  

  Exemple : contentdeliveredbetween('1000000115','21',subrelativetonow(24,0,0,0),addrelativetonow(11,0,0,0))

• not(contentDeliveredBetween(Journeyid, actionid, datetime, datetime))
  

  Exemple : not(contentdeliveredbetween('32929','3',todatetime('2018-12-04 10:03:22','yyyy-MM-dd HH:mm:ss'),todatetime('2018-12-04 10:03:22','yyyy-MM-dd HH:mm:ss')))

• contentDelivered(Journeyid, actionid)
  

  Exemple : contentdelivered('1000000115','21')
  

• not(contentDelivered(Journeyid, actionid))
  

  Exemple : not(contentdelivered('32929','3'))
  

• datepartisequal(*)
  
  

  Exemple : datepartisequal([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), '')
  

• datepartisnotequal(*)
  

  Exemple : datepartisnotequal([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), 'year')
  

• datepartisbefore(*)
  

  Exemple : datepartisbefore([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), 'month')
  

• datepartisbeforeorequal(*)
  

  Exemple : datepartisbeforeorequal([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), 'day')
  

• datepartisafter(*)
  

  Exemple : datepartisafter([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), 'hour')
  

• datepartisafterorequal(*)
  

  Exemple : datepartisafterorequal([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), 'monthday')
  

• datepartisbetween(*)
  

  Exemple : datepartisbetween([MASTER.BIRTH_DAY],todatetime('2000-01-01 12:13:14', 'yyyy-MM-dd hh:mm:ss'), '')
  

(*) Le dernier paramètre de toutes les expressions datepart doit être l'un des suivants :
- vide (2 guillemets simples) — Une comparaison de date complète
- year
- month
- day
- hour
- monthday

Remarque : Pour prendre en charge des interactions Campaign spécifiques (héritées), on utilise un équivalent des expressions ci-dessus, avec le préfixe 'cpg' (exemple : cpglinkclicked, cpgcontentdeliveredbefore, etc.).

Remarque : La Date/Heure peut être absolue ou relative.

Vous pouvez utiliser les expressions sur les dates-heures/dates relatives de la manière suivante :
- Date/Heure :
subrelativetonow(week, day, hour, minute)
addrelativetonow(week, day, hour, minute)
- Date :
subrelativetotoday(week, day, hour, minute)
addrelativetotoday(week, day, hour, minute)

 

Remarque : Les expressions générales Selligent pouvant être utilisées se trouvent ici.