{"Name":"z_myData search results","Active":true,"Notes":"Examples of obtaining custom search results using custom Prepare ","Roles":50538,"AType":34,"IncludeWoItemDescendants":false,"Template":"<html>\n\n<body>\n   <div>\n\n      <div>\n         <p>myData.SearchResults - Fetched dynamically from API route <strong>enum-list/list/AyaType</strong> using report template's Prepare</p>\n         <p>specifically, Prepare searches for the text \"Purple\" in any object in the database and returns....</p>\n         <p>{{ayJSON myData.SearchResults}}</p>\n      </div>\n      \n      <table class=\"singlePage\">  <!--this class causes a page break for each object - for each work order -->\n         <thead>\n            <tr>\n               <th colspan=\"5\">Column to the right displays the individual property myData.SearchResults.data.totalResultsFound obtained:</th>\n               <td colspan=\"5\">{{ayJSON myData.SearchResults.data.totalResultsFound}}</td>\n            </tr>\n            <tr>\n               <th colspan=\"5\">Column to the right displays the third array in the search results:</th>\n               <td colspan=\"5\">{{ayJSON myData.SearchResults.data.searchResults.[2]}}</td>\n            </tr>\n            <tr>\n               <th colspan=\"10\">&nbsp;</th>\n            </tr>\n            <tr>\n               <th colspan=\"10\">Below displays each record that has the search result</th>\n            </tr>\n            <tr>\n               <th colspan=\"6\">Name</th>\n               <th colspan=\"2\">Type</th>\n               <th colspan=\"2\">ID</th>\n            </tr>\n         </thead>\n\n        {{#each myData.SearchResults.data.searchResults}}<!--iterates through for each result -->\n         <tbody>           \n            <tr>\n               <td colspan=\"6\">{{name}}</td>\n               <td colspan=\"2\">{{type}}</td>\n               <td colspan=\"2\">{{id}}</td>\n            </tr>            \n         </tbody> \n         {{/each}}\n\n      </table>\n\n   </div>\n</body>\n</html>","Style":".singlePage\n{\npage-break-after: always;\n}\n\np {\n  word-wrap: break-word;\n  font-size: 9pt;\n}\nbody {\n  font-family: 'Helvetica',  'Helvetica Neue',  Arial,  sans-serif; \n}\n\n.reporttitle {  \n  margin-bottom: 20pt; \n  font-weight: bold; \n  font-size: 11pt; \n  color: #9e9e9e;\n} \n\ntable, td, th {\n  border: 1px solid black;\n}\n\ntable { \n  white-space: pre-wrap;\n  width: 100%;\n  table-layout: fixed; \n    }\n\nth {\n  height: 30px;\n  font-size: 9pt; \n  color: #9e9e9e;\n}\n\ntd {\n  padding: 10px;\n  word-wrap: break-word;\n  font-size: 9pt;\n  text-align: center;\n}\n\n\ntbody tr:nth-child(even) {\n        background-color: #f8f8f8; /* MUST checkmark Print background in PDF Options for this to show */\n}\n\n\n.rightlean {\n    text-align: right;\n}\n.leftlean {\n  text-align: left;\n}\n.centerlean {\n  text-align: center;\n}\n\n\n.fontgreen {\n  color: green;\n}\n.fontblue {\n  color: blue;\n}\n.fontred {\n  color:red;\n}\n\n","JsPrerender":"async function ayPrepareData(reportData){         \n    //this function (if present) is called with the report data \n    //before the report is rendered\n    //modify data as required here and return it to change the data before the report renders\n    //see the help documentation for details\n\n\n    //Put the data into the main report data object so it's available to the template\n    reportData.myData={ServerInfo:await ayGetFromAPI(\"server-info\")};\n    \n     //Example API POST method to fetch data from api server\n    let searchPostData={phrase: \"Purple\"};\n    reportData.myData.SearchResults=await ayPostToAPI(\"search\", searchPostData);\n\n\t\n\n    return reportData;\n}","JsHelpers":"","RenderType":0,"HeaderTemplate":"<span>&nbsp; </span>","FooterTemplate":"<span style=\"font-size:6pt; width: 96%;text-align:left; \">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp; Printed date: PDFDate</span>\n<span style=\"font-size:6pt;width: 96%; text-align: right; \">Page <span class=\"pageNumber\"></span> of <span class=\"totalPages\"></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;</span>","DisplayHeaderFooter":true,"PaperFormat":10,"Landscape":true,"MarginOptionsBottom":"15mm","MarginOptionsLeft":"15mm","MarginOptionsRight":"15mm","MarginOptionsTop":"10mm","PageRanges":null,"PreferCSSPageSize":false,"PrintBackground":true,"Scale":1.00000}