Why can't I save to a list programatically? :(

[[email protected]]

Hi,

I am having an issue where I am changing the data associated to a list and it works, but it is not recognising it as dirty. It marks the line in the list with a light orange, which I understand that it thinks that a child list has a dirty row. The thing is the list is not a parent to another list. All I want it to change the data and save it to the database. The code I use to do the save is below. Can anyone help me please.

Thank you
Georgina

//Find if we have the data already in our basket
	var listBasket = {dialog.object}.getControl('LIST_BASKET_LINE');
			
		//define optional settings
		var ops = {};
		ops.setFocusToTargetRow = true;
		
		if (listBasket)
		{
	
			//Go get our primary key			
			var id = {dialog.object}.getValue('TB_WHID');
			id = id+'|||'; //this is the field seperator for a composite primary key
			id = id+ {dialog.object}.getValue('LIST::LIST_STOCK::st_code');
					
			var data;
			data = listBasket.getData(id);
		
			//did we find our primary key?
			if (data){
			
				//Update the record
				//alert('found primary key');
				data.order_pots = {dialog.object}.getValue('TB_TOTAL_POTS');
				
				listBasket.updateTableRow(id,data,ops);
                 }

[jgrannis]

Re: Why can't I save to a list programatically? :(

For debugging purposes, how about outputting somewhere and comparing what is in "data" (from the line: data = listBasket.getData(id);) before and after the update?
Or if you persist the data to localstorage, just look at the list data in localstorage via something like the Chrome DevTools.

[Davidk]

Re: Why can't I save to a list programatically? :(

There's a misleading bug in Alpha which points you toward a parent/child list problem... but it's not true.

The problem is in your code... and in what you're trying to update.

Your code is missing a closing brace.
What you're trying to update is everything... include the key... and Alpha stuff... and you shouldn't be doing that. Only update what you want to update. Your code should be...

	var listBasket = {dialog.object}.getControl('LIST_BASKET_LINE');
			
	//define optional settings
	var ops = {};
	ops.setFocusToTargetRow = true;
		
	if(listBasket){
	
		//Go get our primary key			
		var id = {dialog.object}.getValue('TB_WHID');
		id = id+'|||'; //this is the field seperator for a composite primary key
		id = id+ {dialog.object}.getValue('LIST::LIST_STOCK::st_code');
					
		var currData = listBasket.getData(id);
		
		//did we find our primary key?
		if (currData){
			
			var updData = {};
			//Update the record
			//alert('found primary key');
			updData.order_pots = {dialog.object}.getValue('TB_TOTAL_POTS');

			listBasket.updateTableRow(id,updData,ops);

		}
	}

[[email protected]]

Re: Why can't I save to a list programatically? :(

Hi Jgrannis,

I have tried this and the "data" is being updated. It is also being displayed in the grid. It just isn't recognising it as dirty and I don't understand why.


Hi DavidK,

Yes you are of course right I did post without the closing brace (I was sure I put it in), but my copy and pasting skills are obviously lacking here. The actual code does have the closing brace, so sadly that is not the issue. I am trying out your code amendment though.

Yours hopefully
Georgina

[[email protected]]

Re: Why can't I save to a list programatically? :(

DavidK you are a star. Thank you that worked brilliantly. Now I understand a bit more of what it is doing in the background.

Yey
Georgina