i a have postgresql query that gets results like this: id | arrayElements 0 | [0, 2, 1] 1 | [0, 3] 2 | [1] In the above example the values inside arrayElements means something. I want to split this…
I have a postgres table 'games' containing different scores for a game. I want to query all the games and have the average score of all the scores for that specific game. I tried a lot of different queries but…
I have a Data which am getting from API, its in a format [ Appointments(startTime:"2022-09-01",subject:"Clinic Appointment",activityid:"2343"), Appointments(startTime:"2022-09-01",subject:"Night Appointment",activityid:"5738"), Appointments(startTime:"2022-09-01",subject:"Regular checkup",activityid:"2975"), Appointments(startTime:"2022-09-02",subject:"High Fever",activityid:"9274"), Appointments(startTime:"2022-09-02",subject:"Virtual checkup",activityid:"5648"), Appointments(startTime:"2022-09-03",subject:"Regular Appointment",activityid:"1892") ] and I have an array where I have all the Dates of this…
I'm working on a vuejs/(vuex) for state management/firebase project of posts. So I have a firestore collection of posts (array of objects that have name id owner content and timestamp for creation ...) I'm retrieving that data by using the…
This is my array which I'm pulling from Firebase with a listener. [{"Amount": "40", "Day": "08/31/2022"}, {"Amount": "300", "Day": "09/01/2022"}, {"Amount": "1715", "Day": "08/31/2022"}, {"Amount": "250", "Day": "08/31/2022"}, {"Amount": "100", "Day": "08/31/2022"}, {"Amount": "200", "Day": "08/31/2022"}] I want this array…
I'm building my first project, an expense tracking app with React Native. It's going very well. I would like to concat the following 2 arrays. [{"Day": "08/31/2022"}, {"Day": "09/01/2022"}, {"Day": "08/31/2022"}, {"Day": "08/31/2022"}, {"Day": "08/31/2022"}, {"Day": "08/31/2022"}] [{"Amount": "40"}, {"Amount":…
I am recently learning the map and filter method in react native and I have a question. After finding a particular row of my array (with filter), how do I set only a particular field of that specific row? I…
Let say I have dynamic array const branddata = ["adidas", "nike", "puma"] //this data can be sometime empty too like // const branddata = [] //now I want to search all the product with brands like const product = productmodel.find({brand:branddata})…
I am trying to create a DataFlow under Azure Data Factory and I need to check if my array contains values from another column. These are the information: enter image description here I have a table with 3 columns and…
How can I read the data of my Firebase document and put the data in a local list/array? my firebase docs