This is my first post here so please accept my apologies in advance if anything is out of place. I have table "Users", for each user there is a statement about whether he participates in promotions "IsParticipates", this is one…
db.inventory.aggregate( [ { $lookup: { from: "order", localField: "_id", foreignField: "item_id", as: "inventory_docs" } } ] ) The $lookup is joining based on the item_id field, which is indexed. If 100,000 documents pass through this $lookup, it increased the query…
I'm trying to add even more key : value data to existing json data. I get data from postgres with a query to the field and get a dictionary. After that, I simply add an additional key-value pair to the…
I have an Attendance record having fields employee code, status, attendance_date. I want to fetch those employee record who are on leave continuously for 11 days using Sql query The condition here is if employee attendance status is continuously leave…
I have a large query with the below WHERE clause that I'm hoping may be written in a cleaner / possible more efficient way. Each combination is specific and needs to be accounted for. EDIT Per the first comment i…
My system consists of Database (Timescale Db) and table telemetry_aggregations .Net Worker nodes (1...n) Every couple minutes, telemetry_aggregations table gets updated with couple hundreds of new rows. How system should work Every node periodically requests new batch of data (SQL…
I have 2 tables with flex one-to-many relationship, meaning the parent side may not have any child: Parent_table id dim1 quantity price 1 "abc" 1 1.00 child_table: id parent_id 1 1 2 1 The parent query is very straight forward:…
Context I have this table: Time Metric A Metric B Value A A A 1 A A B 2 A A C 1 B A A 1 B A B 2 B A C 1 I want to get the…
I have Database table called tbl_emails like this id email 1 [email protected] 2 [email protected] 3 [email protected] 4 [email protected] 5 [email protected] 6 [email protected] 7 [email protected] 8 [email protected] 9 [email protected] 10 [email protected] I have about 5000 rows in the table. Now What…
I have 2 tables. A Users table and a Token table. I am trying to join these tables to see who has verified their tokens and who hasn't. The token table has a foreign key with the user id in…