e.dataSubmitted doesn't have correct data from viewbox control

[natephillips7]

Hello!

I am just getting into using viewboxes, and liking them a lot. The issue I'm having is I populate a viewbox with an array of json data about the products in a users cart. I want to get the info from that viewbox when the user submits and push that order to the database.

The viewbox type is data and the source is Static JSON. I add to it programmatically from a list component with the products.

The issue is the e.dataSubmitted.CartList (viewbox control) only contains the data 1/n1/n1/n and nothing else. I'm not sure where I'm supposed to get the json from the cart list to get the information I need.

Any help is appreciated! Thanks!

[peteconway]

How are you appending the data to the cart? The viewbox is way different to the List when submitting to the Database.

Pete

[natephillips7]

Hey Pete!

The viewbox source starts off as an empty array.
When I select an item from my products list and click the add to cart button it grabs the current data from the viewbox, copies it to a new array, appends the new product JSON to the end of the new array, and then uses the populate function to populate the viewbox with the new JSON array.
I just need access to that array of JSONs in the dialogValidate server side functions etc to set up and submit the database call.

[peteconway]

Here you go..

var _row = v;


var data = this.data
// get the data for the current row
var dataRow = data[_row];


var msg = JSON.stringify(dataRow,'','\t');
alert(msg);

[peteconway]

//var pInfo = data[_row].ProductName + ' Quantity Per Unit ' + data[_row].QuantityPerUnit + 'Price $' + data[_row].UnitPrice ;
//alert(pInfo);

[peteconway]

Do you know what to do with the code?

returns.

{
"ProductID": "6",
"EntityID": "1000",
"ProductName": "Grandma's Boysenberry Spread",
"SupplierID": "3",
"CategoryID": "2",
"QuantityPerUnit": "12 - 8 oz jars",
"UnitPrice": "25",
"UnitsInStock": "120",
"UnitsOnOrder": "0",
"ReorderLevel": "25",
"Discontinued": "F"
}

Pete

[natephillips7]

Yeah I already have that portion of the app working. I've been able to populate the cart list using the product list, that went pretty smoothly.

The issue I'm having is now getting that data from the cartlist viewbox in the onDialogValidate xbasic server side functions. I need to get that data, validate it (make sure the cart total price is above a certain limit etc) and then I need to get that data and build a SQL statement to push the new order to the databse.

When I try to access the data from the cart list in e.dataSubmitted.cartlist all I'm getting is a repeating 1/n value. I need access to that JSON server side.

[natephillips7]

Unless that is how I get it and somehow pass it to the server side events, in which case I'm not sure what to do with it no.

[natephillips7]

Would I place this somewhere within the viewbox component to have that be what is submitted to the server side dataSubmitted object?8

[natephillips7]

I've found a fix by storing the entire array of JSONs in a hidden label on the UX component whenever the viewbox json is changed. Then I just convert that to a json using json_parse() to get that data. Seems like I should be able to get this data from the viewbox but I'll take it for now.

[peteconway]

I asked you this question 'Do you know what to do with the code?' You seem to be working backwards, if you intend to this data to end up in a database to insert the data or make changes to the data you need to put the data in controls on the UX or set them as State values, then the xbasic on can access the data from the client side either by using the stateValue e.g. e._state.productID or e.dataSubmitted.ProductID. The code I sent you lets you doe that.

Pete

[natephillips7]

Sorry I probably didn't explain my issue correctly in the first post.

I have the viewbox fully working and I'm successfully getting the data from the list, turning it into a JSON, and populating the viewbox with that data. So I can add and remove data from the view box cart. The issue I was having is that I am now trying to submit that cart data from the viewbox to the database via server side xbasic using the submit button.

When I am debugging and viewing the e.dataSubmitted values, my cart viewbox (named CartList) just has the values 1/n1/n1/n. It is populated with the correct JSON, but those values apparently don't come through to e.dataSubmitted. I went around it by using another hidden control on the UX and just cloning the JSON in that whenever I populated the JSON in the viewbox, and then I had access to the JSON in the e.dataSubmitted.cartListData control. I just thought it would be cleaner and more intuitive if the e.dataSubmitted.CartList viewbox had that data instead. It seems like maybe the viewbox's state is where I need to set that?

At this point I have everything working, and once I figure out how to create an editable field on the viewbox for quantity I will be done with this UX. That's a question for a different post on the forum I made earlier though.

Thanks again for all your help Pete, you're a lifesaver!