Hi,

I have a table without relations, so I don't get a collection entity of this table, which means that I can't use the getscalar method.

Should I use the dbcount method?

Could someone please provide me example code to get the integer value for a query like this:

SELECT COUNT(*) FROM Customer WHERE country = "NL"

Thanks in advance.

Gr.,

G.I.

G.I. wrote:

I have a table without relations, so I don't get a collection entity of this table, which means that I can't use the getscalar method.

Every entity gets a collection class in selfservicing, that doesn't rely on if it has relations or not. You use selfservicing I presume? The collection should be there.

DUH...ok, there did I something stupid. Anyway, back to my original question:

I need to use the aggregate function CountRow, and a IPredicate filter, to filter on the country. In the function GetScalar, the only option to use a filter also includes using an Expression, but I don't know what expression to use there then...

Gr.,

G.I.

count(*) can be done using GetDbCount(). So you can use that to method, just pass in a FieldCompareValuePredicate which filters on country.

GetScalar's overloads which accept an Expression object, ignore the expression value if it's set to null / Nothing (see reference manual ). So if you don't want to apply an expression, just specific null / Nothing.

Thanks, I've got it now ... d*mn this product is so great, that I think to difficult to get it