hi I have a customer table. I am able to fetch entity based on the customer ID, something like following:

UserEntity users = new UserEntity(userID); adapter.FetchEntity(...);

My question is how do we fetch entity based on a non-unique value? say we have a LastName column, and we want to fetch all user whose last name is "Johnson"? thanks

youkebb wrote:

My question is how do we fetch entity based on a non-unique value? say we have a LastName column, and we want to fetch all user whose last name is "Johnson"? thanks

Yes. The thing is: suppose there are 50 "Johnson"s. Which one of them do you want to fetch? So, yes, you have to reduce your filter, and maybe with sortExpression and Limit, you can reduce the fetch.