[SOLVED] Viewing field value content across users in a collected list

Hi,

1. Viewing field value content across users in a collected list – something like Joomla article list

I would like to show value results entered in selected fields across all users. This value result should be published (if content entered by user) in a list view. This list should then contain link to the web address or file, etc. in CB.

Example: PDF drawings of houses - allocated to a required field, from each individual user.
Instead of entering each user to see the drawing I would like to generate a list view based on the entered content in the selected field(s).

Columns in the list view could be:

1. Title (of the field content) - working as link to the content
2. Date of entering
3. Author (User profile) - working as a link to the user
4. Hits
5. Rating
6. etc

Like the article list view in Joomla.

Is this possible somehow?

Thanks for you support.

Sounds like a regular userlist with your respective fields in each column. Suggest reading the CB Primer Book to get started with userlists. You can also check out CBs videos below.

www.youtube.com/playlist?list=PLp0puRITgC7PuyzPsMUECDI46VE7IFSAX

Hi again,

Thanks Kyle.

I have created an additional user list and allocated it to a new menu – ok
I have allocated four different fields (the ones containing the PDF drawings content I want to show), to the first user list column. I call this column title. Further to this I have; User, user image and user hits in different columns. ok.

I am now trying to solve the following, without luck so far:

1. I only want to show the users in the list, if one of the four fields allocated to title are with any content. How can set this up?
2. I would like to have a column with the edit/upload/publish date related to these same four fields. Is that possible?
3. I would like to have a column with the hits related to these same four fields. Is that possible?
4. I would like to have a column with a rating option related to these same four fields. Is that possible?

Thank you.

1. I only want to show the users in the list, if one of the four fields allocated to title are with any content. How can set this up?

You need to setup a filter to exclude users. I'm guessing you're just using a file field so filtering out users where that field is not empty should work.

2. I would like to have a column with the edit/upload/publish date related to these same four fields. Is that possible?

Individual fields don't have an edit date. You can use the last update date field though to show when their profile was last updated by them.

3. I would like to have a column with the hits related to these same four fields. Is that possible?

There is no hits counter for individual fields. You can use the hits field though, which is profile views.

4. I would like to have a column with a rating option related to these same four fields. Is that possible?

Rating fieldtype is built into CB. Simply create a rating field within CB > Field Management.

Hi again,

1. I only want to show the users in the list, if one of the four fields allocated to title are with any content. How can set this up?

You need to setup a filter to exclude users. I'm guessing you're just using a file field so filtering out users where that field is not empty should work.

MZ: I guess you mean the filter function in the user list setup? I have been trying to play around with different "operator" functions but it does not work right. Empty or not empty operators does not exist.
I have 2 fields showing web address links and two file attachments. These field contents are again controlled by a dropdown field...
??

2. OK
3. OK
4. OK will try that later

Thanks.

MZ: I guess you mean the filter function in the user list setup? I have been trying to play around with different "operator" functions but it does not work right. Empty or not empty operators does not exist.

The Basic mode only supports AND filters. You're needing an OR case. To do that you need to use an Advanced filter and supply the SQL your self. Example as follows.


Adjust the field names cb_field_NUMBER as needed. Add more OR cases as needed. Depending on your fields type you may need to adjust the conditions (e.g. if it's a checkbox field the value can be 1, 0, or NULL).