This search control can be used on multiple pages within a single application without more changing in script.
I have attached a sample application (asp.net, jQuery and JSON). But it can be used in other languages also wherever jQuery is supported like php, java etc.
This control has multiple Operators and multiple fields to search and it makes dynamic Sql query to search from database.
We can change or add new column easily in JSON file(JsonDoc.js). In JSON file, we can describe properties related to database like column name, table name, and Keys also. In JsonDoc.js file you will see one property Module, you can mention here about different pages. For example, on one page we want to show employee related columns to search, and on another page, we want to show department related columns to search.
All jQuery functionality are written in JSON_advancedSearch.js file.
Jemiris SPosted Mar 17, 2020, 7:15 AM
I'm using this library in PHP. It works well for the dynamic construction of fields and the query. Thanks. And for the calendar, I dig the code and implementing to format the date showing (year only and date format)
Jemiris SPosted Mar 17, 2020, 7:06 AM
I have fixed that issue. In the GetFieldList() function i have added if (val.Module == module) { "Options": val.options ? val.options : ''}
Jemiris SPosted Mar 9, 2020, 2:28 AM
Hi, The select option is not working JSON_advancedSearch.js:396 Uncaught TypeError: list.split is not a function at BindOperatorList (JSON_advancedSearch.js:396) at HTMLSelectElement.<anonymous> (JSON_advancedSearch.js:29) at HTMLSelectElement.dispatch (jquery-1.8.2.js:3064) at HTMLSelectElement.eventHandle (jquery-1.8.2.js:2682)