Getting Viewbox data to use in UX

[dfricke10]

I'm attempting to extract the data from the viewbox and use it on the component level. There's other threads on how to do this and I've successfully done it with one of the header values. But how would you extract the javascript calculated field, 'totalExtendedPrice' in the viewbox to go into the 'Total' field on the UX?

The attached extracts the CustomerID but I can't figure out how to get the totalExtendedPrice value to that field.

testUX.zip

[dfricke10]

Re: Getting Viewbox data to use in UX

Update:

I've figured out how to pull the line item total. Now I need to pull the summary of these subtotals.

function getSubTotal() {

var vb = {dialog.object}.getControl('viewbox1');

	var qty = vb.data[0].orders[0].orderItems[0].Quantity;
	var price = vb.data[0].orders[0].orderItems[0].UnitPrice;
	var subtotal = qty * price
	
	{dialog.object}.setValue('Total',subtotal);

}

This is using the sample data in a viewbox.

[RichCPT]

Re: Getting Viewbox data to use in UX

function getSubTotal() {
function getSubTotal() {
   var vb = {dialog.object}.getControl('viewbox1');
   var grandTotal = 0;
   var customerTotal = 0;
   var orderTotal = 0;

   var qty = 0;
   var price = 0;
   var extended = 0;
 
   for( i=0; i < vb.data.length; i++  ) {
      customerTotal = 0;
	   for( j=0; j < vb.data[i].orders.length; j++ ) {
	      orderTotal = 0;
	      for( k=0; k < vb.data[i].orders[j].orderItems.length; k++ ) {        
	         qty = Number(vb.data[i].orders[j].orderItems[k].Quantity);  // just incase AA isn't really storing it as a number field
	         price = Number(vb.data[i].orders[j].orderItems[k].UnitPrice);
	         extended = qty * price;
	         orderTotal = orderTotal + extended;
	         customerTotal = customerTotal + extended;
	         grandTotal = grandTotal + extended;
	      }
	   }
	  {dialog.object}.setValue('Total',customerTotal);  // for a customer total
	}
// ?  {dialog.object}.setValue('Total',grandTotal);  // for a grand total
}
}

[Davidk]

Re: Getting Viewbox data to use in UX

If the object of the exercise is to get the example Grand Total value of $4,596.20, then you're logic is off. With your code against the sample data I got $4,101. The loop logic should be...

   for( j=0; j < vb.data[0].orders.length; j++ ) {
      orderTotal = 0;
      for( k=0; k < vb.data[0].orders[j].orderItems.length; k++ ) {        
         qty = Number(vb.data[0].orders[j].orderItems[k].Quantity);  // just incase AA isn't really storing it as a number field
         price = Number(vb.data[0].orders[j].orderItems[k].UnitPrice);
         extended = extended + (qty * price);
      }
   }

 {dialog.object}.setValue('Total',extended);  // for grand total

I'm not sure that's what David is going after... it isn't that clear.

You could also shove a <span> tag into the ViewBox layout and grab the total that way...

Grand total: <b><span id="myTotal">{[temp].grandTotal:number('$#,###.00')}</span></b>

I wouldn't be surprised if there an internal Alpha way to get that calculated data... but I can't find any doc on it.

[dfricke10]

Re: Getting Viewbox data to use in UX

David, yes. That's the total I was looking for. I'm using this in place of a repeating section inside a repeating section because I can pull all the data and display it from multiple tables, then total it, then pass the total to the base UX component to be saved in the main table.

Kinda confusing, but it makes sense to me I guess. I'm just displaying 1 order and pulling that total. But this gives me options for other things that I can do.

Thank you both!

[RichCPT]

Re: Getting Viewbox data to use in UX

David, yeah thanks. I just realized that, too. I had not replaced the [0] indexes with the appropriate j or k index. I also edited the code in post # 3 to include three loops instead of two, since we don't know for sure if there is just one customer in the data. I has also thought about suggesting adding an ID to the html element (like in your post 4) that holds the "grand" (not sure if this is total for one customer or total across all customers in the data) total and also including a row number, customer ID and/or order ID, to make the ID unique, incase the data and template generated more than one "grand" total line.