(Pre)Filter issues with dbjoin and user element.

[troester]

See also https://github.com/Fabrik/fabrik/issues/403

Dbjoin element:
only possible to prefilter on dbjoin(raw), selecting dbjoin will use the same table column instead of the "label" column of the joined table

same problem with advanced search and dbjoin element set to filter=field
http://fabrikar.com/forums/showthread.php?t=29007

User element:
similar problem:
user element set to show username
prefilter is using WHERE (#_users.id='xxx')

 

[cheesegrits]

OK, think I've fixed both of those in github.

-- hugh

 

[cheesegrits]

OK, think I've fixed both of those in github.

-- hugh

 

[troester]

Yes, it's ok in prefilters now.

But still the issue in advanced search if a dbjoin element is set to filter = field.
It's ok in normal search (and ok in normal + advanced if filter=dropdown)
Example:
list test, j_liste= dbjoin to liste, filter=field

normal search on j_liste: WHERE ( `liste`.`feld1` LIKE '%alle%' )
advanced search on j_liste: WHERE ( `test`.`j_liste` LIKE '%alle%' )

 

[rob]

advanced search should now work in github as well.

Cheers
Rob