[SOLVED] Use field substitutions in advanced query userlist

Hi,

I use dynamic userlists on my site, and I have a question regarding using subsitution in the fields.

In earlier version this would work as an advanced filter in a userlist.

but now this does not work.

After a lot of trying and failing I searched the forum and found this one:

2960 CB 1.7.1 substitution check uses language string value instead of stored field value

I think my problem is the text returned from [cb_kategori]. It resolves to "IT / TV / Internet" , and therefor it somehow fails. Probably due to the spaces and-or / characters.

when debug my site I see it resolves to:
in earlier versions it would have resolved to:
any tips on how I can make this work again?

-K-

when debug my site I see it resolves to:

Correct, it now translates the values.

in earlier versions it would have resolved to:

We're still discussing whether this is a bug or not and if it needs fixing. It only affects select type fields such as radio, multi-checkbox, dropdown, and multi-dropdown.

any tips on how I can make this work again?

I suppose you can try retrieving the value with CB Query Field as it gives raw database value then try substituting that in.

Hi,

Your suggestion did work.

I created a new field CB Query Field "cb_kategoriRAW" , and substituted that in my advanced list filter.

The query I used was: SELECT cb_kategori FROM jos_comprofiler WHERE id = [user_id]

Thanks for the help.

Wonderful support as always

for me this issue is now solved, but maybe its an idea to include this in the documentation that the substitution behave different. If you follow the instructions as they are now it will not work. I think it was chapter 7 in the documentation, but I cant remember which page (and I dont have the documentation here right now).

-K-