= Overview Primary Function = Without the need to go to another form, this function allows a table of data to be drawn on the current page using specified limiting factors. For example you have a company and you want to list all the contacts associated with the company. Using the current company id, only contacts associated with that company are displayed. = Example uses = * Contacts list for contact management.* Ticket list for a support desk. Tickets by customer* Orders by customer* Products by Invoice = Code = <syntaxhighlight lang="javascript"> /******************************************************************************************************Application: This function ............Version [1.0] Date [2016-08-29] Author [PJ]******************************************************************************************************/function fn_FunctionName(){ if (typeof aryAjax_Settings=='undefined') { alert('Library did not load'); } else { // Clear all settings fn_Ajax_BE_ResetSettings(); // Security Settings aryAjax_Settings[0] = 'client_demo'; aryAjax_Settings[22] = document.getElementById('intSystemGenerated_CompanyId').value; //Auto Login - System aryAjax_Settings[23] = document.getElementById('intSystemGenerated_UserId').value; //Auto Login - User aryAjax_Settings[24] = document.getElementById('intSystemGenerated_LoginKey').value; //Auto Login - SessionId // Retrieval Settings aryAjax_Settings[16] = 'Table'; //Engine to use aryAjax_Settings[3] = 1; //The form with the data aryAjax_Settings[4] = 'strCDA_1_field_0_0'; //The field to search on aryAjax_Settings[5] = document.getElementById('intCDA_Id').value; //The value to limit by aryAjax_Settings[13] = '-1' //Limit response aryAjax_Settings[40] = "500"; //Retrieval limit if applicable //Error management aryAjax_Settings[15] = 'divWarning'; //Where to draw error messages if any //Common Functional settings aryAjax_Settings[6] = 'intCDA_1_Id,strCDA_1_field_0_1'; //The fields to be displayed in the table aryAjax_Settings[12] = 'Id,Column1'; //The column headings for the fields being displayed aryAjax_Settings[28] = ''; //Function to be executed after retrieval //Function specific settings //... //Execute fn_Ajax_BE_Process(); //The main execution of the AJAX //Write URL out (Comment out after testing) if (document.getElementById('divURL')){ document.getElementById('divURL').innerHTML = "<a href='" + aryAjax_Settings[7] + "' target='_blank'>Constructed AJAX URL</a>"; } }} </syntaxhighlight> = Troubleshooting = For any errors messages and troubleshooting AJAX please read here [[AJAX_-_Error_messages_and_troubleshooting]] = Associated reading = For all our custom AJAX functions please read here [[AJAX_-_Start_Here]] For the full array of all possible parameters please read here [[AJAX_-_Full_Array_of_Parameters]] For how the security engine of AJAX works [[AJAX_-_Security_engine]] For more advanced table settings and options have a look at LiveSearchTable [[AJAX_-_Function_-_Live_Search_Table]]
Under construction [[AJAX_-_Start_Here]]
[[Category:Topic:JavaScript]]
[[Category:Topic:AJAX]]