Copy data from a data store to another data store (array inside datastore)

[famousmag]

Hey guys,

I’m building a commercial web page simulating the ordering procedure (select a client and then add products )

Order Addition

I want to be able to apply variations & their values in any of the products that I add in every order.
In order to accomplish that I used data store (oderData). Now, because I want to be able to cancel the variations editing, I chose to create a 2nd additional data store (prod_vars) that keeps only the current (the one that I am editing) and after finishing the editing (cancel or save), I update my main data store (by passing the prod_vars data store as a value to the main data store array/field. Then I clear this 2nd additional data store and be ready for any other variation’s update.

Here is the click event of the Product Variations Modal’s SAVE ALL button:
dmx-on:click="orderData.update({$id: curPrdIndx.value.toNumber()},{prod_vars: prod_vars.data, prod_id: orderData.data[curPrdIndx.value.toNumber()-1].prod_id, prod_name: orderData.data[curPrdIndx.value.toNumber()-1].prod_name, prod_qnt: orderData.data[curPrdIndx.value.toNumber()-1].prod_qnt, prod_unt: orderData.data[curPrdIndx.value.toNumber()-1].prod_unt, prod_prc: orderData.data[curPrdIndx.value.toNumber()-1].prod_prc, prod_dsc: orderData.data[curPrdIndx.value.toNumber()-1].prod_dsc, prod_deldate: orderData.data[curPrdIndx.value.toNumber()-1].prod_deldate, prod_dest_id: orderData.data[curPrdIndx.value.toNumber()-1].prod_dest_id});modal_UpsertVarOptions.hide();prod_vars.clear()"

I have managed to create for the first time (insert) the variations but when I want to update them I cannot because the data are in my main data store oderData.
So, I need a way to pass/copy the variations from the main oderData back to the additional prod_vars data store.

I hope you understand…

Any help / idea would be much appreciated!

Thanks in advance,
Tasos

[sitestreet]

Rather than using two data stores, would you be better just having a field in it which is set to whether it’s the one being edited? Then you don’t need to copy anything, just update that field in the selected record.

[famousmag]

Hey Jon,

You mean to edit straight forward the main’s data store fields in my Modal?

• I would like to have the chance to cancel if a mistake is made and keep the original Variations.
• There is no easy way (UI) of insert/update the array field of the main data

As a matter of fact I’m dealing with Ken’s situation…

Arrays within data store

Is this a valid data store? [Screen Shot 2020-02-14 at 4.10.23 PM] Seems like it should work, but I can’t insert the array field…categories [Screen Shot 2020-02-14 at 4.11.35 PM]

@mebeingken I would like to hear how you deal with that kind of structure.

[mebeingken]

You can add arrays into a data store, but this can’t be done via the UI — you have to type it into the code.

[famousmag]

Thanks Ken for your input.

Could you please give me an example code so I can go on?
I tried assigning a flow with a repeat in it based on main’s data store but couldn’t get something out from it (I don’t know how to export repeat fields, how to use $index inside flow repeat etc…)

[famousmag]

After a little workaround I took a look on app flows and I managed to send back (inside a repeat with output checked) the values from the main data store. Then I added the app flow on my page and on Done event I managed to get the values of the main data store.
Now I need to insert them in the additional data store.
No hand code…
When I’ll finish it I will post the workaround here in case that somebody is interested in.

[famousmag]

Works perfect guys…
Just came back from my back therapy treatment and have to go rest for a while. In a few hours I would like to release a post for this simple workaround on arrays inside data stores.
Cheers

[famousmag]

I thought I could just create a new page and database tables to demonstrate the functionality but it’s going to take long to me to do this.

So, forgive me for showing only the highlights and “to the point” steps.

IMPORTANT!!
Add the repeat’s output fields by hand and save the appFlow json file.

On button Click:

IMPORTANT!!
Add the repeat’s output fields by hand.
<script is="dmx-flow" id="flow_prdVarsToOrder" type="text/dmx-flow" src="app/flows/prdvars_tostore.json" dmx-on:done="run({repeat:{repeat:flow_prdVarsToOrder.data.repeat,outputFields:['var_id','var_name','var_opt_id','var_opt_name','var_opt_pr'],exec:{steps:{run:{action:prod_vars.insert({var_id: flow_prdVarsToOrder.data.repeat[$index].var_id.toNumber(), var_name: flow_prdVarsToOrder.data.repeat[$index].var_name, var_opt_id: flow_prdVarsToOrder.data.repeat[$index].var_opt_id.toNumber(), var_opt_name: flow_prdVarsToOrder.data.repeat[$index].var_opt_name, var_opt_prc: flow_prdVarsToOrder.data.repeat[$index].var_opt_prc.toNumber()}),name:'insertProdVarsRecord'}}},name:'repeat',output:true}})"></script>

I am not good at explaining, it takes too much time and I am tired…
I hope you understand the main idea.
You pass a Data Store with Arrays as a parameter in an App Flow and on Done event you get the values as an array (repeat)

If anybody needs any help or extra explanations feel free to ring my bell.

Cheers

[famousmag]

Hey guys,

For whoever is interested in manipulating Array fields inside DataStore, I finally did a small demo here…
Showcase: DataStore, Manipulating Array fields inside DataStore (Client_side) - Wappler General - Wappler Community

I ended up using other way but the result is the same…