Datastore delete item problem

Wappler General Need Help
1

Hi everyone,
I have to solve a problem about deleting an item from a datastore.
I'll explain the flow...
I have a repeat that reads data from a Json file with this structure.

1
11300×158 37.3 KB

{
  "items": [
    {
      "productcode": "BP-HW-001",
      "price": "4500",
      "image": "assets/images/order/brainpod-personal.png",
      "title": "BrainPod© Personal",
      "description": "Versione entry level ideale per un massimo 3 utenti contemporanei"
    },
    {
      "productcode": "BP-HW-002",
      "price": "6500",
      "image": "assets/images/order/brainpod-team.png",
      "title": "BrainPod© Team",
      "description": "Versione ideale per un massimo 30 utenti contemporanei"
    },
    {
      "productcode": "BP-HW-003",
      "price": "2500",
      "image": "assets/images/order/brainpod-onpremise.png",
      "title": "BrainPod© On-Premise",
      "description": "Installa BrainPod© all'interno del tuo data ceter aziendale"
    }
  ]
}

When I click on an element I write the data into a datastore which has this structure

3
3367×625 28.1 KB

Data is saved correctly

2
2705×896 97.6 KB

When I click again I should check if there is already an item with the same product code inside the datastore.
If there is, I have to delete it, otherwise I have to add it.
I created this condition but I think I didn't write the logic well because it doesn't work, it always continues to add the record in the datastore

4
41477×995 210 KB

2

I think the.value is wrong...

Try to ask for the productCode in your where formatter
swData.data.where(productCode,productcode,'==')[0].productCode

1 Like
3

Great now it works, thanks for the tip!!

4

Can I ask you how can I insert the productCodes present in a datastore into a variable as an array?

5

Insert all the productCodes that exist in your datastore in an array?

Can you please explain?

6

I would like to read the productcodes from the datastore and transform them into arrays to insert them into a hidden field of a form.

Senza titolo

BP-SK-002;BP-SK-001

7

I think you can do that with flatten formatter

swData.data.flatten('productCode')

8

I tried but unfortunately it doesn't work
At the moment I managed to get all the content with the .toJSON formatting but I only need the productcode value

9

swData.data.join( ',' , 'productCode').splt(',')

10

In this case it returns me an object

Screenshot 2024-09-27 190152
Screenshot 2024-09-27 190152913×250 27.9 KB

11

so you want to display it with 1 call...
Try this

swData.data.values(`productCode`)
1 Like
12

Thanks, this works fine!

1 Like