Arrow 
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Joomlapolis Forums  


Missing List Fields
Date: 2006/11/17 15:04 By: mtif Status: CB Doc subscriber  
Karma: 2  
Fresh Joomlapolitan

Posts: 19
graphgraph
I was mystified by the List feature, as I could sort and filter my lists using any of my fields, but could not include all of the fields in my lists - they just weren't there in the Field List for the columns.

I read a couple of (now locked) old posts of users with similar problems.

Anyhow I tracked down the reason. In administrator/components / com_comprofiler/admin.comprofiler.html.php

at around line 165 you will find

$database->setQuery( "SELECT f.fieldid, f.title, f.name"
. "nFROM #__comprofiler_fields f"
. "nWHERE f.published = 1 and f.profile = 1"

So to appear in the list a Field must be published AND in the profile. Sounds reasonable.

But I have lists that are just for Admin use, which need to include details that are not in public profile.

So I just deleted "and f.profile = 1" and hey presto I get all the fields to choose from in my lists.

I hope this helps others ....
Click here to see the profile of this user The topic has been locked.

CBSubs 1.0

CBSubs 1.0.3 released!

Find out more about the revolutionary new Joomla subscription system:

Info on CBSubs

CB 1.2.3 Documentation

Thank you bonus:

ProfileBook (+Blog) 1.2RC
ProfileGallery 1.2RC2
CB Privacy 1.0RC

What? Why? Where?

Click here for a yearly subscription: subscribe now

CB 1.2.3 Download

Community Builder 1.2.3
Stable and native for:
Joomla 1.5 & 1.0 & Mambo
(incl. CB 1.2.3 Installation pdf)
You need to be a registered member to download.

Full 180 pages updated
CB 1.2.3 documentation:
You need to be a CB doc subscriber to download.

CB Login