[SOLVED] Query Field with sql math functions and cb_field values

Hello,

I need to calculate the value of a field automatically.
The calculated value depends on some basic math functions and two other cb_fields.

My current query is:

The given result is always "228" :pinch:
But when I replace the 'cb_fields' with "normal" numbers, it works. So it seems I simply do not get the field values.

How can I get the numeric values of these two cb fields in query to get the correct results?
I don't know what I've overseen :silly: :silly:


Thanks in forward

You're using single quote (') instead of back quote (`). That means it's seeing those field names as literal strings instead of as table columns.

thank you very much.
How could I have overlooked that? : D


In this case I have a further question.
Isn't it possible to get a value in a query field from another query field?

"cb_calc_anzahlazubis" is a field which counts all active users with profile type "a". So i created a query field which selects all "approved" where profiletype=a.

But i can't access the counted users field directly in my query field above.
I had to create another field which sets the value via auto actions.

When I try to calculate with the first query field i get an 1054 Error - Unknown Column.
Is this right or do i have missed something?

Isn't it possible to get a value in a query field from another query field?

Yes, you can use substitutions in the query field query. Both "Raw Field Value" ([cb:userdata field="FIELD_NAME" /]) and "Original Field Value" ([cb:userfield field="FIELD_NAME" /]) usages should work.

When I try to calculate with the first query field i get an 1054 Error - Unknown Column.
Is this right or do i have missed something?

Query fields don't have storage so they don't have a database column.

great!
thank you!

problem solved