How do I get record with count of references from one to many? about sqlpp11 HOT 4 CLOSED

Thanks for the report and for figuring out a first solution.

select requires a where clause or an explicit hint that this is an unconditional request by calling .unconditionally(). This is to prevent folks to accidentally forget the where clause. And you should have seen a static assert saying calling where() or unconditionally() required.

So in your example, this would be written as

auto query = sqlpp::select(A.field, sqlpp::count(B.aId))
		.from(B.join(A).on(B.aId == A.id))
		.unconditionally()
		.group_by(A.field)
		;

I noticed that unconditionally is not documented in the /docs. Fixed that.

Thanks,
Roland

from sqlpp11.

I was able to get it in a bit dodgy way:

auto query = sqlpp::select(A.field, sqlpp::count(B.aId))
                .where(A.field.is_not_null())        // This helped, not sure why.
		.from(B.join(A).on(B.aId == A.id))
		.group_by(A.field)
		;

Seems .where(...) is needed, although .where(true) I tried first didn't work.
It would be great if this could be clarified.

from sqlpp11.

Thanks a lot for the quick answer and for clarification.
Regards!

from sqlpp11.

Thanks for the confirmation.

from sqlpp11.