Skip to Content Skip to Menu

dynamic filter dont work when selecting more then one value

  • krebsinfo
  • krebsinfo
  • OFFLINE
  • Posts: 13
  • Thanks: 1
  • Karma: 0
11 years 7 months ago #219888 by krebsinfo
I want a user to be assigned multiple groups and get displayed in different lists.
For this I use a new field with multiple selection. If the user is only assign to one value he is displayed in the list. If I assign a second value to the user, he will no longer appear in the same list.
What am I doing wrong? (I suppose that the SQL command is resolved incorrectly - see Attachment)

Ich möchte einem User mehrere Gruppen zuordnen und in verschiedenen Listen angezeigt bekommen.
Dazu verwende ich ein neues Feld mit Mehrfachauswahl. Wenn in dem User nur einen Wert zuordne, wird dieser in der Liste angezeigt. Wenn ich dem User einen zweiten Wert zuordne wird er in der gleichen Liste nicht mehr angezeigt.
Was mache ich da falsch? (Ich vermute, dass hier der SQL-Befehl falsch aufgelöst wird - siehe Attachment)

Community Builder (1.9)

Field:
Name: GSPSY
Drop Down (Multi-select)
All Parameters set standard (Alle Parameter auf Standardwerte)
Field-Values (Feld-WERTE): Wien, NOE, BGLD


Liste
Title (Titel): GSPWIEN
view Access Level: public (Öffentlich)
group (Benutzergruppen): public (Öffentlich)
Sort: Name (ASC)
Filter: GSPSY = WIEN (`cb_gspsy` ='Wien')

scenario1 (szenario1)
User
Name: Grupe94
Group (Gruppe): Öffentlich
Field (Feld): GSPSY -> selection (Auswahl) "Wien"

Result of the list (Ergebnis der Liste):
the user is displayed (der User wird angezeigt)

scenario2 (szenario2)
User
Name: Grupe94
Group (Gruppe): Öffentlich
Field (Feld): GSPSY -> selection (Auswahl) "Wien" & "NOE"

Result of the list (Ergebnis der Liste):
the user is NOT displayed (der User wird NICHT angezeigt)


System information
CB 1.9
Language (Sprache) German
PHP - Linux v2201201110237043.yourvserver.net 2.6.36.4-vs2.3.0.36.39-nc #3 SMP Thu Jun 28 07:58:40 UTC 2012 x86_64
Datenbankversion 5.1.49-3
Datenbankzeichensatz utf8_general_ci
PHP-Version 5.3.15-1~dotdeb.0
Webserver Apache/2.2.16 (Debian)
PHP-Interface für den Webserver apache2handler
Joomla!-Version Joomla! 2.5.8 Stable [ Ember ] 8-November-2012 14:00 GMT
Joomla!-Plattform-Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
Browsererkennung Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.56 Safari/537.17
Attachments:

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
11 years 7 months ago #220017 by nant
Most likely your dynamic filter is wrong on your userlist.

I have tested on my environment and I was able to filter just fine.

Please Log in or Create an account to join the conversation.

  • krebsinfo
  • krebsinfo
  • OFFLINE
  • Posts: 13
  • Thanks: 1
  • Karma: 0
11 years 7 months ago #220021 by krebsinfo
i posted description in pdf - did you look? you see only one filter in list, user has 2 values. when i selet only one he wil displayed, i select two he dont. what sould i made there wrong. your answer dose not animate me to buy this system. maybe your answer will be professional when i hav the payed system? so i wil get the professionla licence and ask again.

Please Log in or Create an account to join the conversation.

  • krebsinfo
  • krebsinfo
  • OFFLINE
  • Posts: 13
  • Thanks: 1
  • Karma: 0
11 years 7 months ago #220023 by krebsinfo
i payed now for professional!!!

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
11 years 7 months ago #220043 by nant

krebsinfo wrote: i payed now for professional!!!


Thanks for pro membership.

I deleted your previous post that has admin credentials posted for the world to see in order to protect your site.

If we need access credentials we will ask you to send them using a private message.

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
11 years 7 months ago #220045 by nant

krebsinfo wrote: i payed now for professional!!!


Thanks again for supporting us as a Professional member.

You can now download the CB Documentation from the Advanced Download area.
There is a section in it regarding user lists.
Please study and if you still have issues please post on the Professional support forums and we will assist asap.
The following user(s) said Thank You: krebsinfo

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum