Hello, I am trying to print search results to a pd...
# suitescriptj
j.j
01/13/2021, 7:13 AMHello, I am trying to print search results to a pdf, and using the code from netsuite documentation, but it does not seem to work, var renderer = render.create();
renderer.templateContent = xmlStr;
renderer.addSearchResults({
templateName: 'result',
searchResult: results
}); - it seems that i am missing something here, can someone post a code snippet here on what should be templateName and the xmlstring that should be used
b
battk
01/13/2021, 6:42 PMGet Advanced Templates for Printing Saved Search Results to work in the ui first
battk
01/13/2021, 6:46 PMuse the template you created as the template for the renderer (preferably using TemplateRenderer.setTemplateByScriptId)
battk
01/13/2021, 6:47 PMthe templates you create in the ui should use
resultsj
j.j
01/14/2021, 4:09 AMthanks battk, seems there was an issue with template in sample code and also the settemplatebyscriptid fetched some errors, finally copied the template string and ran it, and it worked finally. many thanks @battk
j.j
01/14/2021, 5:41 AMalso @battk we are limited to sending one result slice of max 1000 results to add to addsearchresult in renderere, any idea how to add full search result (more than 4000+ lines)
b
battk
01/14/2021, 5:58 AMim sure there is some limit, but 1000 is not it
battk
01/14/2021, 5:59 AMif you are making the mistake of only using getRange once before using addSearchResults, then you should get all your search results first and then use addSearchResults
battk
01/14/2021, 6:00 AMthat said, you should probably be using runPaged instead of run
j
j.j
01/16/2021, 3:23 AMthanks @battk i am able to get all results into pdf now, but am stuck as its a summarized search and it does not pick the values, for normal search it works, but for summarized / grouped it does not. any idea on how to includ summarized in addsearchresults
b
battk
01/16/2021, 6:36 AMprobably will have better luck using addCustomDataSource
battk
01/16/2021, 6:37 AMi have never gotten summarized columns to work with the renderer
j
j.j
01/16/2021, 7:56 AM@battk that confirms my finding, strange that renderer does not support such basic need, making it half baked library