I can post the query if anyone has a second to look. I have the query running with a queryRaw and am trying to convert to Prisma.

Hi @Samuel Proschansky 👋 Are you still having this issue? Can you share the query?

Hey Raphael, I can share the query, but I think there isn't a way around it from what I can see. It has to do with the size of the data.

Hi @Samuel Proschansky, Apologies for not getting back to you on this, Can you please share the raw query as well?

SELECT ${sLimit}

C.id,

C.fname AS firstname,

C.lname AS lastname,

C.fname + ' ' + C.lname AS fullname,

C.Phone AS phone,

C.Address1 AS address1,

C.Address2 AS address2,

C.City AS city,

C.State AS state,

C.County as county,

C.Zip AS postalcode,

C.MEDICAID AS medicaid,

C.ESRD as esrd,

C.KeyCode as keycode,

C.INSERT_DATE AS createdat,

C.UPDATE_DATE AS modifiedat,

CAST(C.SNP as bit) as snp,

P.Fname AS agentfirstname,

P.Lname AS agentlastname,

P.FNAME + ' ' + P.LNAME AS agentfullname,

P.USERNAME AS agentusername,

PL.isActive as agentisactive,

AUG.ID as agentusergroupid,

AUG.groupName as agentusergroup,

CL.STATUS_ID as statusid,

CS.STATUS_TYPE_ID as statustypeid,

CL.CONSENT_STATUS_ID as consentstatusid,

CL.PermissionToContact AS permissiontocontact,

CL.people_id AS agentid,

CL.Client_Member_ID as memberid,

CL.MemberStatusID as memberstatusid,

CL.CAMPAIGN_ID as campaignid,

CL.INSERT_DATE AS contactlob_createdat,

CL.UPDATE_DATE AS contactlob_modifiedat,

CMP.DESCRIP as campaigndescription,

CMP.CAMP_TYPE_ID as campaigntypeid,

CMPS.SEASON as campaignseason,

DNIS.DNIS as campaigndnis

FROM dbo.contact C

INNER JOIN dbo.Contact_LOB CL ON CL.Contact_ID = C.ID

INNER JOIN dbo.contact_status CS ON CS.id = CL.status_id AND CS.Renewal_Status_ID = CL.Renewal_Status_ID

INNER JOIN dbo.PEOPLE P on P.ID = CL.people_id

INNER JOIN dbo.PEOPLE_LOB PL ON PL.People_ID = P.ID

`${peopleID ? Prisma.sql`INNER JOIN dbo.CurrentOrgTable AS CurrentOrgTable ON CurrentOrgTable.peopleid = p.ID AND CurrentOrgTable.ParentID = ${Number(`

peopleID

)}

: Prisma.empty}`

LEFT OUTER JOIN Usergroups AUG on P.Usergroup_ID = AUG.ID

LEFT OUTER JOIN dbo.CAMPAIGNS CMP ON CMP.ID = CL.CAMPAIGN_ID

LEFT OUTER JOIN dbo.CAMPAIGN_SEASON CMPS ON CMPS.ID = CMP.CAMPAIGN_SEASON_ID

LEFT OUTER JOIN dbo.DNIS DNIS ON DNIS.ID = CMP.DNIS_ID

WHERE CL.status_id <> 12

`${ids.length ? Prisma.sql`AND C.id in (${IDs})` : Prisma.empty}` `${firstname && !ids.length ? Prisma.sql`AND C.fname LIKE ${firstname}`: Prisma.empty}` `${lastname && !ids.length ? Prisma.sql`AND C.lname LIKE ${lastname}`: Prisma.empty}` `${dob && !ids.length ? Prisma.sql`AND C.DOB LIKE ${dob}`: Prisma.empty}` `${memberID && !ids.length ? Prisma.sql`AND CL.Client_Member_ID=${memberID}`: Prisma.empty}`

GROUP BY C.id, C.fname, C.lname, C.Phone, CL.PermissionToContact, CL.people_id, CL.Client_Member_ID, C.Address1, C.Address2, C.City, C.State, C.County, C.Zip, P.Fname, P.Lname, P.USERNAME, AUG.ID, AUG.groupName, PL.isActive

,CL.STATUS_ID, CS.STATUS_TYPE_ID, CL.CONSENT_STATUS_ID, CL.MemberStatusID, CL.CAMPAIGN_ID, CMP.DESCRIP, CMP.CAMP_TYPE_ID, CMPS.SEASON, DNIS.DNIS, C.MEDICAID, C.SNP, C.ESRD, C.KeyCode, C.INSERT_DATE, C.UPDATE_DATE, CL.INSERT_DATE, CL.UPDATE_DATE

`ORDER BY C.lname,C.fname, CL.people_id``

Thanks for sharing, I'll take a look at this and get back to you.