Problem in list view of CDD checkboxes values

[dimoss]

Hi

I have a strange problem with a CDD element (checkboxes) which values doesn't show all in the list view.
Only the first 10 of the checked values are shown correctly.
If the users selects all the values only the 10 first will be shown.

I attach a screenshot of the problem



Any ideas about this?

Thanks

 

[troester]

Some string length issue?
Is it the same if you shorten the labels?

 

[dimoss]

Hi Troester

I don't think so. I have the same problem in another list where the CDD is Countries but in Repeated group.

 

[dimoss]

Hi again Troester

Maybe you are right...
I cut one label into half and it took all!
However how can I solve this string problem?
Thanks in advance!

 

[dimoss]

Yes...It's a string length problem.
When I revert the labels to normal and I had the same problem.
Is is something on the code which needs to be fixed?
Thanks!

 

[dimoss]

I played with the words and I saw that if the total number of the characters of all the selected labels are more than 252 the it cuts accordingly.

 

[troester]

Found it!
Enable "Big selects" in Fabrik options (Global).
It seems to be a MySQL restriction with GROUP-CONCAT

If you have lots of view joins and / or huge numbers of elements, you may see MySQL errors complaining about needing SQL_BIG_SELECTS enabled. Only enable this option if you get see such an error. This option also raises GROUP_CONCAT_MAX_LEN to 10k, which may be required if you use things like AJAX upload elements with lots of files.​

 

[dimoss]

Well Troester...
You are superb...
Many many thanks!!!

 

[cheesegrits]

I think it's probably time we just enabled that by default. I don't think using either of those options hurts performance to any detectable degree.

TBH, I thought I had set it to do this by default in the system plugin, but I guess not. Another one of those things I probably dreamed doing (yes, I write code in my dreams, kinda sad, LOL!).

-- hugh

 

[dimoss]

Hi Hugh

Code dreaming! You need to check it..;-)

Anyway just a little question on that. The problem with limited characters solved.
However when I click to see the record in details view I see nothing in the CDD element.
In the db level the value in the parent table is NULL.
Is it normal? Should the label been shown also in details view?

I attach the image


Thanks again!

 

[cheesegrits]

It's normal for it to have a NULL value when you are using checkbox display as that creates a separate map many to many map table to store the vales, and the original field on the parent table no longer stores anything.

However, it should show the labels in detail view. I'll take a look.

 

[dimoss]

Thanks for the fast reply Hugh.
I will wait for you to see what is the problem in details view.

 

[cheesegrits]

I can't replicate this. CDD's as checkboxes render as expected in details view.

http://screencast.com/t/n16rNhSGBFc

Is there anything "complicated" about your setup? Like do you have a where filter? is it in a repeat group?

And, as usual, are you running latest github?

-- hugh

 

[dimoss]

Hi Hugh

You run the demo in Fabrik 3.1.x or later for Joomla 3.x
However I speak for the Fabrik 3.0.x for Joomla 2.5.
That's why I posted it in this forum section.
And yes I have the latest github.
There is no complicated coding in my CDD and this is not on repeated group.
You can check the problem in my site PDAN for Fabrik 3.0.x
Login and check this list
http://pdan.alfaweb.gr/index.php?option=com_fabrik&view=list&listid=58&Itemid=242

Check the first three records..Try to view these records.

Thanks!

 

[dimoss]

Just FYI

If I choose Multi Select Dropdown works ok.