I am having trouble creating a JSON object that embeds an array of dictionaries. Here is non-working code of what I want to do. The myMessages in parameters throws an error: let myMessages: [Dictionary: Any?] = [ { role: "system",…
I'm trying to find the average value of the array, I'm stumped on how to add the array values together, I have the for loop condition set up ( for ( i = 0; i < array.length; i++) but how…
I am working on nested array and try to find a value inside the nested array based on condition. The API returns the data in the format shown below. data= { "ch_Id": "1234", "title": "Title", "status": 4, "options": [ {…
I wrote a code javascript code that will display the complete write up of a particular text which happens to be in three location in my html, but instead of displaying just the particular one that was clicked, its displaying…
select sum(case when '%sys%' like any(series_arr) or 'displays' = any(lob_arr) then revenue else 0 end) as sys_displ_revenue from mytable Basically, when I run this query, the term '%sys%' like any(<array column>) seems to get ignored, and only the 'displays' revenue…
I have an array and I want to create below HTML table from the array I've tried writing the code bleow but seems like its appending rows in different places Is there any other way to archive above table. im…
I have an array of an array of JToken objects. I would like to return a list of the top 10 objects ordered by the Severity member in descending order; right now, I'm just returning all issues where Severity <…
I am trying to sort arrays in MongoDB shell. This seems to be the only syntax available to use. db.products.updateOne({"name": "ben"}, {$push: {"hobbies": {$each: [], $sort: -1}}}) My question is that, is there no other way to do this -…
I want to create a function that logs out "I have 1 bottle. I have 2 bottles. I have 3 bottles" and so on, to the console. But I keep getting the output below: I have 1 bottle I have…
I have an array of objects containing addresses like this: let addressArray = [ { street: '123 Charm St', city: 'Tuscaloosa', state: 'AL' }, { street: '456 Hampton Ave', city: 'Tuscaloosa', state: 'AL' }, { street: '789 Greenview Dr', city:…