[SOLVED] Calculation of the redundancy of a field

Hi all,

I'm a french webmaster and I'm using CB 1.7 with the plugin cb_conditional in Joomla 1.5.23

I would like to add a conditional field that calculation the number of times the same value appear in a profil.

Here is an exemple:

Tab 1:

License 1, Group: Visu, Site name: Paris, ...
License 2, Group: Admin, Site name: Lorient, ...
License 3, Group: Visu, Site name: Marseille, ...

Tab 2 (this tab is in fact a summary):

Number of license type Visu : 2
Number of license type Admin : 1


Can I do that with cb_conditional ? or an other plugin ?

Thank's,
Best regards,
Arzor

CB Conditional is strictly for field/tab display based off field value. For example show Field A if Field B = Bob. It does not calculations like you're wanting. I believe you could use incubator project CB Query Field however and using a database SELECT query with this field perform your calculation.

Ok, I understand, but I have a problem.

If I use a SELECT query, the value in my 'calculation' field will be an addition of the specified value for the whole user in the table 'jos_comprofiler'...

So with this solution, I believe I can't isolate the value for just one user. Or not?

So with this solution, I believe I can't isolate the value for just one user. Or not?

You'd need to specify a WHERE in your query to `id` = [user_id].

So I try this but It doesn't work:

UPDATE TABLE jos_comprofiler SET cb_typearchivage =
(SELECT COUNT (*) FROM jos_comprofiler WHERE cb_groupe1 = 'Archiv.' AND cb_groupe2 = 'Archiv.'AND 'cb_groupe3 = 'Archiv.' AND 'id'= [69])
WHERE 'id' = [69]

Thank's

Why would you be doing an update? As I've explained the CB Query Field is specifically for performing SELECT queries and nothing more. Please see the below query as should do the trick.