This is an automated email from the ASF dual-hosted git repository.
rshah pushed a commit to branch 8.0.x
in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git
The following commit(s) were added to refs/heads/8.0.x by this push:
new e1a551e24e Fix broken deliveryservice_requests query parameter (#7893)
e1a551e24e is described below
commit e1a551e24eaccb6d66bb7ee33a6a10bd41b2d000
Author: Eric Holguin <[email protected]>
AuthorDate: Sat Jan 6 11:43:24 2024 -0700
Fix broken deliveryservice_requests query parameter (#7893)
fix where query statement
(cherry picked from commit a28af5a0e37fb8734a1e9caf7b342a7758d1d6a7)
---
traffic_ops/traffic_ops_golang/deliveryservice/request/requests.go | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/traffic_ops/traffic_ops_golang/deliveryservice/request/requests.go
b/traffic_ops/traffic_ops_golang/deliveryservice/request/requests.go
index 99f4ca4340..ea4f14ce3b 100644
--- a/traffic_ops/traffic_ops_golang/deliveryservice/request/requests.go
+++ b/traffic_ops/traffic_ops_golang/deliveryservice/request/requests.go
@@ -200,7 +200,7 @@ func Get(w http.ResponseWriter, r *http.Request) {
// TODO: add this functionality to the query builder in dbhelpers
if xmlID, ok := inf.Params["xmlId"]; ok {
- where = dbhelpers.AppendWhere(where,
"(r.deliveryservice->>'xmlId' = :xmlId) OR (r.original->>'xmlId' = :xmlId)")
+ where = dbhelpers.AppendWhere(where,
"((r.deliveryservice->>'xmlId' = :xmlId) OR (r.original->>'xmlId' = :xmlId))")
queryValues["xmlId"] = xmlID
}
