Documentation Database

* This Documentation was realized with the joodb component. Please click on the items to open a detailed description. The documentation is still under construction.
select view
   
CommandOrder by:  Command

searchbox

{joodb searchbox|[FIELDLIST]}
thumb

Searchbox displays a searchform with an input field for fulltext-searches, search- and resetbuttons and optionally a selector to perform the search only in a special target column.

Parameters 

  • FIELDLIST (optional) - comma separated list of fieldnames

Example

Search in Data


{joodb searchbox|title,value,category}

Code example from the "My Little DB" example database.

Notes

  • Always use real expressions in your language as fieldnames for your database
  • Enter the fieldnames in lowercase
  • The first letter will be transformed to uppercase

 

searchfield

{joodb searchfield|FIELDNAME|[cond]} »pro only«
thumb

searchfield is part of the catalog search options. With searchfield you can search in a specific collumn only. You can also combine multiple searchfields for complex searchforms.

Parameters 

  • FIELDNAME - Name of a field in your database
  • cond (optional) - The search condition
    Valid conditions are
    • like (default)  - Match any coincidence
    • exact - Fieldcontent must match 
    • min - Fielvalue is higher or equal (e.G. find all Products more expensive then 4 $)
    • max - Fielvalue is lower or equal
    • start - Fieldcontent starts with (e.G. find entries with date 2014 but not from 2015)
    • end - Fieldcontent ends with

Example

Search by field






 {joodb searchfield|title}
 {joodb searchfield|author}
 {joodb searchfield|genre|exact}

Search for values in different fields

Notes

  • If you have multiple searchfield the terms are combined by AND.
  • With the fieldlist parameter of searchbox you can outut a select list with fields to search in.
  • You can combine min and max with the same field to find all entries within a range of these two values.

Results 1 - 2 of 2