<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc (version 1.7.0-google-v5) on Thu Dec 19 17:42:21 EST 2013 -->
<title>PqlUtils</title>
<meta name="date" content="2013-12-19">
<link rel="stylesheet" type="text/css" href="../../../../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="PqlUtils";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/DateUtils.html" title="class in com.google.api.ads.dfp.lib.utils.v201306"><span class="strong">Prev Class</span></a></li>
<li><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/ReportUtils.html" title="class in com.google.api.ads.dfp.lib.utils.v201306"><span class="strong">Next Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../../../../index.html?com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html" target="_top">Frames</a></li>
<li><a href="PqlUtils.html" target="_top">No Frames</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&nbsp;|&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li>Constr&nbsp;|&nbsp;</li>
<li><a href="#method_summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li>Constr&nbsp;|&nbsp;</li>
<li><a href="#method_detail">Method</a></li>
</ul>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<div class="subTitle">com.google.api.ads.dfp.lib.utils.v201306</div>
<h2 title="Class PqlUtils" class="title">Class PqlUtils</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>com.google.api.ads.dfp.lib.utils.v201306.PqlUtils</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<hr>
<br>
<pre>public final class <span class="strong">PqlUtils</span>
extends java.lang.Object</pre>
<div class="block">A utility class for handling PQL objects.</div>
<dl><dt><span class="strong">Author:</span></dt>
  <dd>api.arogal@gmail.com (Adam Rogal)</dd></dl>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
<!--   -->
</a>
<h3>Method Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static java.lang.String[]</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html#getColumnLabels(com.google.api.ads.dfp.v201306.ResultSet)">getColumnLabels</a></strong>(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/ResultSet.html" title="class in com.google.api.ads.dfp.v201306">ResultSet</a>&nbsp;resultSet)</code>
<div class="block">Gets the column labels for the result set.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static java.lang.String[]</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html#getRowStringValues(com.google.api.ads.dfp.v201306.Row)">getRowStringValues</a></strong>(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/Row.html" title="class in com.google.api.ads.dfp.v201306">Row</a>&nbsp;row)</code>
<div class="block">Gets the row values for a row of the result set in a the form of a string
 array.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static java.lang.Object[]</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html#getRowValues(com.google.api.ads.dfp.v201306.Row)">getRowValues</a></strong>(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/Row.html" title="class in com.google.api.ads.dfp.v201306">Row</a>&nbsp;row)</code>
<div class="block">Gets the row values for a row of the result set in the form of an object
 array.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html#getValue(com.google.api.ads.dfp.v201306.Value)">getValue</a></strong>(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/Value.html" title="class in com.google.api.ads.dfp.v201306">Value</a>&nbsp;value)</code>
<div class="block">Gets the underlying value of the <a href="../../../../../../../../com/google/api/ads/dfp/v201306/Value.html" title="class in com.google.api.ads.dfp.v201306"><code>Value</code></a> object.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html#resultSetToString(com.google.api.ads.dfp.v201306.ResultSet)">resultSetToString</a></strong>(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/ResultSet.html" title="class in com.google.api.ads.dfp.v201306">ResultSet</a>&nbsp;resultSet)</code>
<div class="block">Gets the result set as a table represenation in the form of:</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static java.util.List&lt;java.lang.String[]&gt;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html#resultSetToStringArrayList(com.google.api.ads.dfp.v201306.ResultSet)">resultSetToStringArrayList</a></strong>(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/ResultSet.html" title="class in com.google.api.ads.dfp.v201306">ResultSet</a>&nbsp;resultSet)</code>
<div class="block">Gets the result set as list of string arrays, which can be transformed to
 a CSV using <code>CSVWriter</code>.</div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method_detail">
<!--   -->
</a>
<h3>Method Detail</h3>
<a name="getValue(com.google.api.ads.dfp.v201306.Value)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getValue</h4>
<pre>public static&nbsp;java.lang.Object&nbsp;getValue(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/Value.html" title="class in com.google.api.ads.dfp.v201306">Value</a>&nbsp;value)
                                 throws java.lang.IllegalAccessException</pre>
<div class="block">Gets the underlying value of the <a href="../../../../../../../../com/google/api/ads/dfp/v201306/Value.html" title="class in com.google.api.ads.dfp.v201306"><code>Value</code></a> object.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>value</code> - the <code>Value</code> object to get the value from</dd>
<dt><span class="strong">Returns:</span></dt><dd>the underlying value</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalArgumentException</code> - if <code>value == null</code></dd>
<dd><code>java.lang.IllegalAccessException</code> - if the value field cannot be accessed</dd></dl>
</li>
</ul>
<a name="resultSetToStringArrayList(com.google.api.ads.dfp.v201306.ResultSet)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>resultSetToStringArrayList</h4>
<pre>public static&nbsp;java.util.List&lt;java.lang.String[]&gt;&nbsp;resultSetToStringArrayList(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/ResultSet.html" title="class in com.google.api.ads.dfp.v201306">ResultSet</a>&nbsp;resultSet)</pre>
<div class="block">Gets the result set as list of string arrays, which can be transformed to
 a CSV using <code>CSVWriter</code>.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>resultSet</code> - the result set to convert to a CSV compatible format</dd>
<dt><span class="strong">Returns:</span></dt><dd>a list of string arrays representing the result set</dd></dl>
</li>
</ul>
<a name="resultSetToString(com.google.api.ads.dfp.v201306.ResultSet)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>resultSetToString</h4>
<pre>public static&nbsp;java.lang.String&nbsp;resultSetToString(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/ResultSet.html" title="class in com.google.api.ads.dfp.v201306">ResultSet</a>&nbsp;resultSet)
                                          throws java.lang.IllegalAccessException</pre>
<div class="block">Gets the result set as a table represenation in the form of:

 <pre>
 +-------+-------+-------+
 |column1|column2|column3|
 +-------+-------+-------+
 |value1 |value2 |value3 |
 +-------+-------+-------+
 |value1 |value2 |value3 |
 +-------+-------+-------+
 </pre></div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>resultSet</code> - the result set to display as a string</dd>
<dt><span class="strong">Returns:</span></dt><dd>the string represenation of result set as a table</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalAccessException</code> - if the values of the result set cannot be
     accessed</dd></dl>
</li>
</ul>
<a name="getColumnLabels(com.google.api.ads.dfp.v201306.ResultSet)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getColumnLabels</h4>
<pre>public static&nbsp;java.lang.String[]&nbsp;getColumnLabels(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/ResultSet.html" title="class in com.google.api.ads.dfp.v201306">ResultSet</a>&nbsp;resultSet)</pre>
<div class="block">Gets the column labels for the result set.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>resultSet</code> - the result set to get the column labels for</dd>
<dt><span class="strong">Returns:</span></dt><dd>the string array of column labels</dd></dl>
</li>
</ul>
<a name="getRowValues(com.google.api.ads.dfp.v201306.Row)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRowValues</h4>
<pre>public static&nbsp;java.lang.Object[]&nbsp;getRowValues(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/Row.html" title="class in com.google.api.ads.dfp.v201306">Row</a>&nbsp;row)
                                       throws java.lang.IllegalArgumentException,
                                              java.lang.IllegalAccessException</pre>
<div class="block">Gets the row values for a row of the result set in the form of an object
 array.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - the row to get the values for</dd>
<dt><span class="strong">Returns:</span></dt><dd>the object array of the row values</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalArgumentException</code> - if the value could not be extracted from
     the row value</dd>
<dd><code>java.lang.IllegalAccessException</code> - if the row value could not be accessed</dd></dl>
</li>
</ul>
<a name="getRowStringValues(com.google.api.ads.dfp.v201306.Row)">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>getRowStringValues</h4>
<pre>public static&nbsp;java.lang.String[]&nbsp;getRowStringValues(<a href="../../../../../../../../com/google/api/ads/dfp/v201306/Row.html" title="class in com.google.api.ads.dfp.v201306">Row</a>&nbsp;row)
                                             throws java.lang.IllegalArgumentException,
                                                    java.lang.IllegalAccessException</pre>
<div class="block">Gets the row values for a row of the result set in a the form of a string
 array. <code>null</code> values are interperted as empty strings.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>row</code> - the row to get the values for</dd>
<dt><span class="strong">Returns:</span></dt><dd>the string array of the row values</dd>
<dt><span class="strong">Throws:</span></dt>
<dd><code>java.lang.IllegalAccessException</code></dd>
<dd><code>java.lang.IllegalArgumentException</code></dd>
<dd><code>java.lang.IllegalArgumentException</code> - if the value could not be extracted from
     the row value</dd>
<dd><code>java.lang.IllegalAccessException</code> - if the row value could not be accessed</dd></dl>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/DateUtils.html" title="class in com.google.api.ads.dfp.lib.utils.v201306"><span class="strong">Prev Class</span></a></li>
<li><a href="../../../../../../../../com/google/api/ads/dfp/lib/utils/v201306/ReportUtils.html" title="class in com.google.api.ads.dfp.lib.utils.v201306"><span class="strong">Next Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../../../../index.html?com/google/api/ads/dfp/lib/utils/v201306/PqlUtils.html" target="_top">Frames</a></li>
<li><a href="PqlUtils.html" target="_top">No Frames</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&nbsp;|&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li>Constr&nbsp;|&nbsp;</li>
<li><a href="#method_summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li>Constr&nbsp;|&nbsp;</li>
<li><a href="#method_detail">Method</a></li>
</ul>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</body>
</html>
