Commit graph

178 commits

Author SHA1 Message Date
Taha Yassine Kraiem
64242a5dc0 refactor(DB): changed supported platforms in CH 2025-05-26 11:51:49 +02:00
Taha Yassine Kraiem
d78b33dcd2 refactor(DB): remove TTL for CH tables 2025-05-05 16:49:37 +02:00
Taha Yassine Kraiem
033ffcb7b9 refactor(DB): changed product_analytics.events to expose error_id
fix(chalice): fixed search events by error
2025-03-14 14:32:17 +01:00
Taha Yassine Kraiem
b0f3c50c0f refactor(DB): DB changes 2025-03-14 10:53:09 +01:00
Taha Yassine Kraiem
45b8bdef8a fix(DB): fixed old-product-analytics wrong view_type 2025-03-11 13:13:39 +01:00
Shekar Siri
1efe5c87e8 change(db): ee related init schema updated for notes 2025-02-28 15:21:53 +01:00
Kraiem Taha Yassine
3a331d266c
Dev (#3052)
* fix(chalice): support wrong payload for user-journey drill-down

* fix(chalice): ignore event's MV for v1.22
refactor(DB): ignore event's MV for v1.22
2025-02-21 12:56:05 +01:00
Kraiem Taha Yassine
3ed8b3c27d
Dev (#3041)
* refactor(chalice): refactored code

* refactor(DB): changed delta

* refactor(chalice): product analytics log refactoring
2025-02-18 16:37:37 +01:00
Kraiem Taha Yassine
6579b6842b
Dev (#3023)
* fix(chalice): removed support for all type: webVitals/errors/performance/resources predefined card because UI is not showing them anymore

* refactor(chalice): changed all charts CH queries
2025-02-11 15:11:55 +01:00
Kraiem Taha Yassine
b09becdcb7
Dev (#3022)
* refactor(chalice): refactored code

* refactor(chalice): removed support for domainsErrors4xx & domainsErrors5xx predefined cards because UI is not showing them anymore
refactor(chalice): removed support of processed_sessions & count_requests predefined cards because UI is not showing them anymore

* fix(chalice): fixed table of errors CH

* fix(chalice): removed support for errorsPerDomains & errorsPerType predefined cards because UI is not showing them anymore

* fix(chalice): removed support for speedLocation predefined card because UI is not showing it anymore
2025-02-11 13:54:47 +01:00
Shekar Siri
3191843829 change(ui): highlights messages to be nullable 2025-02-10 12:21:31 +01:00
Kraiem Taha Yassine
c2ce9b8466
Dev (#2988)
* fix(chalice): changed new user-journey to return identical response to the old user-journey

* fix(chalice): fixed boarding

* refactor(chalice): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(alerts): upgraded dependencies

* feat(DB): product analytics schema for CH
2025-01-30 13:39:18 +01:00
Shekar Siri
3038fe58d0 fix(ui): default settings values for existing users 2025-01-28 12:51:16 +01:00
Kraiem Taha Yassine
82ab91bc25
Dev (#2906)
* refactor(chalice): removed errors status
refactor(chalice): removed errors viewed
refactor(chalice): removed errors favorite
refactor(DB): removed errors viewed
refactor(DB): removed errors favorite

* refactor(chalice): ignore hide excess for Path Finder as it will be done in UI
2024-12-23 18:34:57 +01:00
Kraiem Taha Yassine
2f693cd490
Dev (#2819)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(chalice): removed sessions insights
refactor(DB): removed sessions insights

* refactor(chalice): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(alerts): upgraded dependencies
feat(chalice): moved CH to FOSS
feat(chalice): use clickhouse-connect
feat(chalice): use CH connexion pool
feat(scripts): defined ch-data-port
2024-12-05 17:43:52 +01:00
Kraiem Taha Yassine
5180ad8717
Dev (#2816)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): preparing for v1.22.0
refactor(chalice): upgraded dependencies
refactor(alerts): upgraded dependencies
refactor(crons): upgraded dependencies

* refactor(chalice): removed sessions insights
2024-12-05 09:40:00 +01:00
Kraiem Taha Yassine
27f1027ad2
Dev (#2764)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* fix(DB): support previous DB upgrade
2024-11-19 18:14:06 +01:00
Kraiem Taha Yassine
7eeb71ed25
Dev (#2761)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): allow CH drop of massive tables
2024-11-19 11:38:59 +01:00
Kraiem Taha Yassine
c88bd374e9
Dev (#2738)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): changed the list of integration providers

* refactor(chalice): enable exp funnels by default

* refactor(chalice): removed issues list of pathAnalysis card

* refactor(chalice): removed unused code
2024-11-13 12:16:00 +01:00
Kraiem Taha Yassine
32813bea1b
Dev (#2724)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* fix(chalice): fixed path-analysis issues list
fix(chalice): fixed funnel empty sessions
refactor(DB): EE changes
2024-11-05 15:10:41 +01:00
Kraiem Taha Yassine
d2697061e9
Dev (#2722)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): changed dashboard&metrics constraints

* refactor(chalice): removed cards
refactor(chalice): removed code related to resources
refactor(DB): removed cards
refactor(DB): removed code related to resources
2024-11-04 17:57:14 +01:00
Kraiem Taha Yassine
eaf762e1bd
Dev (#2719)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): added web_vitals to pages table

* refactor(DB): added session_integrations table
2024-10-31 16:23:52 +01:00
Kraiem Taha Yassine
d8642808d7
Dev (#2712)
* refactor(chalice): upgraded dependencies
refactor(alerts): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(DB): v1.21.0 DB changes
2024-10-30 11:13:59 +01:00
Kraiem Taha Yassine
796018eb57 fix(chalice): fixed permissions for EE SA (#2685)
(cherry picked from commit 6802ddcd93)
2024-10-25 16:46:24 +02:00
Kraiem Taha Yassine
2253ac394d
Dev (#2562)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* fix(chalice): fixed table of fetch-users for EE

* fix(chalice): foss vs saas response discrepancy for table of referrers

* fix(DB): fixed scope_state delta
2024-09-11 18:12:41 +02:00
Alexander
840f133f73
SQL for Spot feature (#2513)
* feat(spot): added sql for spot feature

* feat(spot): added sql code to all related files

* feat(spot): added default value for created_at

* feat(spot): added spots schema

* feat(spot): applied a new spots schema to all sql requests
2024-09-05 15:57:39 +02:00
Kraiem Taha Yassine
966f08e95d
Dev (#2531)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): rollback script
feat(DB): changed users.settings default value
2024-09-03 15:18:27 +02:00
Kraiem Taha Yassine
cbf389f6f9
Dev (#2526)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(chalice): changed scope to scopeState with 0|1|2 values
2024-09-02 18:05:22 +02:00
Kraiem Taha Yassine
90d37f74d2
Dev (#2524)
* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* fix(DB): fixed init schema
dev(DB): script to run init schema against dev servers
2024-09-02 14:26:17 +02:00
Kraiem Taha Yassine
8c54a74f04
Dev (#2473)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(alerts): upgraded dependencies

* feat(chalice): get top 10 values for autocomplete CH

* refactor(chalice): cleaned code
refactor(chalice): upgraded dependencies
refactor(alerts): upgraded dependencies
refactor(crons): upgraded dependencies

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* refactor(DB): enhanced top-events caching

* feat(DB): support OR scope
feat(chalice): support OR scope
2024-08-08 17:15:51 +02:00
Kraiem Taha Yassine
6f0794b196
Dev (#2469)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(alerts): upgraded dependencies

* feat(chalice): get top 10 values for autocomplete CH

* refactor(chalice): cleaned code
refactor(chalice): upgraded dependencies
refactor(alerts): upgraded dependencies
refactor(crons): upgraded dependencies

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* feat(chalice): cache autocomplete-top-10 responses
feat(DB): support Spot login

* fix(chalice): fixed Spot new refresh token
2024-08-07 13:42:15 +02:00
Kraiem Taha Yassine
f01a98c619
Dev (#2446)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(alerts): upgraded dependencies

* feat(chalice): get top 10 values for autocomplete CH

* refactor(chalice): cleaned code
refactor(chalice): upgraded dependencies
refactor(alerts): upgraded dependencies
refactor(crons): upgraded dependencies

* feat(chalice): autocomplete return top 10 with stats

* fix(chalice): fixed autocomplete top 10 meta-filters

* feat(chalice): support spot for EE
2024-07-31 14:34:06 +02:00
Kraiem Taha Yassine
8dc09ca691
Dev (#2419)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): refactored search sessions hooks

* refactor(chalice): refactored schemas

* refactor(chalice): refactored schemas
refactor(chalice): cleaned scripts
feat(chalice): search sessions by CSS selector (PG)

* refactor(chalice): upgraded dependencies
refactor(crons): upgraded dependencies
refactor(alerts): upgraded dependencies

* feat(chalice): search by selectors

* feat(chalice): support Spot permissions
feat(DB): support Spot permissions
2024-07-23 16:00:26 +02:00
Kraiem Taha Yassine
dd5ff6bad8
Dev (#2409)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): refactored search sessions hooks

* refactor(DB): DB delta

* refactor(DB): DB delta

* refactor(DB): DB delta

* refactor(chalice): refactored schemas

* refactor(chalice): refactored schemas
refactor(chalice): cleaned scripts
feat(chalice): search sessions by CSS selector (PG)
2024-07-18 17:57:37 +02:00
Kraiem Taha Yassine
3652f76c75 Patch/api v1.19.0 (#2392)
* fix(chalice): reversed count&total for card-tables to confuse devs

* fix(DB): changed normalized_x&y col-type

(cherry picked from commit c845415e1e)
2024-07-16 17:16:27 +02:00
Taha Yassine Kraiem
3dfacb47bf fix(DB): permissions changes
fix(chalice): permissions changes
2024-07-04 16:09:17 +02:00
Taha Yassine Kraiem
55bb721a64 refactor(DB): changes 2024-07-04 14:52:34 +02:00
Taha Yassine Kraiem
b99e97cd5b fix(chalice): changed s-permissions
fix(DB): changed s-permissions
2024-07-04 14:27:32 +02:00
Taha Yassine Kraiem
2ff0d164fb fix(chalice): changed s-permissions
fix(DB): changed s-permissions

(cherry picked from commit 389ec4a8fc)
2024-07-04 14:26:59 +02:00
Kraiem Taha Yassine
a2e9f2b165
Dev (#2347)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(DB): fixed exp-sessions_mv
2024-07-03 13:01:22 +02:00
Kraiem Taha Yassine
8aaec08cb1
Dev (#2341)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): completely remove clickMap cards
refactor(DB): completely transform clickMap to HeatMap
2024-07-02 17:49:50 +02:00
Kraiem Taha Yassine
0e42041aa8
Dev (#2336)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* fix(DB): replaced click's x&y with normalized_x&normalized_y
fix(chalice): fixed heatmaps-clicks-path
refactor(DB): DB upgrade & downgrade scripts
2024-07-02 14:49:12 +02:00
Kraiem Taha Yassine
9516dcd238
Dev (#2333)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps

* refactor(chalice): removed timeseries-card progress
refactor(chalice): removed tables-card pieChart
refactor(DB): migrated timeseries-card progress
refactor(DB): migrated tables-card pieChart
2024-07-02 11:53:47 +02:00
Kraiem Taha Yassine
11c4d9e114
Dev (#2331)
* refactor(chalice): upgraded dependencies

* refactor(chalice): upgraded dependencies
feat(chalice): support heatmaps

* feat(chalice): support table-of-browsers showing user-count

* feat(chalice): support table-of-devices showing user-count

* feat(chalice): support table-of-URLs showing user-count

* refactor(DB): update webVital UI configuration

* fix(chalice): fixed Math-operators validation
refactor(chalice): search for sessions that have events for heatmaps

* refactor(chalice): search for sessions that have at least 1 location event for heatmaps
2024-07-01 17:46:45 +02:00
Kraiem Taha Yassine
5574519775
V1.19.0 (#2260)
* refactor(DB): support of normalizedX&Y for click events

* refactor(chalice): upgraded dependencies
refactor(chalice): support heatmaps
2024-06-10 15:54:29 +02:00
Kraiem Taha Yassine
62a3078c22
refactor(DB): change url_path to column instead of materialized column (#2202) 2024-05-24 16:02:16 +02:00
Kraiem Taha Yassine
43854675bd
refactor(DB): added more indexes (#2173) 2024-05-06 18:06:55 +02:00
Kraiem Taha Yassine
b789496a3a
fix(DB): added missing user_device_type (#2143) 2024-04-26 13:43:22 +02:00
Kraiem Taha Yassine
e4c120ba60
feat(DB): added screen_width & screen_height (#2054) 2024-04-08 11:41:17 +02:00
Kraiem Taha Yassine
902ec87d7a
fix(DB): allow null session_id for assist_records(session_id) (#1965) 2024-03-17 15:07:23 +01:00