Search Builder demo

This demo uses the student table, which contains numeric, text and date values. All data types are supported by the Search Builder. Click the ADD CONDITION button to create a new query. The Search Builder can be combined with global search. It cannot be combined with individual column search.

This publication uses premium styling!

The Search Builder is a user friendly interface that helps users to query table data interactively. It supports numeric, text and date columns. The Search Builder is a premium feature.

FirstnameLastnameGenderEmailPhone NoCountryCountyCityZipcodeAddressDate Of BirthRegistration DateID
FirstnameLastnameGenderEmailPhone NoCountryCountyCityZipcodeAddressDate Of BirthRegistration DateID

Shortcode arguments used for this demo

[wpdataaccess pub_id="11"]

Adding the Search Builder to a publication

Add the following options to a publication to activate the Search Builder (read more).

{
	"dom": "Qrtip",
	"serverSide": false,
	"stateSave": false
}

Limitations

  • The Search Builder does NOT support server-side processing (serverSide must be false)
  • With serverSide = false all table data will be loaded to the client on page request
  • Don’t use the Search Builder for large tables

Notes

  • To activate the Search Builder add Q to the dom option (see code above)
  • Option serverSide must be false (see code above)