Count calculation problem on checkbox element

[dimoss]

Hi,

I added a count calculation on a checkbox element, split by the same element.
It counts correctly but instead of the labels it shows the values.
J!3.8.3, F! Github from 6/12/2017
Maybe a possible bug?

Thanks!

 

[cheesegrits]

Very probably a bug, yes.

-- hugh

 

[dimoss]

Thanks Hugh!
If you find some free time maybe you can check it.

 

[cheesegrits]

Yes, I shall attempt to do that. You may need to bump this though, as I'm up to my eyeballs in J! 4.0 migration code atm.

-- hugh

 

[dimoss]

Friendly bump.

 

[cheesegrits]

Thanks for the reminder, I'll work on it today.

-- hugh

 

[dimoss]

Friendly bump.

 

[dimoss]

Friendly bump.

 

[cheesegrits]

Sorry, I've been working on this, but anything to do with calculations is a pain, the code is very opaque. I'll have another go at it today.

-- hugh

 

[cheesegrits]

Yeah, as I thought, it needed a nasty, hacky fix:

https://github.com/Fabrik/fabrik/commit/ba107ec26a1d13304a63e43b213c564f14d13d8f

Let me know.

-- hugh

 

[dimoss]

Hi Hugh,

Still doesn't work as expected.
See on this demo site
http://demo.alfaweb.gr/index.php?option=com_fabrik&view=list&listid=1&Itemid=110

It should calculate per single value and not per record values.

 

[cheesegrits]

Hi Hugh,

Still doesn't work as expected.
See on this demo site
http://demo.alfaweb.gr/index.php?option=com_fabrik&view=list&listid=1&Itemid=110

It should calculate per single value and not per record values.

Not sure what you mean. Also,are you grouping the list?

Sent from my Nexus 7 using Tapatalk

 

[dimoss]

Hi Hugh,

I don't use grouping. It's a simple list.
As I said it doesn't count the values. In our example should be something like:
Player: 2
Coach: 2
Medical: 1
Total: 5

 

[cheesegrits]

Oh, right. No, it won't work like that. The count query just counts unique values in the field, with "SELECT DISTINCT <pk>, <element_name>". Maybe once MySQL 5.7 is in wide use we could do some kind of clever JSON handling to break down the checkbox JSON values, but not now.

It might potentially work that way if you do a checkbox join, so the option are in a many-to-many join, although you'd need to test that.

-- hugh

 

[dimoss]

Ok Hugh.
Thanks for the explanation.