-
Notifications
You must be signed in to change notification settings - Fork 131
Open
@jdshah98
Description
While executing query with r2dbcEntityTemplate and with binding null query takes a lot of time and it fails
Anyone can help in this scenario?
SELECT
A.NAME,
A.BRANCH,
A.CITY,
A.MECHANISM,
B.DESCRIPTION
FROM
MainBank A
LEFT JOIN Payscale B ON
A.PAYMECH = B.REDDIVCODE
LEFT JOIN CUSTOMER C ON
A.ID = C.ID
WHERE
(:mobile IS NULL OR C.MOBILE = :mobile)
AND
(:city IS NULL OR A.CITY = :city)