title: How to show proper json response from Scala controller class?
body: <p>I am trying to get json response from Postgresql database(v9.5) table to display on my view page, I have tried the following, as my application is executing fine, but I am not getting/displaying my required proper json data(as it is containing: Stream, slashes() and question mark(?), like Stream type json). Please let me know that how to show my desired output like below ?
  my output: </p>
  
  <pre><code>Stream("[{\"_testid\":{\"testid0\":\"testnumber\"},\"testtitle\":\"TestTitle\"}]", ?)
  </code></pre>
  
  <p>but my desired output: </p>
  
  <pre><code>[{"_testid":{"testid0":"testnumber"},"testtitle":"TestTitle"}]
  </code></pre>
  
  <p>contorller:</p>
  
  <pre><code>class Test extends Controller {
      def getTest = Action { 
      var sql: SqlQuery = SQL("select name::TEXT from test");
      def values: String =  DB.withConnection { implicit connection =&gt; 
      sql().map(row =&gt; row[String]("name")).toString
      }
      Ok(values)
      }
  </code></pre>
  
  <p>table:</p>
  
  <pre><code>create table test(
      id serial primary key,
      name json not null);
  </code></pre>