Hi, I am using the below query. The parameter type is value(also tried using QueryString). And enclosed the value under value columns in quotes.
SELECT
[WorkCentre]–0
,[ProdOrder]–1
,[Material]–2
,[MatDescription]–3
,[DIFOTReqDlvDt]–37
,[DIFOTAckDlvDt]–38
,[DIFOTAckShipDt]–39
,[lastUpdated]–64
,[revenueTotal] ,
,[LengthExtra]–70
,[ALFExtra]
,[certificate]
,[OrderStatus]–86
,[OpenOrder]–87
,[Priority]–88
,[Complete]–89
FROM [TblExtOrders]
INNER JOIN
(
– SELECT B.Section,SUM(inDateRange) AS inDateRange,SUM(within28Days) AS within28Days FROM(
– SELECT TblExtOrders.Section ,count(TblExtOrders.Section) AS inDateRange,NULL AS within28Days FROM TblExtOrders WHERE 1=1 {whereInnerRange}
– GROUP BY TblExtOrders.Section
– UNION
SELECT TblExtOrders.Section,count(TblExtOrders.Section) AS within28Days FROM TblExtOrders WHERE 1=1 {whereOuterRange}
GROUP BY TblExtOrders.Section
– ) b GROUP BY b.Section
) AS B ON TblExtOrders.Section=B.Section WHERE 1=1
:whereAlloy
:whereState
:WhereFilter
:WhereProperty
But i am getting this error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘{’.
Can anyone suggest where am i going wrong?