Only returns one column from Db table for MSSQL select query

[sanjay-kanwar]

Hi There, I have a simple knex query and when i run the test with mock-knex i am only getting one table field information instead of all fields where as when i run the knex mssql query same code against actual MSSQL Db it returns all table fields. Below attach is the sample query.

   knex
          .from(tableName)
          .where("TEST", "TEST")
          .select()
          .then((objInstance)=>{
             return objInstance
          })

[sanjay-kanwar]

Sorry i am closing this issue i have found the solution now. this is what i have to add to get the desired result

tracker.on("query", (query) => {
      if (query.method === "insert") {
        query.response([{ fileName: "filedValue" }]);
      }
    });