[SOLVED] userlist and $_CB_framework::displayedUser()

I have a CB field "cb_companydescription", which is a relatively long description of each user. I would like to create a CB user list that involves a truncated version of this field, say the first 100 characters.

I created another CB field in which I read the cb_companydescription from API and then truncate the resulted output:

Now this CB field works perfectly well if used inside CB profile, but when I try to use the field in my user list, $_CB_framework->displayedUser() always returns NULL.

Also, if I have a CB field with a substitution like this [cb:userdata field="username" user="#displayed" /], the field doesn't work in userlist.

1) Is there a way to use $_CB_framework::displayedUser() (or something similar) in a CB field that is used in a userlist?
or
2) Is there some other way to achieve what I'm trying to do?

I have the latest CB and Joomla 2.5.

thanks in advance

I suggest installing CB Query Field and simply using the below query to grab the fields value in a query field then adding the field to a column. Note it won't be searchable, you'll need to use the original field to search it.

Thank you so much, I got it working now. I'm quite new to Joomla & CB and I thought [user_id] always references to the user who is logged in, but that was a false assumption.

In case someone tries to copy/paste this SQL-query, I had to change the second parameter of SUBSTR from 0 to 1. I appreciate your quick response.