const where = {
social_sec_no: filter.ssn,
birth_date: filter.birthDate,
last_name: filter.lastName,
location: {
some: {
state: {equals: filter.state},
city: {equals: filter.city}
}
}};
let orderBy = [{last_name:'ASC'},{first_name:'ASC'}];
var searchBy = {
skip: filter.pageSize * filter.page,
take: filter.pageSize * 1,
where: where,
orderBy: orderBy
};
console.log(
searchBy = ${JSON.stringify(searchBy)}
);
const results = await this.prisma.person.findMany(searchBy); (edited)