Using field's suffix in the select query???

Posted by MaciejA on 22-May-2015 08:19

Hi,

I'm trying to get three values from the following select query:

SELECT stage#value, count(id), stage#id FROM projects GROUP BY stage#value

In the first and second field I'm receiving what I want, but then in the third field, query is returning the same values as in the first one. Instead of value I want to get id of that field as a third field. Is it possible?

Regards,

MA

Rollbase - Forum
Posted by MaciejA on 22-May-2015 11:22

Hi,

Thank you. I manged to get what I want with the rbf_getPicklist function.

Regards,

MA

All Replies

Posted by pvorobie on 22-May-2015 11:13

Only fields in SELECT list may have suffixes which determine how results will be formatted. This does not apply to GROUP BY clause.

Posted by MaciejA on 22-May-2015 11:22

Hi,

Thank you. I manged to get what I want with the rbf_getPicklist function.

Regards,

MA

This thread is closed