So basically what i want to do is to display the data i get from my DB in a ListView, but I'm only able to show one attribute of my Object Device. This my Class for device class Devices {…
I have these collections: author [ { _id: "63c242130b17d5516e0cb499", author_name:'Vyom', book_ids:["63c242330b17d5516e0cb49a","63c242410b17d5516e0cb49b"] } ] book [ { _id:"63c242330b17d5516e0cb49a", author_id:'63c242130b17d5516e0cb499', book_name:'True Love', genere:'horror' }, { _id:"63c242410b17d5516e0cb49b", author_id:'63c242130b17d5516e0cb499', book_name:'Monster Strike', genere:'romance' }, ] I want to fetch details of books in author collection…
I would like to add an optional checkbox to a user registration form saying "I want to be included in marketing activities and product updates". I would like to then accordingly register the user preference... is there a way to…
As I want to try out Apache Age of postgresql, I got lost when reading the documentation. Is there any easy solutions ?
I am creating a marketplace in angular and I have created the marketplace page which is populated by a remote json created with mockapi. The problem is that in the homepage I want to display a single item (possibly random)…
How to get AVG of a column only if the all the row values for this specific column are not equal -1 ? I have a table with a column named quarter, Its value can be 0-100. But in case…
I have a collection "product_reviews" with this document structure { _id: 'B000000OE4', 'product/title': 'Working Class Hero', 'product/price': '16.99', reviews: [ { 'review/userId': 'unknown', 'review/profileName': 'unknown', 'review/helpfulness': '2/3', 'review/score': '4.0', 'review/time': '27/05/1999/00:00:00', 'review/summary': 'Worth it for one song', 'review/text': "I really…
I have a table representing a card deck with 4 cards that each have a unique ID. Now i want to look for a specific card id in the table and find out which card in the deck it is.…
I have a table with created_at and deleted_at timestamps. I need to know, for each week, how many records existed at any point that week: week records 2022-01 4 2022-02 5 ... ... Essentially, records that were created before the…
I have an async function (getDataFromDB) which I run inside of an useEffect. The function gets data from firestore. The problem is I can't set state to data from firebase. I get the reference to data, I can see the…