Start page
Start page

Start page / Template development / Forms / Input components (deprecated) / OBJECTCHOOSER

CMS_INPUT_OBJECTCHOOSERAvailable up to FirstSpirit Version 5.0

Contents
for example
to the methods: Entity

CMS_INPUT_OBJECTCHOOSER

This input component can be used to select an individual data record from a data source. The selected data record is only a reference to the respective object in the Content Store. However, the data record can also be edited directly via the input component. For example: data records can be changed, new data records can be added to or no longer required data records can be deleted from the data source.

The clear discrimination between fields and buttons which are used for editing the contents of the data set and those which are used for editing the reference of the data set is emphasised by a special colouring of the elements of the input component, following the colour scheme of the respective store: green for elements of the Page Store, brown for elements of the Content Store.

Further functions: Using the button "Jump to" the editor can switch directly to the Content Store to edit the selected data set. Other sections which reference the data set can be displayed via "Show usages". Furthermore, language-dependent database contents can be displayed or hidden.

Access-API example use case
The exemplary implementation ObjectChooserEditorValueExample shows some simple examples of use for the reading, writing and creating access to the data object (ObjectChooserEditorValue) and its inner data container (Entity) of the input component by means of the FirstSpirit Access-API.

Important The input component CMS_INPUT_OBJECTCHOOSER is supported by the WebClient. For restrictions see chapter Restrictions in WebEdit.
name
Designator
Mandatory
table
TableTemplateReference
Mandatory
allowChoose
YesNo
Optional parameter
allowDelete
YesNo
Optional parameter
allowEdit
YesNo
Optional parameter
allowEmpty
YesNo
Optional parameter
allowNew
YesNo
Optional parameter
convertEntities
ConvertEntity
Optional parameter
hFill
YesNo
Optional parameter
hidden
YesNo
Optional parameter
noBreak
YesNo
Optional parameter
preset
Preset
Optional parameter
useLanguages
YesNo
Optional parameter
lang
LanguageAbbreviation
Mandatory
description
String
Optional parameter
expression
String
Optional parameter
label
String
Optional parameter

Parameter

The following table gives the parameters of the OBJECTCHOOSER input component.

ParameterMandatorySinceTypeDefault value
name*Yes3.1DesignatorNone
table*Yes3.0TableTemplateReferenceNone
allowChooseNo3.0YesNoYES
allowDeleteNo4.2YesNoNO
allowEditNo3.0YesNoYES
allowEmptyNo3.0YesNoYES
allowNewNo3.0YesNoYES
convertEntitiesNo2.0ConvertEntityNONE
hFillNo2.0YesNoNO
hiddenNo4.0.44YesNoNO
noBreakNo2.0YesNoNO
presetNo4.0PresetDEFAULT
useLanguagesNo2.0YesNoYES

name

The attribute "name" is the variable name of an input component with which the the result object of the input component can be used in the templates - with the help of $CMS_VALUE()$ - or the content can be output.

ParameterMandatorySinceTypeDefault value
name*Yes3.1DesignatorNone

table

The table parameter is used to give the reference to the table template.

The value given must be the unique identifier of the table template.

The reference is required to specify from which table selections can be made and which input components are to be displayed.

ParameterMandatorySinceTypeDefault value
table*Yes3.0TableTemplateReferenceNone

allowChoose

The allowChoose parameter can be used to specify whether existing content store data may be selected in the input component or not.

As a default, the selection of content store data is possible.

If allowChoose is given with NO (allowChoose="NO"), selection is not longer possible. Content store data can then only be added to the input components by creating new content store data.

ParameterMandatorySinceTypeDefault value
allowChooseNo3.0YesNoYES

allowDelete

Data sets can be deleted directly via this input component without having to switch to the respective data set in the Content Store using this attribute. With allowDelete="YES" the data set can be deleted from the input component and from the data source at the same time. By default, this parameter is set to NO.

ParameterMandatorySinceTypeDefault value
allowDeleteNo4.2YesNoNO

allowEdit

The allowEdit parameter can be used to allow as well as to prevent the editing of entries in the input component.

If the parameter is not given, the entries can be edited.

The editing of entries is made possible by specifying NO (...allowEdit="NO"...) not possible.

ParameterMandatorySinceTypeDefault value
allowEditNo3.0YesNoYES

allowEmpty

The "allowEmpty" parameter is used to specify whether a value has to be entered for an input value or not.

If allowEmpty="YES" input is not mandatory; however, it is if allowEmpty="NO".

Input components with allowEmpty="NO" are also called mandatory input components.

The default value for allowEmpty is YES.

ParameterMandatorySinceTypeDefault value
allowEmptyNo3.0YesNoYES

allowNew

The allowNew parameter can be used to allow as well as to prevent the creation of new entries.

If the parameter is not given, new entries can be created.

If NO (...allowNew="NO"...) is specified, no new entries can be created.

ParameterMandatorySinceTypeDefault value
allowNewNo3.0YesNoYES

convertEntities

The "convertEntities" attribute is used to convert special characters entered in the input components for output in HTML characters.

There are three forms:

  • convertEntities="NONE" (standard)
  • convertEntities="STANDARD"
  • convertEntities="QUOTE"

With the NONE form, no conversion rules whatsoever are applied.

If STANDARD is given the conversion rules in the "convert" area of the selected conversion rule of the presentation channel are applied.

The form QUOTE explicitly includes STANDARD too. However, the "quote" area of the conversion rule is also applied.

ParameterMandatorySinceTypeDefault value
convertEntitiesNo2.0ConvertEntityNONE

hFill

An input component is always displayed with a pre-defined width.

However, if the input component is to use the full available display width the parameter hFill must be given with the value YES .

ParameterMandatorySinceTypeDefault value
hFillNo2.0YesNoNO

hidden

With the "hidden" parameter an input component can be hidden from the editor.

If hidden="YES" the input component is not visible for the editor, if hidden="NO" it is visible.

The default value for hidden is NO.

ParameterMandatorySinceTypeDefault value
hiddenNo4.0.44YesNoNO

noBreak

The noBreak parameter can be used to suppress automatic line break after an input component.

The noBreak parameter must be given with value "YES" (noBreak="YES") to suppress the automatic line break.

ParameterMandatorySinceTypeDefault value
noBreakNo2.0YesNoNO

preset

Using the preset attribute the handling of default values in an input component can defined (see also chapter Default values). If preset="default" is set, the retrieval value defined in the form is used. If this value in the form is changed later on, these changes will be affect all usages of this default value in the input components maintained by the editor, as long as a value will be set manually in the input component. This is the default setting. If preset="copy" is set, the value entered by the editor is copied directly into the input component. Subsequent changes to the default value in the form do not have any effect on the usages of this default value in the input components maintained by the editor.

ParameterMandatorySinceTypeDefault value
presetNo4.0PresetDEFAULT

useLanguages

The useLanguages parameter can be used to specify whether or not an input component is to store different or deviating values for different languages (multi-lingual maintenance).

If the parameter is not given, deviating values are stored for the different languages as a default.

If NO (...useLanguages="NO") is specified, one value is stored for all languages.

ParameterMandatorySinceTypeDefault value
useLanguagesNo2.0YesNoYES

LANGINFOSAvailable from FirstSpirit Version 4.0

Using the tag LANGINFOS language-dependent information can be defined for each input component, e.g. which title is to be used for the input component in the different project languages (parameter label), which tooltip is to be displayed (parameter description) etc. For reasons of clarity, definitions which are identical in multiple languages will be merged. For example,

<LANGINFOS> 
<LANGINFO lang="*" label="Datum"/>
<LANGINFO lang="DE" label="Datum"/>
<LANGINFO lang="EN" label="Datum"/>
</LANGINFOS>

will be merged to

 <LANGINFOS> 
<LANGINFO lang="*" label="Datum"/>
</LANGINFOS>

after saving.

Available from FirstSpirit Version 4.2R2 Up to and including FirstSpirit version 4.2R2 language definitions will be deleted only in the case if the values are identical in all languages (as in example above). Furthermore, only the parameters lang, description and label are taken into account when merging.

Available from FirstSpirit Version 4.2R4 Since FirstSpirit version 4.2R4 all parameters are taken into account (e.g. format and length). Furthermore, language definitions are also merged within LANGINFOS tags, if they are identical in at least two languages. For example,

<LANGINFOS> 
<LANGINFO lang="*" label="Date" format="dd.MM.yy"/>
<LANGINFO lang="DE" label="Date" format="dd.MM.yy"/>
<LANGINFO lang="EN" label="Date" format="MM/dd/yy"/>
</LANGINFOS>

will become

 <LANGINFOS> 
<LANGINFO lang="*" label="Date" format="dd.MM.yy"/>
<LANGINFO lang="EN" label="Date" format="MM/dd/yy"/>
</LANGINFOS>

after saving.

The definition for the fallback value (*) will not be deleted in any case. If there are two or more language definitions with identical values the first one will be maintained, the other will be deleted.

Available from FirstSpirit Version 4.2R2 IMPORTANT: Up to and including FirstSpirit version 4.2R2 at least one definition for the fallback labelling ("*") must be given:

<LANGINFOS>
<LANGINFO lang="*" label="TEXT"/>
</LANGINFOS>

Available from FirstSpirit Version 4.2R4 From FirstSpirit version 4.2R4 the fallback definition can be omitted. In this case, the language which is defined first will be used automatically as fallback value. For example,

<LANGINFOS>
<LANGINFO lang="EN" label="Date"/>
<LANGINFO lang="DE" label="Datum"/>
</LANGINFOS>

will become

 <LANGINFOS> 
<LANGINFO lang="*" label="Date"/>
<LANGINFO lang="DE" label="Datum"/>
</LANGINFOS>

after saving.

LANGINFO

The LANGINFO tag is used to give values or attributes for a language as well for use as fallback values.

In order to state values or attributes for a language it is necessary to give the abbreviation of the project language in the lang parameter:

...
<LANGINFO lang="DE".../>
...

Fallback values are given with the special language abbreviation * ("for all languages"):

...
<LANGINFO lang="*".../>
...

The lang parameter is a mandatory parameter.

ParameterMandatorySinceTypeDefault value
lang*Yes3.1LanguageAbbreviationNone
descriptionNo3.1StringNone
expressionNo4.0StringNone
labelNo3.1StringNone

lang

The lang parameter is used to give the language abbreviation which is entered in the server properties see View document FirstSpirit Manual for Administrators, Chapter "Language templates") to specify for which project languages the definitions are to apply, e.g. DE for German, EN for English, FR for French etc. The following characters can be used as often as required: -, _, 0-9 and A-Z. Lower case letters are transformed automatically into upper case letters after having saved the template. In addition * can be used for fallback values.

ParameterMandatorySinceTypeDefault value
lang*Yes3.1LanguageAbbreviationNone

description

The description parameter can be used to give a description which is used to display a tool tip (mouse-over).

ParameterMandatorySinceTypeDefault value
descriptionNo3.1StringNone

expression

If the input component CMS_INPUT_OBJECTCHOOSER is used in the Content Store, the expression parameter can be used in the column overview to output values of a column from a table that is connected to the data source via a foreign key.

To do this, CMS_INPUT_OBJECTCHOOSER must be defined in a table A, which is in a 1:N foreign key relationship with table B. In the input component CMS_INPUT_OBJECTCHOOSER in the table template of table A, the table template of table B is referenced via the table parameter. Table A is therefore the target table (N elements), table B is the source table (1 element). CMS_INPUT_OBJECTCHOOSER must be linked with the foreign key.

In CMS_INPUT_OBJECTCHOOSER, it is then possible to use expression to draw on the values entered in the columns of table B.

The symbol objects #item and #row are available for this. These represent, e.g., the database row to be displayed of the table template defined by the table parameter. A column of the database row can be used for labeling, separated by a dot, e.g. as in the example #item.Country_EN.

Further, the expression mechanism is used to automatically set language-specific extensions should they be available, i.e. the following definition is possible:

<CMS_INPUT_OBJECTCHOOSER name="cs_objectchooser" table="Products.contacts">
<LANGINFOS>
<LANGINFO lang="*" label="Contact" expression="#item.Country_EN"/>
</LANGINFOS>
</CMS_INPUT_OBJECTCHOOSER>
Important It is necessary to ensure that the column name is given correctly and the column is also actually available in the given table, as otherwise no value will be displayed in the content overview.

ParameterMandatorySinceTypeDefault value
expressionNo4.0StringNone

label

The label parameter is used to give the surface labelling for input and visualisation components.

ParameterMandatorySinceTypeDefault value
labelNo3.1StringNone
Key

TableTemplateReference

The unique name of a table template, may only contain the characters "A-Z", "a-z", "0-9" and "_", e.g. "fr_st_varName"

LanguageAbbreviation

Language abbreviation, e.g. DE, EN, FR or * for return values

YesNo

Switch to apply an attribute or not

NOAvailable from FirstSpirit Version 2.0

Do not apply attribute

YESAvailable from FirstSpirit Version 2.0

Apply attribute

String

A random character string

Preset

Define the general preset modes.

DefaultAvailable from FirstSpirit Version 4.0

Retrieve default from definition, if no value is set.

CopyAvailable from FirstSpirit Version 4.0

Copy default from definition and save automatically.

ConvertEntity

Switch with which to define the conversion rule

NONEAvailable from FirstSpirit Version 2.0

Do not use any conversion rules

STANDARDAvailable from FirstSpirit Version 2.0

Use the conversion rules of the "convert" area

QUOTEAvailable from FirstSpirit Version 2.1

Use the conversion rules of the "convert" and "quote" area

Designator

Unique identifier of variable length; must start with a letter or underscore and may only contain the characters "A-Z", "a-z", "0-9" and "_", e.g. "fr_st_varName"

Example

An example of the input component "CMS_INPUT_OBJECTCHOOSER":

<CMS_INPUT_OBJECTCHOOSER useLanguages="NO" table="TABLE TEMPLATE" hFill="YES" name="IDENTIFIER">
<LANGINFOS>
<LANGINFO lang="*" label="TEXT" description="TEXT"/>
<LANGINFO lang="DE" label="TEXT" description="TEXT"/>
<LANGINFO lang="EN" label="TEXT" description="TEXT"/>
</LANGINFOS>
</CMS_INPUT_OBJECTCHOOSER>

© 2005 - 2014 e-Spirit AG | All rights reserved. | Last change: 2013-05-24