I'm trying to transform my table to JSON My table: DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp(AnalyticGoodsT CHAR(6), date SMALLDATETIME) INSERT INTO #tmp(AnalyticGoodsT, date) VALUES ('000001', '20230424'), ('000002', '20230424'), ('000003', '20230424'), ('000004', '20230424') Required JSON format(i'm trying to group…
I have a array as follows : data = [ { "type":"abc", "quantity":36, "code:"EDF" }, { "type":"abc", "quantity":40 "code:"SFDF" }, { "type":"yrf", "quantity":22 "code:"SFDF" }, { "type":"yrf", "quantity":19 "code:"EDF" } ] I want to group elements of this array on…
In PostgreSQL, I have a table named users with data that looks like so: id favorites 1 { "shapes": ["Triangle", "Square"] } 2 { "shapes": ["Rectangle", "Triangle"] } ... ... Where favorites is a JSONB column. I want to add…
I was trying to find a solution to find out the number of occurrences of a number in an array and came across the below solution: const occurrences = [5, 5, 5, 2, 2, 2, 2, 2, 9, 4].reduce(function (acc,…
First of all, my apologies for any mistakes in my question as I have very less idea about asking questions. I came up with these two cases :- const comment = comments.find(function (comment) { if (comment.id === 823423) { return…
I have very little experience with coding and I've never asked a question on here so please bear with me. I am trying to make a "word of the day" generator with html, css, and javascript specifically (please no other…
<script> var startDate = "2023/04/01"; var endDate = "2023/04/16"; var dateMove = new Date(startDate); var strDate = startDate; while (strDate < endDate){ var strDate = dateMove.toISOString().slice(0,10); array.push(strDate); dateMove.setDate(dateMove.getDate()+1); }; $('.show').html(array); </script> result"2023/04/01","2023/04/01","2023/04/02","2023/04/03","2023/04/04","2023/04/05","2023/04/06","2023/04/07","2023/04/08","2023/04/09","2023/04/10","2023/04/11","2023/04/12","2023/04/13","2023/04/14","2023/04/15","2023/04/16" how to get results on Sundays 2023/04/02,2023/04/09,2023/04/16
I'm trying to compare two PHP arrays with different information. First array: Array ( [B1] => Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 [5] => 6 [6] => 7 [7]…
I want to merge objects with same key into one single object. For example the first array below is the array I am having. I want to convert it into second array CONVERT BELOW [ { "speed": 779.5, "id": 1…
I have two arrays of objects in Typescript, I am going through the first array to get the matches of the second array, my problem is that if it doesn't match it returns an empty array: This is the first…