#363 simple_type select

[Anonymous]

Simple Groupware version: 0.745
Simple Groupware language: de
PHP Version: 5.3.10-1ubuntu3.1
Database + Version: mysql 552
Server OS: Linux ubuntu02 3.2.0-24-generic #37-Ubuntu SMP Wed Apr 25 08:43:22 UTC 2012 x86_64
Webserver: Apache/2.2.22 (Ubuntu)
Webbrowser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1
APC cache usage: nicht installiert
Disk usage: 44 GB / 507 GB

Hello,

please have a look at the picture in attachment. I have 2 data tags filling a simple_type="select" with simple_size="1".
Whenever i add a where-clause in dbselect-function within the data-tag, it removes the searchbox.
Whenever i remove the first data-tag with where-clause, it completely removes the multi-line-select field.
I dont understand that behaviour.
How can i have a multi-line-select field with searchbox for simple_type="select" und simple_size="1" and where-clause in dbselect-function ?

Kind regards

Christian Hiller

[Anonymous]

[Thomas Bley]

Hello,

see http://www.simple-groupware.de/cms/SgsMLReference simple_size:
For simple type "select" and "dateselect", it defines the height of the select box (number of lines). If the value is greater than 1, multiple elements can be selected. If undefined, the default height is 3 lines.
For simple type "rating", it defines the maximum number of stars in the rating field. If undefined, the maximum is 5.
For simple type "files", it defines the maximum number of files that can be uploaded to the field in one asset. If undefined, an unlimited number of files can be uploaded.
example: simple_size="1"
used in: contacts.xml, tasks.xml (and more)

bye
Thomas

[Anonymous]

Hello,

Thx for answer. Actually i am talking about the second html-select field, the one that is filled with data. Why it only appears, if there is no where-clause in dbselect. The workaround is to have another data tag with different title andwithout where clause, but then the searchbox is missing.

Regards.

Christian Hiller

[Thomas Bley]

Hello,

works for me:
I created 16 contacts in folder=800.
Edited contactactivities.xml, replaced:
<data function="dbselect|simple_contacts|contactid,concat(lastname;' ';firstname)||lastname asc|10"/>
with:
<data function="dbselect|simple_contacts|contactid,concat(lastname;' ';firstname)|folder=800|lastname asc|10"/>

=> search box is still there in new/edit view
maybe you're missing the limit parameter (above "|10") and you matched less than 100 contacts (default).

bye
Thomas