Updated the WebService class to use the new getSelectStatement() method in ServiceRequest

pborissow · pborissow · commit 220c6dcc9a2c · 2024-04-16T13:47:39.000-04:00
diff --git a/src/javaxt/express/WebService.java b/src/javaxt/express/WebService.java
@@ -409,8 +409,8 @@ private ServiceResponse list(Class c, ServiceRequest request, Database database)
 
 
       //Compile SQL statement
-        StringBuilder sql = new StringBuilder();
-        sql.append(request.getSelectStatement(tableName));
+        StringBuilder sql = new StringBuilder("select ");
+        sql.append(request.getSelectStatement(tablesAndFields));
         sql.append(" from ");
         sql.append(tableName);
         String where = request.getWhereStatement(tablesAndFields);
