returns the name of a “zeitschriftentitel” to a given id, based on the database “zeitschriftentitel”, which is queried realtime. (no caching)

[% get_extra('zeitschrifttitel',12) %]
[% extra.zeitschrifttitel %]<br>
[% get_extra('zeitschrifttitel',122) %]
[% extra.zeitschrifttitel %]<br>

if there is no entry for the supplied id in the database then the value “Unbekannter Titel” will be returned.

parameters: table, id

for a given id of any entry in any struktudatenbank this functions returns the id of the associated “landesverband”.

example:

[% get_extra('get_landesverband','strukturaktuell',10219) %]

will store the id of the “landesverband” in the variable

[% extra.get_landesverband %]

returns a list of all bundesländer. First element in the list is “not valid” and last element is “östereichweit”. The index of the list correlates to the bundesländer-id delivered from the stukturdaten-databases

splits the “personen”-field in the “strukturdaten”-tables into its components. [% extra.splid_sd_p.X.Y %] will give you the Yth attribute of the Xth person.

gives you the “next” element to a given element, according to our defaultorder: bundesland, status, name. As Argument the name of the database and “current” element and a stay_in_bundesland-flag is taken and the next element (only the id,name,status,bundesland) can be accessed as any other return of a get_data-query using db.next.data.0

Note that you can also get the next element in all strukturdaten-databases by specifying “wholelist_sd” or 0 as name of the database.

Note that specifying 1 as fourth argument (stay_in_bundesland_flat) means, that only a institution in the actual bundesland are returned.

Note that you can specify an id instead of the “current” element and the engine will get the needed information by itself.

example (we assume that the current element was already retrieved using a get_data-statement like [% get_data(’vollansicht’,’struktur2000’,0,’id=23’) %]

[% get_extra('next_sd','struktur2000',db.vollansicht.db.0 %]
next id is : [% db.next.data.0.id %]

note that db.next.data.0 is undefined if there is no next element.

get_extra('next_sd',0,db.vollansicht.db.0,1)\\
get_extra('next_sd','wholelist_sd',db.vollansicht.db.0)\\
get_extra('next_sd','wholelist_sd',216)\\
get_extra('next_sd','struktur2000',216)\\

like next_sd, but finds the previous element and sets db.prev.data.0

as luxury, this is like calling next_sd and prev_sd :)

creates a whole list over all institutions in past, current and future strukturdaten-databases (as defined in str_ana_datenbanken). No Arguments needed. The list of all institutions is returned in db. An optional Argument specifies the Bundesland to query.
Note that only id, name, bundesland and status are actually queried

like wholelist_sd but for the new structure introduced in 2010

ONLY VALID FOR THE NEW 2010-structure

creates a list of all years that exists in struktur-database. empty or null is returned for “aktuelles jahr”