select view
CommandOrder by: ⇔ Command

alphabox

{joodb alphabox}
thumb

Alphabox is replaced by a div with the classname pagination alphabox with a list containing all roman letters. With the linked letters you can select items by the first char of their titles.

Example

{joodb alphabox}

 

backbutton

{joodb backbutton}
thumb

Inserts an icon or text link into the single view. A click on that link navigates to the previous page.

Example

{joodb backbutton}

Note

    If you want a textlink instead of an icon you can change the icon-settings in JooDB-general options.

 

captcha

{joodb captcha}
thumb

Displays a small captcha where the user has to enter 5 letters before submitting the form.

Example

{joodb captcha}

Note

We do not use the built in cpatcha of Joomla 2.5

editbutton

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

editbutton (new with 2.7 pro) displays an icon or link to load the current entry into the form- or edit-view. The old automatic Notepad icon was removed.

Parameters 

  • COND (optional) - contition: if true the entry is loaded into the form view instead of the edit view.

Example

Search in Data

{joodb editbutton|true}

Notes

  • editbutton without condition true will be displayed only to special users if the are logged in. Edit in Frontend must be enabeld.
  • editbutton with condition true will be displayed only tu registed users with acces to the form if
    1. A userfield ID is defined wher the joomla user ID is stored.
    2. The current user ID matches with the id of this dataset.
  • See path2editform command

else

{joodb else}
thumb

Else negates the current output condition. {joodb else} must be in between an {joodb ifis} and {joodb endif} command.

Example

{joodb ifis|in_stock}
  • You can buy this product. {joodb field|in_stock} Unities are availiable
{joodb else}
  • This product is sold out
{joodb endif}

Prints a waring no more products are available.

endif

{joodb endif}
thumb

Endif ends an Ifis condition and enables the output regardless of the current condition.

Example

{joodb ifis|color|red}
  • The color is red like a firewagon
{joodb endif}

Prints a color definition.

exportbutton

{joodb exportbutton} »pro only«
thumb

Exportbutton displays an input-button with the classname button export to export the complete catalogue or the current search result as Excel-table.

Example

{joodb exportbutton}

Note

You can define the exported fields and the maximum rows at the joomla menuy-entry for your catalogue.

field

{joodb field|FIELDNAME|[length]}
thumb

Output of content of FIELDNAME. FIELDNAME must be the name of an existing Database field.

Some datatypes like (Date,Timestamp, Set, Enum) will be formated automatically be the system.

Parameters

  • FIELDNAME - Name of a field in your database
  • length (optional) - Maximum length of output for text files

Example

{joodb longtext|120}

Strips the text in longtext to 120 chars and adds thre points to the end...

Note: The old version with {joodb FELDNAME} without any command is deprecated

 

form

{joodb form|FIELDNAME|[parameters]}
thumb

Generates a formfield to the form-view. The formelement-types are dependent on the datafield-type. 

  • Varchar is displayed as a input-element. Possible parameters are "password" and "email". (For example {joodb form|usermail|email})
  • Text is displayed as a textbox. Possible parameter is "editor" to display Editor instead.
  • Enum and set fields are displayed as a select-element
  • Enum and set fields with less then 3 elements are displayed as a radio-element (enum) or checkbox (set)

Form validation is done automatically. If the value of a field can not be »Null« it is required.

Example

{joodb form|topic}
{joodb form|mail|email}
{joodb form|message}

{joodb captcha}

{joodb submitbutton}

Notes

  •  If a datafield can no NULL the form-element is marked as required.

groupselect

{joodb groupselect|FIELDNAME|[rows]|[use search]} »pro only«
thumb

Groupselect is part of the catalogue search options. Groupselect generates a select list of all existing values from the field FIELDNAME. Groupselect uses the current search filter to reduce the list of possible values. You can combine multiple Groupselects to allow complex parametric searches.

Parameters 

  • FIELDNAME - Name of a field in your database
  • rows (optional, integer) - Number of rows for a multiselect form element.
  • use search (optional, boolean, default no) - Apply the current search to the result. Note: this behaviour was changed with version 2.1.2

Example

Search electronic components

{joodb groupselect|voltage|5} {joodb groupselect|resistance|5} {joodb groupselect|price|5} {joodb groupselect|in_stock|5}

Search in electronic components combining multiple parameters

Notes

  • Fields used for parametric searches should type varchar or integer instead of text and indexed.


Page 1 of 4 Results 1 - 10 of 38