id: c30b4f7eae364ee49a2324fe236b5fe1
parent_id: 
item_type: 1
item_id: 69cd708615d64b688f7000ae4ff5cd7c
item_updated_time: 1778000500818
title_diff: "[{\"diffs\":[[1,\"indicators\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":10}]"
body_diff: "[{\"diffs\":[[1,\"      elemTrackingTransition.CreateChildElement(T(\\\"result\\\"), T(\\\"enabled\\\"), T(\\\"true\\\"), T(\\\"name\\\"), T(\\\"result\\\"), T(\\\"target\\\"), T(\\\"union\\\"), NULL);\\\n      CDOMElement elemTrackingSelect = elemTrackingQuery.CreateChildElement(T(\\\"select\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"1\\\"),  T(\\\"alias\\\"), T(\\\"delivery\\\"),             T(\\\"expr\\\"), T(\\\"delivery\\\"), T(\\\"groupBy\\\"), T(\\\"1\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"2\\\"),  T(\\\"alias\\\"), T(\\\"@domain\\\"),              T(\\\"expr\\\"), T(\\\"[broadLog/@domain]\\\"), T(\\\"groupBy\\\"), T(\\\"1\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"3\\\"),  T(\\\"alias\\\"), T(\\\"@amount\\\"),              T(\\\"expr\\\"), T(\\\"SUM(Iif([url/@type] = 5, [webTrackingLog/@amount] , 0))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"4\\\"),  T(\\\"alias\\\"), T(\\\"@article\\\"),             T(\\\"expr\\\"), T(\\\"SUM(Iif([url/@type] = 5, [webTrackingLog/@article] , 0))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"5\\\"),  T(\\\"alias\\\"), T(\\\"@clicked\\\"),             T(\\\"expr\\\"), T(\\\"countdistinct(Iif([@url-id] <> 1, [@broadLog-id], NULL))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"6\\\"),  T(\\\"alias\\\"), T(\\\"@mirrorPage\\\"),          T(\\\"expr\\\"), T(\\\"SUM(Iif([url/@type] = 6, 1 , 0))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"7\\\"),  T(\\\"alias\\\"), T(\\\"@opened\\\"),              T(\\\"expr\\\"), T(\\\"countdistinct(Iif([@url-id] = 1, [@broadLog-id], NULL))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"8\\\"),  T(\\\"alias\\\"), T(\\\"@optOut\\\"),              T(\\\"expr\\\"), T(\\\"SUM(Iif([url/@type] = 3, 1 , 0))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"9\\\"),  T(\\\"alias\\\"), T(\\\"@personClick\\\"),         T(\\\"expr\\\"), T(\\\"countdistinct(Iif([url/@type] = 1, @sourceId, NULL))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"10\\\"), T(\\\"alias\\\"), T(\\\"@recipientClick\\\"),      T(\\\"expr\\\"), T(\\\"countdistinct(Iif([url/@type] = 1, [@broadLog-id], NULL))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"11\\\"), T(\\\"alias\\\"), T(\\\"@recipientOpen\\\"),       T(\\\"expr\\\"), T(\\\"countdistinct([@broadLog-id])\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"12\\\"), T(\\\"alias\\\"), T(\\\"@totalRecipientClick\\\"), T(\\\"expr\\\"), T(\\\"SUM(Iif([url/@type] = 1, 1 , 0))\\\"), NULL);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"13\\\"), T(\\\"alias\\\"), T(\\\"@totalRecipientOpen\\\"),  T(\\\"expr\\\"), T(\\\"SUM(Iif([@url-id] = 1, 1 , 0))\\\"), NULL);\\\n      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);\\\n      elemTrackingSelect.CreateChildElement(T(\\\"node\\\"), T(\\\"id\\\"), T(\\\"15\\\"), T(\\\"alias\\\"), T(\\\"@transaction\\\"),         T(\\\"expr\\\"), T(\\\"SUM(Iif([url/@type] = 5, 1 , 0))\\\"), NULL);\\\n      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);\\\n\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":3140}]"
metadata_diff: {"new":{"source_application":"net.cozic.joplin-desktop","conflict_original_id":"","is_todo":0,"source":"joplin-desktop","user_data":"","master_key_id":"","source_url":"","parent_id":"506175ae6b194ed9965ba43b63a3447a","markup_language":1,"order":0,"share_id":"","latitude":"33.84600000","is_shared":0,"id":"69cd708615d64b688f7000ae4ff5cd7c","todo_due":0,"deleted_time":0,"application_data":"","altitude":"0.0000","todo_completed":0,"longitude":"-118.34560000","author":""},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2026-05-05T17:01:54.818Z
created_time: 2026-05-05T17:01:54.818Z
type_: 13