indicators

      elemTrackingTransition.CreateChildElement(T("result"), T("enabled"), T("true"), T("name"), T("result"), T("target"), T("union"), NULL);
      CDOMElement elemTrackingSelect = elemTrackingQuery.CreateChildElement(T("select"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("1"),  T("alias"), T("delivery"),             T("expr"), T("delivery"), T("groupBy"), T("1"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("2"),  T("alias"), T("@domain"),              T("expr"), T("[broadLog/@domain]"), T("groupBy"), T("1"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("3"),  T("alias"), T("@amount"),              T("expr"), T("SUM(Iif([url/@type] = 5, [webTrackingLog/@amount] , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("4"),  T("alias"), T("@article"),             T("expr"), T("SUM(Iif([url/@type] = 5, [webTrackingLog/@article] , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("5"),  T("alias"), T("@clicked"),             T("expr"), T("countdistinct(Iif([@url-id] <> 1, [@broadLog-id], NULL))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("6"),  T("alias"), T("@mirrorPage"),          T("expr"), T("SUM(Iif([url/@type] = 6, 1 , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("7"),  T("alias"), T("@opened"),              T("expr"), T("countdistinct(Iif([@url-id] = 1, [@broadLog-id], NULL))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("8"),  T("alias"), T("@optOut"),              T("expr"), T("SUM(Iif([url/@type] = 3, 1 , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("9"),  T("alias"), T("@personClick"),         T("expr"), T("countdistinct(Iif([url/@type] = 1, @sourceId, NULL))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("10"), T("alias"), T("@recipientClick"),      T("expr"), T("countdistinct(Iif([url/@type] = 1, [@broadLog-id], NULL))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("11"), T("alias"), T("@recipientOpen"),       T("expr"), T("countdistinct([@broadLog-id])"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("12"), T("alias"), T("@totalRecipientClick"), T("expr"), T("SUM(Iif([url/@type] = 1, 1 , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("13"), T("alias"), T("@totalRecipientOpen"),  T("expr"), T("SUM(Iif([@url-id] = 1, 1 , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("14"), T("alias"), T("@totalWebPage"),        T("expr"), T("SUM(Iif([url/@type] = 4 OR [url/@type] = 5, 1 , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("15"), T("alias"), T("@transaction"),         T("expr"), T("SUM(Iif([url/@type] = 5, 1 , 0))"), NULL);
      elemTrackingSelect.CreateChildElement(T("node"), T("id"), T("16"), T("alias"), T("@webPage"),             T("expr"), T("countdistinct(Iif([url/@type] = 4 OR [url/@type] = 5, [@url-id], NULL))"), NULL);


id: 69cd708615d64b688f7000ae4ff5cd7c
parent_id: 6c159c70dbf04543a71d34def6f1374a
created_time: 2021-09-07T17:34:49.260Z
updated_time: 2026-05-05T17:01:40.819Z
is_conflict: 0
latitude: 33.84600000
longitude: -118.34560000
altitude: 0.0000
author: 
source_url: 
is_todo: 0
todo_due: 0
todo_completed: 0
source: joplin-desktop
source_application: net.cozic.joplin-desktop
application_data: 
order: 0
user_created_time: 2021-09-07T17:34:49.260Z
user_updated_time: 2021-09-07T17:34:57.035Z
encryption_cipher_text: 
encryption_applied: 0
markup_language: 1
is_shared: 0
share_id: 
conflict_original_id: 
master_key_id: 
user_data: 
deleted_time: 0
type_: 1