title: Glide Record query
body: <p>I am trying to build a custom application where in a table I have two fields role and rates. </p>
  
  <p>The table has three different row value. I am trying script include as glide record is not good way for custom application and I need to fetch the values like SQL query.</p>
  
  <pre><code>Select  rates from the table where role ='x'
  </code></pre>
  
  <p>and run this query to get all values in 3 different variable.</p>
  
  <ol>
  <li><p>I am trying to use GlideRecord in the scope application but getValue(); is returning (null) value</p>
  
  <pre><code>var role = new GlideRecord ('x_estimation_offsh_india_rates');
  x= role.getValue('roles');
  gs.info(x);`
  </code></pre>
  
  <p>What's wrong here ??</p>
  
  <p>I even tried get() but not working as I cannot use this for  all the values in the tables</p>
  
  <pre><code>var x;
  var role = new GlideRecord ('x_estimation_offsh_india_rates');
  role.get('role','it1');
  x=role.rates;
  gs.info(x);`
  </code></pre></li>
  <li><p>Also as the query result should be in  3 different variable I need some help how to multiple return values in script include</p></li>
  </ol>