I'm trying to run the following query, which unless I'm misunderstanding the documentation looks as like it should be possible. SELECT id, profile FROM end_user WHERE profile @? '$.first_segment_exited_at ? (@.datetime() < "2023-05-25".datetime())'::jsonpath; This is the documentation which leads me…
I have a requirement. I need to take count of same tables from two different schema. The required output should be like (see screenshot here) schema table_name count sch1 table1 1000 sch2 table1 500 sch1 table2 3000 sch2 table2 1000…
I have a table with a collection of parts. These parts have an id and a serial number provided by the manufacturer. Parts are put together to build an assembly and the order which the parts are assembled matters. When…
I'm very new to qlik sense - I have some database experience. A team mate of mine recently quit who was the main owner of this piece of code. num(sum({1<[report_date] = {"=$(=(date((currDate))))"}> +1<[report_date]={"=$(date(currDate) - 7)"}> +1<[report_date]={"=$(date(currDate) - 30)"}> } anomoly_count…
I am currently on a project based around react in the frontend, django in the backend, postgresql for the database and nginx for the reverse proxy. Everything is linked up with a Docker-compose file. Right now, I try to link…
updated I have the following table of updates which you will note contains nulls refer event_date col1 col2 col3 cat 2 today null null bbb a 2 yesterday null null null b 2 yesterday null xyz null b 2 last…
I have a table: user_id type date 1 prime 2022-05-31 1 usual 2022-06-30 1 usual 2022-07-31 1 usual 2022-09-31 I need to get a table grouped by user_id and type and validity period. The main difficulty is that the periods…
I have the following table: CREATE TABLE trajectory( user_id int, session_id int, timestamp timestamp with time zone, lat double precision, lon double precision ); INSERT INTO trajectory(user_id, session_id, timestamp, lat, lon) VALUES (1, 25304,'2008-10-23 02:53:04+01', 39.984702, 116.318417), (1, 25304, '2008-10-23…
I want to insert data in case the 'id' doesn't exist, and update it if the 'id' does exist AND the existing 'timestamp' is less than the new 'timestamp'. So far I haven't figured out how to add this condition…
How to reorder a PostgreSQL table based on a column, when inserting, updating, or deleting a row? Say I have a table questions, and I have a column called questionOrder (an integer), which sets the order of the questions. If…