How to add selectable Quoted Line item history to Quotes?

Ok so I'm getting close, need a nudge here.  Attempting the Custom Drawer route.  This actually works perfectly (almost).  Here's what I'm doing.  Its VERY close to the functionality I want, but maybe there's an easier/better way to do this?

I've added a custom button to the action view:

https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Creating_an_Action_Button/

Then on click event, I'm calling a custom function that 

• Makes an API call to #Products (Quoted Line Items) with a filter of the current quotes 'billing_account_id'
• Create a bean collection of all returned results
• Use that bean collection to populate a selection list drawer
• added a callback function to actually do something with the returned result, but just console logging for now.

There are 2 problems:

1. The returned API results are correct but there are 60K records for the account I'm testing so its taking FOREVER to load the list view inside the drawer
2. The drawer search bar and filters dont work.  

Here's my full code.  Anyone have any ideas?  Am I over complicating this?  Or am I mixing some parameters and it just kinda happens to look almost perfect?

_show_history: function() 
	{
		account_id = this.model.get("billing_account_id");
		parentModel = this.model, 
		  
          linkModule = 'Products'; 
			
          linkModel = app.data.createBean(linkModule); 
		  var url = app.api.buildURL(linkModule, null, null, {
                'filter'    : [{
                    'account_id'  : account_id
                }]
            });
			  app.api.call('GET', url, null, {
				success:function(data){
				  products = app.data.createBeanCollection("Products",data['records']);
				  app.drawer.open({
					layout: 'selection-list',
					context: { 
					   module: linkModule,
					   model: linkModel,
					   parentModel: parentModel,
					   collection:products,
					   filterOptions:{
						 stickiness:false,
						 auto_apply:false,
					   },
					}
				  }, function(selectedModel) {
					   if (!_.isEmpty(selectedModel)) {
						  console.log("We did it!");  // Handle the callback later to add item to Quote
					   }
				  });
				},
				error:function(e){
				  console.log(e);
				},
			  });
			
	},

This is not an answer to your question, but it sounds like you want your user to be able to copy the line items from a previous quote, including the price. Won't the Copy function in the Action Menu on a prior quote do exactly that?

FrancescaS

Oh thank you Francesca Shiekh.  I just noticed now that you replied. 

So a copy is not exactly what I'm looking for.  In 7.7 I had a totally custom html table that was appended to the bottom of the detail view.  On page load, it would run a query of all line items which that specific customer had ordered.  

So let's say a customer ordered 10 unique items over 5 separate quotes. The table would show the quote numbers, the date, the items etc.  Then the user could select the items at will.  The items could be from 3-4 different quotes.  Then I had a button that said "Add selected products to quote" which took the selected ID's from the custom HTML table and added as products in the "products" table with all the previous values like sale price.  

This was especially useful for repeat customers who order the same thing. The user did not have to look through Quoted line item history.  It was in a panel at the bottom of the detailview.  

My customization was years ahead of sugars native dashboard which only shows recent items by that user, bot by the billing account ID.  

My thoughts is that if I can override or extend the native recent items dashboard, I can get close to what 7.7 could do that is no longer possible. 

Any feedback is deeply appreciated