**NAS_DB_OBJECTS**
rs1.prg_forums.field01, 1 , text
rs1.prg_forums.intfield01, 2 , int4
**NAS_DB_OBJECTS**
**NAS_SQL_OBJECTS**
**NAS_SELECT = SELECT field01, intfield01 FROM prg_forums**
**NAS_WHERE = WHERE (((user_right LIKE '|**NAS_USER**|') OR (group_right LIKE 'a') OR (group_right LIKE 'g' AND intfield06 IN (SELECT object_id FROM prg_forum_read WHERE ((user_right IS NULL) AND (group_right IS NULL)))) OR (group_right LIKE 'g' AND intfield06 IN (SELECT object_id FROM prg_forum_read WHERE (((user_right LIKE '|**NAS_USER**|') OR (group_right IN (|**memberingroups**|))))))))**
**NAS_ORDER = ORDER BY field01 ASC**
**NAS_MR = 200**
**NAS_NFC = maxRowSide**
**NAS_SQL_OBJECTS NAME=rs1**
**NAS_VO TYPE="RADIO" NAME="searchstring" DB_VALUE=all|single|string HTML_VALUES=Result has to contain all search pattern |Result has to contain one search pattern |Search for complete String REFERENZ=R1**
**NAS_VO TYPE="CHOICE" NAME="searchfield" DB_VALUE=subject|message|subjectandmessage|author HTML_VALUES=Title|Message|Title and message|Author REFERENZ=C1 JAVASCRIPT= class="select-normal" style="width: 300px"**
**NAS_VO TYPE="CHOICE" NAME="searchforum" NAS_SQL_REF=rs1.prg_forums.intfield01|rs1.prg_forums.field01|searchforum| REFERENZ=C2 FIRST_VALUE=all FIRST_NAME=All JAVASCRIPT=onChange="changeSearchArchviveCheckbox()"); style="width: 300px" ID="searchforum"**
**NAS_VO TYPE="CHECKBOX" NAME="searcharchive" DB_VALUE=yes HTML_VALUES= Also search in archive REFERENZ=CHECKBOX1 JAVASCRIPT= ID="searcharchive" **
Groupware - **OX_APP_TITLE**