Fields source parameter accepts value1, value2,...,value10.\r\n Extra calculations can be made eg. value1,value2,value1-value2.\r\n Fields target value1,value2,value3","shortMessageHtmlLink":"Update A_SP_FC_REG.sql"}},{"before":"e93676fed61b4ae126662c95b50584822160cfa7","after":"87af6b29d012b82731218d8a7ea571c15b408663","ref":"refs/heads/main","pushedAt":"2024-03-01T16:11:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_IMPORT.sql\n\n-- VERSION 20240301
\r\n\t-- @p parameter accepts additional parameters in json format
\r\n\t-- 1. date_import_from
\r\n\t-- 2. date_import_until
\r\n\t-- 3. source_import_id_field
\r\n\t-- 4. intraday_duration
\r\n\t-- Example: exec [dbo].[A_SP_IMPORT] @site_id=1, @procedure_name=''SUM_DAY_VIEW'', @commands=''-NO_SCHEDULE -OUTPUT'',@p=''{\"date_import_from\":\"2023-01-01\"}''
","shortMessageHtmlLink":"Update A_SP_IMPORT.sql"}},{"before":"519707fbad5271b447bc019fa15592f4bdc1e9b5","after":"e93676fed61b4ae126662c95b50584822160cfa7","ref":"refs/heads/main","pushedAt":"2024-02-02T08:47:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_APP_ACTIVITY_DUPLICATE_LIST.sql\n\nprocedure to duplicated activities from list of ids, including duplication of the related imports.","shortMessageHtmlLink":"Create A_SP_APP_ACTIVITY_DUPLICATE_LIST.sql"}},{"before":"9e379ad5761ade740581a02581c74d77a36d38d4","after":"519707fbad5271b447bc019fa15592f4bdc1e9b5","ref":"refs/heads/main","pushedAt":"2023-12-29T13:25:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_FC_REG_SIMPLE.sql","shortMessageHtmlLink":"Update A_SP_FC_REG_SIMPLE.sql"}},{"before":"af81324608456ceaa1cafc0d466c6574268ddc52","after":"9e379ad5761ade740581a02581c74d77a36d38d4","ref":"refs/heads/main","pushedAt":"2023-12-18T14:06:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_FC_REG_SIMPLE.sql\n\nisnull removed; improved filtering\r\nsmall fixes","shortMessageHtmlLink":"Update A_SP_FC_REG_SIMPLE.sql"}},{"before":"a5c3a651cfdffe9201b8269b63142f1b00e741dd","after":"af81324608456ceaa1cafc0d466c6574268ddc52","ref":"refs/heads/main","pushedAt":"2023-11-28T18:03:35.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Merge pull request #13 from maximnl/maximnl-patch-4\n\nCreate A_SP_FC_REG_SIMPLE.sql","shortMessageHtmlLink":"Merge pull request #13 from maximnl/maximnl-patch-4"}},{"before":null,"after":"7430a426dc2918fe706d8a95782af5ef0e5ad22b","ref":"refs/heads/maximnl-patch-4","pushedAt":"2023-11-28T18:02:51.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_FC_REG_SIMPLE.sql\n\nreg model simplified for lags parameters","shortMessageHtmlLink":"Create A_SP_FC_REG_SIMPLE.sql"}},{"before":"5fbb30e4c0e9b70c9157aceceb0e33d8e40f5107","after":"a5c3a651cfdffe9201b8269b63142f1b00e741dd","ref":"refs/heads/main","pushedAt":"2023-11-16T11:56:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_IMPORT_RUN.sql\n\n-- version 20231116 date_import_from/until with time stamp fix (extra date conversions were added)","shortMessageHtmlLink":"Update A_IMPORT_RUN.sql"}},{"before":"270c50b4e22d95d5a00d399f78f9e5b809d706ea","after":"5fbb30e4c0e9b70c9157aceceb0e33d8e40f5107","ref":"refs/heads/main","pushedAt":"2023-08-28T11:36:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_FC_REG.md","shortMessageHtmlLink":"Create A_SP_FC_REG.md"}},{"before":"5947c43a98e0cb5db716d9ef0ea357054ceca9fd","after":"270c50b4e22d95d5a00d399f78f9e5b809d706ea","ref":"refs/heads/main","pushedAt":"2023-08-28T11:15:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_FC_REG.sql","shortMessageHtmlLink":"Create A_SP_FC_REG.sql"}},{"before":"59e9d9e1b3e3b24a3a7362e22fe76220ba378600","after":"5947c43a98e0cb5db716d9ef0ea357054ceca9fd","ref":"refs/heads/main","pushedAt":"2023-08-25T10:39:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_DIM_ACTIVITY.md","shortMessageHtmlLink":"Update A_DIM_ACTIVITY.md"}},{"before":"6b9eefd196910dd3c62df993ff665da4d782f7ff","after":"59e9d9e1b3e3b24a3a7362e22fe76220ba378600","ref":"refs/heads/main","pushedAt":"2023-08-25T10:34:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_DIM_ACTIVITY.md","shortMessageHtmlLink":"Create A_DIM_ACTIVITY.md"}},{"before":null,"after":"657416151ad54077d35f4199276e6be95334612d","ref":"refs/heads/maximnl-patch-3","pushedAt":"2023-08-25T10:31:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create a_dim_activity.md","shortMessageHtmlLink":"Create a_dim_activity.md"}},{"before":"b01e1b6199db4f6cb2ab2f11af2ab9cdc8272312","after":"6b9eefd196910dd3c62df993ff665da4d782f7ff","ref":"refs/heads/main","pushedAt":"2023-08-23T10:56:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_FC_REG.sql","shortMessageHtmlLink":"Create A_SP_FC_REG.sql"}},{"before":"ee371f326a59d43d8b6b0be73a943163f48a06de","after":"b01e1b6199db4f6cb2ab2f11af2ab9cdc8272312","ref":"refs/heads/main","pushedAt":"2023-07-05T09:18:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_ALERT.sql\n\nlog of procedure_name by end fix","shortMessageHtmlLink":"Update A_SP_ALERT.sql"}},{"before":"b77eb0f2404c1cde7d54d2fada280e7641c6a6ed","after":"ee371f326a59d43d8b6b0be73a943163f48a06de","ref":"refs/heads/main","pushedAt":"2023-06-23T08:19:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_IMPORT.sql","shortMessageHtmlLink":"Update A_SP_IMPORT.sql"}},{"before":"f2b0f58c74f8165aa4d07452972f9565fc067d32","after":"b77eb0f2404c1cde7d54d2fada280e7641c6a6ed","ref":"refs/heads/main","pushedAt":"2023-06-01T14:27:28.432Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_ALERT.sql","shortMessageHtmlLink":"Update A_SP_ALERT.sql"}},{"before":"ac0b1e0c80b84f970b0ed8e13254aaab66987816","after":"f2b0f58c74f8165aa4d07452972f9565fc067d32","ref":"refs/heads/main","pushedAt":"2023-06-01T14:22:08.283Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_ALERT.sql\n\nfix for case when non working in sql on premise","shortMessageHtmlLink":"Update A_SP_ALERT.sql"}},{"before":"6796e4d3343223a2d416eabc0931586e58daeb04","after":"ac0b1e0c80b84f970b0ed8e13254aaab66987816","ref":"refs/heads/main","pushedAt":"2023-05-19T15:25:42.531Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_ALERT.sql\n\nauto filter activity_id current on benchmark source","shortMessageHtmlLink":"Update A_SP_ALERT.sql"}},{"before":"c7161bdfc9d954613156bd2834ff8ca3e56cfdc3","after":"6796e4d3343223a2d416eabc0931586e58daeb04","ref":"refs/heads/main","pushedAt":"2023-05-17T19:32:44.477Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_IMPORT_RUN.sql","shortMessageHtmlLink":"Update A_IMPORT_RUN.sql"}},{"before":"13acea059a2adc2362ea8e07ed2eb87d7498c280","after":"c7161bdfc9d954613156bd2834ff8ca3e56cfdc3","ref":"refs/heads/main","pushedAt":"2023-05-17T18:33:25.003Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_ALERT.sql\n\ninitial","shortMessageHtmlLink":"Create A_SP_ALERT.sql"}},{"before":null,"after":"7d060fe4e9eca6c9f3fa08ef92d038ec76ca0db3","ref":"refs/heads/maximnl-patch-2","pushedAt":"2023-05-12T13:31:48.461Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Create A_SP_ALERT.sql","shortMessageHtmlLink":"Create A_SP_ALERT.sql"}},{"before":null,"after":"57a8bf82fb2a6e9b39726e8784f1a210f3ad48b4","ref":"refs/heads/maximnl-patch-1","pushedAt":"2023-04-03T09:21:57.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update configuration.md\n\nImport dates description added","shortMessageHtmlLink":"Update configuration.md"}},{"before":"c02e443416ffab566e3a180df43b97052dc5e4ee","after":"13acea059a2adc2362ea8e07ed2eb87d7498c280","ref":"refs/heads/main","pushedAt":"2023-04-03T08:46:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_IMPORT_RUN.sql\n\n-- version 20230403\r\n-- improved date_import_from / until calculations with aligned priority\r\n-- import.import_date_from -> import.days_back -> procedure.import_date_from -> procedure.days_back\r\n-- idem for the forward date calculations","shortMessageHtmlLink":"Update A_IMPORT_RUN.sql"}},{"before":"24f39f8ca3eb639ef6b5c3de19af38828beb1e50","after":"c02e443416ffab566e3a180df43b97052dc5e4ee","ref":"refs/heads/main","pushedAt":"2023-03-18T10:05:13.989Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_IMPORT_RUN.sql\n\nactivity slicer fields added","shortMessageHtmlLink":"Update A_IMPORT_RUN.sql"}},{"before":"fd7dd9617ee6eb0633e18231b3c2ff5c083cbec7","after":"24f39f8ca3eb639ef6b5c3de19af38828beb1e50","ref":"refs/heads/main","pushedAt":"2023-03-18T10:01:06.978Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_FC_CORRELATION.sql\n\n-- VERSION 20230315
\r\n -- logging improved, snippets design
","shortMessageHtmlLink":"Update A_SP_FC_CORRELATION.sql"}},{"before":"599bd40c949f89f44b8a9fbf8705e0deff87ea0a","after":"fd7dd9617ee6eb0633e18231b3c2ff5c083cbec7","ref":"refs/heads/main","pushedAt":"2023-03-18T10:00:05.062Z","pushType":"push","commitsCount":1,"pusher":{"login":"maximnl","name":"Maxim Ivashkov","path":"/maximnl","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/33482502?s=80&v=4"},"commit":{"message":"Update A_SP_FC_PARALLEL.sql\n\n