How to select a single record or a group of records using the SQLMap api

[Rubén V]

Hi,

I am trying to use the SQLMap api and I cannot find a way to select a single record or a group of records as is done by applying a filter with the "where" condition.

I appreciate an example of how to do it.

Thanks

[Shai Almog]

Hi,

you would do a regular select and pass an object with the primary key field set to the value you're looking for. This would always return one result.

This isn't elegant though. We should probably add a "findByPrimaryKey()" API.

[Rubén V]

Thanks