| <!DOCTYPE HTML> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (11.0.2) on Mon Mar 18 14:01:21 MSK 2019 --> |
| <title>ColumnSelect (cayenne-doc: Cayenne Documentation 4.1.B1 API)</title> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <meta name="dc.created" content="2019-03-18"> |
| <link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style"> |
| <link rel="stylesheet" type="text/css" href="../../../../jquery/jquery-ui.css" title="Style"> |
| <script type="text/javascript" src="../../../../script.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jszip/dist/jszip.min.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script> |
| <!--[if IE]> |
| <script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script> |
| <![endif]--> |
| <script type="text/javascript" src="../../../../jquery/jquery-3.3.1.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jquery-migrate-3.0.1.js"></script> |
| <script type="text/javascript" src="../../../../jquery/jquery-ui.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="ColumnSelect (cayenne-doc: Cayenne Documentation 4.1.B1 API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var data = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"i7":10,"i8":10,"i9":10,"i10":10,"i11":10,"i12":10,"i13":10,"i14":10,"i15":10,"i16":10,"i17":10,"i18":10,"i19":10,"i20":10,"i21":10,"i22":10,"i23":10,"i24":10,"i25":10,"i26":10,"i27":10,"i28":10,"i29":10,"i30":10,"i31":10,"i32":10,"i33":10,"i34":10,"i35":10,"i36":10,"i37":10,"i38":10,"i39":10,"i40":10,"i41":10,"i42":10}; |
| var tabs = {65535:["t0","All Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| var pathtoroot = "../../../../"; |
| var useModuleDirectories = true; |
| loadScripts(document, 'script');</script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <header role="banner"> |
| <nav role="navigation"> |
| <div class="fixedNav"> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a id="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../index.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/ColumnSelect.html">Use</a></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 class="aboutLanguage"><a href="http://cayenne.apache.org" target="top">Apache Cayenne</a></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../allclasses.html">All Classes</a></li> |
| </ul> |
| <ul class="navListSearch"> |
| <li><label for="search">SEARCH:</label> |
| <input type="text" id="search" value="search" disabled="disabled"> |
| <input type="reset" id="reset" value="reset" disabled="disabled"> |
| </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> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li>Field | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a id="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| </div> |
| <div class="navPadding"> </div> |
| <script type="text/javascript"><!-- |
| $('.navPadding').css('padding-top', $('.fixedNav').css("height")); |
| //--> |
| </script> |
| </nav> |
| </header> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <main role="main"> |
| <div class="header"> |
| <div class="subTitle"><span class="packageLabelInType">Package</span> <a href="package-summary.html">org.apache.cayenne.query</a></div> |
| <h2 title="Class ColumnSelect" class="title">Class ColumnSelect<T></h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">java.lang.Object</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="IndirectQuery.html" title="class in org.apache.cayenne.query">org.apache.cayenne.query.IndirectQuery</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="FluentSelect.html" title="class in org.apache.cayenne.query">org.apache.cayenne.query.FluentSelect</a><T></li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.apache.cayenne.query.ColumnSelect<T></li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <dl> |
| <dt>All Implemented Interfaces:</dt> |
| <dd><code><a href="https://docs.oracle.com/javase/8/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io" class="externalLink">Serializable</a></code>, <code><a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code>, <code><a href="Select.html" title="interface in org.apache.cayenne.query">Select</a><T></code></dd> |
| </dl> |
| <hr> |
| <pre>public class <span class="typeNameLabel">ColumnSelect<T></span> |
| extends <a href="FluentSelect.html" title="class in org.apache.cayenne.query">FluentSelect</a><T></pre> |
| <div class="block"><p>A helper builder for queries selecting individual properties based on the root object.</p> |
| <p> |
| It can be used to select properties of the object itself, properties of related entities |
| or some function calls (including aggregate functions). |
| </p> |
| <p> |
| Usage examples: <pre> |
| <code> |
| // select list of names: |
| List<String> names = ObjectSelect.columnQuery(Artist.class, Artist.ARTIST_NAME).select(context); |
| |
| // select count: |
| long count = ObjectSelect.columnQuery(Artist.class, Property.COUNT).selectOne(); |
| |
| // select only required properties of an entity: |
| List<Object[]> data = ObjectSelect.columnQuery(Artist.class, Artist.ARTIST_NAME, Artist.DATE_OF_BIRTH) |
| .where(Artist.ARTIST_NAME.like("Picasso%)) |
| .select(context); |
| </code> |
| </pre> |
| </p> |
| <p><b>Note: this class can't be instantiated directly. Use <a href="ObjectSelect.html" title="class in org.apache.cayenne.query"><code>ObjectSelect</code></a>.</b></p></div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.0</dd> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="ObjectSelect.html#columnQuery(java.lang.Class,org.apache.cayenne.exp.Property)"><code>ObjectSelect.columnQuery(Class, Property)</code></a>, |
| <a href="../../../../serialized-form.html#org.apache.cayenne.query.ColumnSelect">Serialized Form</a></dd> |
| </dl> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <ul class="blockList"> |
| <li class="blockList"><a id="fields.inherited.from.class.org.apache.cayenne.query.FluentSelect"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.cayenne.query.<a href="FluentSelect.html" title="class in org.apache.cayenne.query">FluentSelect</a></h3> |
| <code><a href="FluentSelect.html#cacheGroup">cacheGroup</a>, <a href="FluentSelect.html#cacheStrategy">cacheStrategy</a>, <a href="FluentSelect.html#dbEntityName">dbEntityName</a>, <a href="FluentSelect.html#entityName">entityName</a>, <a href="FluentSelect.html#entityType">entityType</a>, <a href="FluentSelect.html#limit">limit</a>, <a href="FluentSelect.html#offset">offset</a>, <a href="FluentSelect.html#orderings">orderings</a>, <a href="FluentSelect.html#pageSize">pageSize</a>, <a href="FluentSelect.html#prefetches">prefetches</a>, <a href="FluentSelect.html#statementFetchSize">statementFetchSize</a>, <a href="FluentSelect.html#where">where</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="fields.inherited.from.class.org.apache.cayenne.query.IndirectQuery"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.cayenne.query.<a href="IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></h3> |
| <code><a href="IndirectQuery.html#dataMap">dataMap</a>, <a href="IndirectQuery.html#lastResolver">lastResolver</a>, <a href="IndirectQuery.html#name">name</a>, <a href="IndirectQuery.html#replacementQuery">replacementQuery</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.summary"> |
| <!-- --> |
| </a> |
| <h3>Constructor Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Constructors</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier</th> |
| <th class="colSecond" scope="col">Constructor</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>protected </code></td> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">ColumnSelect</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>protected </code></td> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(org.apache.cayenne.query.ObjectSelect)">ColumnSelect</a></span>​(<a href="ObjectSelect.html" title="class in org.apache.cayenne.query">ObjectSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> select)</code></th> |
| <td class="colLast"> |
| <div class="block">Copy constructor to convert ObjectSelect to ColumnSelect</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| </section> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <table class="memberSummary"> |
| <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Method</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#and(java.util.Collection)">and</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>> expressions)</code></th> |
| <td class="colLast"> |
| <div class="block">AND's provided expressions to the existing WHERE or HAVING clause expression.</div> |
| </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#and(org.apache.cayenne.exp.Expression...)">and</a></span>​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>... expressions)</code></th> |
| <td class="colLast"> |
| <div class="block">AND's provided expressions to the existing WHERE clause expression.</div> |
| </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#avg(org.apache.cayenne.exp.Property)">avg</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</code></th> |
| <td class="colLast"> |
| <div class="block">Select average value of property</div> |
| </td> |
| </tr> |
| <tr id="i3" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheGroup(java.lang.String)">cacheGroup</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy)">cacheStrategy</a></span>​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i5" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy,java.lang.String)">cacheStrategy</a></span>​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i6" class="altColor"> |
| <td class="colFirst"><code>protected <E> <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><E></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#column(org.apache.cayenne.exp.Property)">column</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><E> property)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i7" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#columns(java.util.Collection)">columns</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?>> properties)</code></th> |
| <td class="colLast"> |
| <div class="block">Add properties to select.</div> |
| </td> |
| </tr> |
| <tr id="i8" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)">columns</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> firstProperty, |
| <a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?>... otherProperties)</code></th> |
| <td class="colLast"> |
| <div class="block">Add properties to select.</div> |
| </td> |
| </tr> |
| <tr id="i9" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#count()">count</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Shortcut for <a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a> columns}(Property.COUNT)</div> |
| </td> |
| </tr> |
| <tr id="i10" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#count(org.apache.cayenne.exp.Property)">count</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</code></th> |
| <td class="colLast"> |
| <div class="block">Select COUNT(property)</div> |
| </td> |
| </tr> |
| <tr id="i11" class="rowColor"> |
| <td class="colFirst"><code>protected <a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#createReplacementQuery(org.apache.cayenne.map.EntityResolver)">createReplacementQuery</a></span>​(<a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a> resolver)</code></th> |
| <td class="colLast"> |
| <div class="block">Translates self to a SelectQuery.</div> |
| </td> |
| </tr> |
| <tr id="i12" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dbEntityName(java.lang.String)">dbEntityName</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dbEntityName)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets the <a href="../map/DbEntity.html" title="class in org.apache.cayenne.map"><code>DbEntity</code></a> name to fetch without changing the return type |
| of the query.</div> |
| </td> |
| </tr> |
| <tr id="i13" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#distinct()">distinct</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Explicitly request distinct in query.</div> |
| </td> |
| </tr> |
| <tr id="i14" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#entityName(java.lang.String)">entityName</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> entityName)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets the <a href="../map/ObjEntity.html" title="class in org.apache.cayenne.map"><code>ObjEntity</code></a> name to fetch without changing the return type |
| of the query.</div> |
| </td> |
| </tr> |
| <tr id="i15" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#entityType(java.lang.Class)">entityType</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?> entityType)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets the type of the entity to fetch without changing the return type of |
| the query.</div> |
| </td> |
| </tr> |
| <tr id="i16" class="altColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getColumns()">getColumns</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i17" class="rowColor"> |
| <td class="colFirst"><code><a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getHaving()">getHaving</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Returns a HAVING clause Expression of this query.</div> |
| </td> |
| </tr> |
| <tr id="i18" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#having(java.lang.String,java.lang.Object...)">having</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> expressionString, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>... parameters)</code></th> |
| <td class="colLast"> |
| <div class="block">Appends a having qualifier expression of this query, using provided expression |
| String and an array of position parameters.</div> |
| </td> |
| </tr> |
| <tr id="i19" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#having(org.apache.cayenne.exp.Expression)">having</a></span>​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a> expression)</code></th> |
| <td class="colLast"> |
| <div class="block">Appends a having qualifier expression of this query.</div> |
| </td> |
| </tr> |
| <tr id="i20" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#limit(int)">limit</a></span>​(int fetchLimit)</code></th> |
| <td class="colLast"> |
| <div class="block">Resets query fetch limit - a parameter that defines max number of objects |
| that should be ever be fetched from the database.</div> |
| </td> |
| </tr> |
| <tr id="i21" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#localCache()">localCache</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "local" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i22" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#localCache(java.lang.String)">localCache</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "local" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i23" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#max(org.apache.cayenne.exp.Property)">max</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</code></th> |
| <td class="colLast"> |
| <div class="block">Select maximum value of property</div> |
| </td> |
| </tr> |
| <tr id="i24" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#min(org.apache.cayenne.exp.Property)">min</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</code></th> |
| <td class="colLast"> |
| <div class="block">Select minimum value of property</div> |
| </td> |
| </tr> |
| <tr id="i25" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#offset(int)">offset</a></span>​(int fetchOffset)</code></th> |
| <td class="colLast"> |
| <div class="block">Resets query fetch offset - a parameter that defines how many objects |
| should be skipped when reading data from the database.</div> |
| </td> |
| </tr> |
| <tr id="i26" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#or(java.util.Collection)">or</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>> expressions)</code></th> |
| <td class="colLast"> |
| <div class="block">OR's provided expressions to the existing WHERE or HAVING clause expression.</div> |
| </td> |
| </tr> |
| <tr id="i27" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#or(org.apache.cayenne.exp.Expression...)">or</a></span>​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>... expressions)</code></th> |
| <td class="colLast"> |
| <div class="block">OR's provided expressions to the existing WHERE clause expression.</div> |
| </td> |
| </tr> |
| <tr id="i28" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#orderBy(java.lang.String)">orderBy</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> property)</code></th> |
| <td class="colLast"> |
| <div class="block">Add an ascending ordering on the given property.</div> |
| </td> |
| </tr> |
| <tr id="i29" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#orderBy(java.lang.String,org.apache.cayenne.query.SortOrder)">orderBy</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> property, |
| <a href="SortOrder.html" title="enum in org.apache.cayenne.query">SortOrder</a> sortOrder)</code></th> |
| <td class="colLast"> |
| <div class="block">Add an ordering on the given property.</div> |
| </td> |
| </tr> |
| <tr id="i30" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#orderBy(java.util.Collection)">orderBy</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="Ordering.html" title="class in org.apache.cayenne.query">Ordering</a>> orderings)</code></th> |
| <td class="colLast"> |
| <div class="block">Adds a list of orderings to this query.</div> |
| </td> |
| </tr> |
| <tr id="i31" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#orderBy(org.apache.cayenne.query.Ordering...)">orderBy</a></span>​(<a href="Ordering.html" title="class in org.apache.cayenne.query">Ordering</a>... orderings)</code></th> |
| <td class="colLast"> |
| <div class="block">Add one or more orderings to this query.</div> |
| </td> |
| </tr> |
| <tr id="i32" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#pageSize(int)">pageSize</a></span>​(int pageSize)</code></th> |
| <td class="colLast"> |
| <div class="block">Resets query page size.</div> |
| </td> |
| </tr> |
| <tr id="i33" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#prefetch(java.lang.String,int)">prefetch</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> path, |
| int semantics)</code></th> |
| <td class="colLast"> |
| <div class="block">Merges a prefetch path with specified semantics into the query prefetch |
| tree.</div> |
| </td> |
| </tr> |
| <tr id="i34" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#prefetch(org.apache.cayenne.query.PrefetchTreeNode)">prefetch</a></span>​(<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a> prefetch)</code></th> |
| <td class="colLast"> |
| <div class="block">Merges prefetch into the query prefetch tree.</div> |
| </td> |
| </tr> |
| <tr id="i35" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#selectFirst(org.apache.cayenne.ObjectContext)">selectFirst</a></span>​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</code></th> |
| <td class="colLast"> |
| <div class="block">Selects a single object using provided context.</div> |
| </td> |
| </tr> |
| <tr id="i36" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sharedCache()">sharedCache</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "shared" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i37" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sharedCache(java.lang.String)">sharedCache</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</code></th> |
| <td class="colLast"> |
| <div class="block">Instructs Cayenne to look for query results in the "shared" cache when |
| running the query.</div> |
| </td> |
| </tr> |
| <tr id="i38" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#statementFetchSize(int)">statementFetchSize</a></span>​(int size)</code></th> |
| <td class="colLast"> |
| <div class="block">Sets fetch size of the PreparedStatement generated for this query.</div> |
| </td> |
| </tr> |
| <tr id="i39" class="rowColor"> |
| <td class="colFirst"><code><E extends <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Number.html?is-external=true" title="class or interface in java.lang" class="externalLink">Number</a>><br><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sum(org.apache.cayenne.exp.Property)">sum</a></span>​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><E> property)</code></th> |
| <td class="colLast"> |
| <div class="block">Select sum of values</div> |
| </td> |
| </tr> |
| <tr id="i40" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#suppressDistinct()">suppressDistinct</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Explicitly suppress distinct in query.</div> |
| </td> |
| </tr> |
| <tr id="i41" class="rowColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#where(java.lang.String,java.lang.Object...)">where</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> expressionString, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>... parameters)</code></th> |
| <td class="colLast"> |
| <div class="block">Appends a qualifier expression of this query, using provided expression |
| String and an array of position parameters.</div> |
| </td> |
| </tr> |
| <tr id="i42" class="altColor"> |
| <td class="colFirst"><code><a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#where(org.apache.cayenne.exp.Expression)">where</a></span>​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a> expression)</code></th> |
| <td class="colLast"> |
| <div class="block">Appends a qualifier expression of this query.</div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.FluentSelect"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.cayenne.query.<a href="FluentSelect.html" title="class in org.apache.cayenne.query">FluentSelect</a></h3> |
| <code><a href="FluentSelect.html#batchIterator(org.apache.cayenne.ObjectContext,int)">batchIterator</a>, <a href="FluentSelect.html#getCacheGroup()">getCacheGroup</a>, <a href="FluentSelect.html#getCacheStrategy()">getCacheStrategy</a>, <a href="FluentSelect.html#getDbEntityName()">getDbEntityName</a>, <a href="FluentSelect.html#getEntityName()">getEntityName</a>, <a href="FluentSelect.html#getEntityType()">getEntityType</a>, <a href="FluentSelect.html#getLimit()">getLimit</a>, <a href="FluentSelect.html#getOffset()">getOffset</a>, <a href="FluentSelect.html#getOrderings()">getOrderings</a>, <a href="FluentSelect.html#getPageSize()">getPageSize</a>, <a href="FluentSelect.html#getPrefetches()">getPrefetches</a>, <a href="FluentSelect.html#getStatementFetchSize()">getStatementFetchSize</a>, <a href="FluentSelect.html#getWhere()">getWhere</a>, <a href="FluentSelect.html#iterate(org.apache.cayenne.ObjectContext,org.apache.cayenne.ResultIteratorCallback)">iterate</a>, <a href="FluentSelect.html#iterator(org.apache.cayenne.ObjectContext)">iterator</a>, <a href="FluentSelect.html#select(org.apache.cayenne.ObjectContext)">select</a>, <a href="FluentSelect.html#selectOne(org.apache.cayenne.ObjectContext)">selectOne</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.IndirectQuery"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.cayenne.query.<a href="IndirectQuery.html" title="class in org.apache.cayenne.query">IndirectQuery</a></h3> |
| <code><a href="IndirectQuery.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a>, <a href="IndirectQuery.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a>, <a href="IndirectQuery.html#getReplacementQuery(org.apache.cayenne.map.EntityResolver)">getReplacementQuery</a>, <a href="IndirectQuery.html#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">route</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a></h3> |
| <code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#clone()" title="class or interface in java.lang" class="externalLink">clone</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#equals(java.lang.Object)" title="class or interface in java.lang" class="externalLink">equals</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#finalize()" title="class or interface in java.lang" class="externalLink">finalize</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#getClass()" title="class or interface in java.lang" class="externalLink">getClass</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#hashCode()" title="class or interface in java.lang" class="externalLink">hashCode</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notify()" title="class or interface in java.lang" class="externalLink">notify</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notifyAll()" title="class or interface in java.lang" class="externalLink">notifyAll</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#toString()" title="class or interface in java.lang" class="externalLink">toString</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait()" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait(long)" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait(long,int)" title="class or interface in java.lang" class="externalLink">wait</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.query.Query"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from interface org.apache.cayenne.query.<a href="Query.html" title="interface in org.apache.cayenne.query">Query</a></h3> |
| <code><a href="Query.html#createSQLAction(org.apache.cayenne.query.SQLActionVisitor)">createSQLAction</a>, <a href="Query.html#getMetaData(org.apache.cayenne.map.EntityResolver)">getMetaData</a>, <a href="Query.html#route(org.apache.cayenne.query.QueryRouter,org.apache.cayenne.map.EntityResolver,org.apache.cayenne.query.Query)">route</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.detail"> |
| <!-- --> |
| </a> |
| <h3>Constructor Detail</h3> |
| <a id="<init>()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ColumnSelect</h4> |
| <pre>protected ColumnSelect()</pre> |
| </li> |
| </ul> |
| <a id="<init>(org.apache.cayenne.query.ObjectSelect)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>ColumnSelect</h4> |
| <pre>protected ColumnSelect​(<a href="ObjectSelect.html" title="class in org.apache.cayenne.query">ObjectSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> select)</pre> |
| <div class="block">Copy constructor to convert ObjectSelect to ColumnSelect</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ============ METHOD DETAIL ========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a id="createReplacementQuery(org.apache.cayenne.map.EntityResolver)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>createReplacementQuery</h4> |
| <pre class="methodSignature">protected <a href="Query.html" title="interface in org.apache.cayenne.query">Query</a> createReplacementQuery​(<a href="../map/EntityResolver.html" title="class in org.apache.cayenne.map">EntityResolver</a> resolver)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="FluentSelect.html#createReplacementQuery(org.apache.cayenne.map.EntityResolver)">FluentSelect</a></code></span></div> |
| <div class="block">Translates self to a SelectQuery.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="FluentSelect.html#createReplacementQuery(org.apache.cayenne.map.EntityResolver)">createReplacementQuery</a></code> in class <code><a href="FluentSelect.html" title="class in org.apache.cayenne.query">FluentSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="entityType(java.lang.Class)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>entityType</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> entityType​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html?is-external=true" title="class or interface in java.lang" class="externalLink">Class</a><?> entityType)</pre> |
| <div class="block">Sets the type of the entity to fetch without changing the return type of |
| the query.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="entityName(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>entityName</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> entityName​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> entityName)</pre> |
| <div class="block">Sets the <a href="../map/ObjEntity.html" title="class in org.apache.cayenne.map"><code>ObjEntity</code></a> name to fetch without changing the return type |
| of the query. This form is most often used for generic entities that |
| don't map to a distinct class.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="dbEntityName(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>dbEntityName</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> dbEntityName​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> dbEntityName)</pre> |
| <div class="block">Sets the <a href="../map/DbEntity.html" title="class in org.apache.cayenne.map"><code>DbEntity</code></a> name to fetch without changing the return type |
| of the query. This form is most often used for generic entities that |
| don't map to a distinct class.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="where(org.apache.cayenne.exp.Expression)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>where</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> where​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a> expression)</pre> |
| <div class="block">Appends a qualifier expression of this query. An equivalent to |
| <a href="#and(org.apache.cayenne.exp.Expression...)"><code>and(Expression...)</code></a> that can be used a syntactic sugar.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="where(java.lang.String,java.lang.Object...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>where</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> where​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> expressionString, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>... parameters)</pre> |
| <div class="block">Appends a qualifier expression of this query, using provided expression |
| String and an array of position parameters. This is an equivalent to |
| calling "and".</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="and(org.apache.cayenne.exp.Expression...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>and</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> and​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>... expressions)</pre> |
| <div class="block">AND's provided expressions to the existing WHERE clause expression.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="or(org.apache.cayenne.exp.Expression...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>or</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> or​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>... expressions)</pre> |
| <div class="block">OR's provided expressions to the existing WHERE clause expression.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="orderBy(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>orderBy</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> orderBy​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> property)</pre> |
| <div class="block">Add an ascending ordering on the given property. If there is already an ordering |
| on this query then add this ordering with a lower priority.</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>property</code> - the property to sort on</dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="orderBy(java.lang.String,org.apache.cayenne.query.SortOrder)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>orderBy</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> orderBy​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> property, |
| <a href="SortOrder.html" title="enum in org.apache.cayenne.query">SortOrder</a> sortOrder)</pre> |
| <div class="block">Add an ordering on the given property. If there is already an ordering |
| on this query then add this ordering with a lower priority.</div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>property</code> - the property to sort on</dd> |
| <dd><code>sortOrder</code> - the direction of the ordering</dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="orderBy(org.apache.cayenne.query.Ordering...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>orderBy</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> orderBy​(<a href="Ordering.html" title="class in org.apache.cayenne.query">Ordering</a>... orderings)</pre> |
| <div class="block">Add one or more orderings to this query.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="orderBy(java.util.Collection)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>orderBy</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> orderBy​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="Ordering.html" title="class in org.apache.cayenne.query">Ordering</a>> orderings)</pre> |
| <div class="block">Adds a list of orderings to this query.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="prefetch(org.apache.cayenne.query.PrefetchTreeNode)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>prefetch</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> prefetch​(<a href="PrefetchTreeNode.html" title="class in org.apache.cayenne.query">PrefetchTreeNode</a> prefetch)</pre> |
| <div class="block">Merges prefetch into the query prefetch tree.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="prefetch(java.lang.String,int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>prefetch</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> prefetch​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> path, |
| int semantics)</pre> |
| <div class="block">Merges a prefetch path with specified semantics into the query prefetch |
| tree.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="limit(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>limit</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> limit​(int fetchLimit)</pre> |
| <div class="block">Resets query fetch limit - a parameter that defines max number of objects |
| that should be ever be fetched from the database.</div> |
| </li> |
| </ul> |
| <a id="offset(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>offset</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> offset​(int fetchOffset)</pre> |
| <div class="block">Resets query fetch offset - a parameter that defines how many objects |
| should be skipped when reading data from the database.</div> |
| </li> |
| </ul> |
| <a id="pageSize(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>pageSize</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> pageSize​(int pageSize)</pre> |
| <div class="block">Resets query page size. A non-negative page size enables query result |
| pagination that saves memory and processing time for large lists if only |
| parts of the result are ever going to be accessed.</div> |
| </li> |
| </ul> |
| <a id="statementFetchSize(int)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>statementFetchSize</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> statementFetchSize​(int size)</pre> |
| <div class="block">Sets fetch size of the PreparedStatement generated for this query. Only |
| non-negative values would change the default size.</div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="https://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html?is-external=true#setFetchSize(int)" title="class or interface in java.sql" class="externalLink"><code>Statement.setFetchSize(int)</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheStrategy</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> cacheStrategy​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy)</pre> |
| </li> |
| </ul> |
| <a id="cacheStrategy(org.apache.cayenne.query.QueryCacheStrategy,java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheStrategy</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> cacheStrategy​(<a href="QueryCacheStrategy.html" title="enum in org.apache.cayenne.query">QueryCacheStrategy</a> strategy, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</pre> |
| </li> |
| </ul> |
| <a id="cacheGroup(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>cacheGroup</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> cacheGroup​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</pre> |
| </li> |
| </ul> |
| <a id="localCache(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>localCache</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> localCache​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</pre> |
| <div class="block">Instructs Cayenne to look for query results in the "local" cache when |
| running the query. This is a short-hand notation for: |
| <p> |
| <pre> |
| query.cacheStrategy(QueryCacheStrategy.LOCAL_CACHE, cacheGroup); |
| </pre></div> |
| </li> |
| </ul> |
| <a id="localCache()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>localCache</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> localCache()</pre> |
| <div class="block">Instructs Cayenne to look for query results in the "local" cache when |
| running the query. This is a short-hand notation for: |
| <p> |
| <pre> |
| query.cacheStrategy(QueryCacheStrategy.LOCAL_CACHE); |
| </pre></div> |
| </li> |
| </ul> |
| <a id="sharedCache(java.lang.String)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sharedCache</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> sharedCache​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> cacheGroup)</pre> |
| <div class="block">Instructs Cayenne to look for query results in the "shared" cache when |
| running the query. This is a short-hand notation for: |
| <p> |
| <pre> |
| query.cacheStrategy(QueryCacheStrategy.SHARED_CACHE, cacheGroup); |
| </pre></div> |
| </li> |
| </ul> |
| <a id="sharedCache()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sharedCache</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> sharedCache()</pre> |
| <div class="block">Instructs Cayenne to look for query results in the "shared" cache when |
| running the query. This is a short-hand notation for: |
| <p> |
| <pre> |
| query.cacheStrategy(QueryCacheStrategy.SHARED_CACHE); |
| </pre></div> |
| </li> |
| </ul> |
| <a id="columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>columns</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> columns​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> firstProperty, |
| <a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?>... otherProperties)</pre> |
| <div class="block"><p>Add properties to select.</p> |
| <p>Can be any properties that can be resolved against root entity type |
| (root entity properties, function call expressions, properties of relationships, etc).</p> |
| <p> |
| <pre> |
| <code> |
| List<Object[]> columns = ObjectSelect.columnQuery(Artist.class, Artist.ARTIST_NAME) |
| .columns(Artist.ARTIST_SALARY, Artist.DATE_OF_BIRTH) |
| .select(context); |
| </code> |
| </pre></div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>firstProperty</code> - first property</dd> |
| <dd><code>otherProperties</code> - array of properties to select</dd> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#column(org.apache.cayenne.exp.Property)"><code>column(Property)</code></a>, |
| <a href="#columns(java.util.Collection)"><code>columns(Collection)</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="columns(java.util.Collection)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>columns</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> columns​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?>> properties)</pre> |
| <div class="block"><p>Add properties to select.</p> |
| <p>Can be any properties that can be resolved against root entity type |
| (root entity properties, function call expressions, properties of relationships, etc).</p> |
| <p></div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>properties</code> - collection of properties, <b>must</b> contain at least one element</dd> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="column(org.apache.cayenne.exp.Property)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>column</h4> |
| <pre class="methodSignature">protected <E> <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><E> column​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><E> property)</pre> |
| </li> |
| </ul> |
| <a id="count()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>count</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> count()</pre> |
| <div class="block"><p>Shortcut for <a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a> columns}(Property.COUNT)</p></div> |
| </li> |
| </ul> |
| <a id="count(org.apache.cayenne.exp.Property)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>count</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> count​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</pre> |
| <div class="block"><p>Select COUNT(property)</p> |
| <p>Can return different result than COUNT(*) as it will count only non null values</p></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#count()"><code>count()</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="min(org.apache.cayenne.exp.Property)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>min</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> min​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</pre> |
| <div class="block"><p>Select minimum value of property</p></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="max(org.apache.cayenne.exp.Property)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>max</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> max​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</pre> |
| <div class="block"><p>Select maximum value of property</p></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="avg(org.apache.cayenne.exp.Property)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>avg</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> avg​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?> property)</pre> |
| <div class="block"><p>Select average value of property</p></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="sum(org.apache.cayenne.exp.Property)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>sum</h4> |
| <pre class="methodSignature">public <E extends <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Number.html?is-external=true" title="class or interface in java.lang" class="externalLink">Number</a>> <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>[]> sum​(<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><E> property)</pre> |
| <div class="block"><p>Select sum of values</p></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="#columns(org.apache.cayenne.exp.Property,org.apache.cayenne.exp.Property...)"><code>columns(Property, Property[])</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="having(org.apache.cayenne.exp.Expression)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>having</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> having​(<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a> expression)</pre> |
| <div class="block">Appends a having qualifier expression of this query. An equivalent to |
| <a href="#and(org.apache.cayenne.exp.Expression...)"><code>and(Expression...)</code></a> that can be used a syntactic sugar.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="having(java.lang.String,java.lang.Object...)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>having</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> having​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> expressionString, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a>... parameters)</pre> |
| <div class="block">Appends a having qualifier expression of this query, using provided expression |
| String and an array of position parameters. This is an equivalent to |
| calling "and".</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="and(java.util.Collection)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>and</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> and​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>> expressions)</pre> |
| <div class="block">AND's provided expressions to the existing WHERE or HAVING clause expression.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="or(java.util.Collection)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>or</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> or​(<a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a>> expressions)</pre> |
| <div class="block">OR's provided expressions to the existing WHERE or HAVING clause expression.</div> |
| <dl> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>this object</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="distinct()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>distinct</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> distinct()</pre> |
| <div class="block">Explicitly request distinct in query.</div> |
| </li> |
| </ul> |
| <a id="suppressDistinct()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>suppressDistinct</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="class in org.apache.cayenne.query">ColumnSelect</a><<a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a>> suppressDistinct()</pre> |
| <div class="block">Explicitly suppress distinct in query.</div> |
| </li> |
| </ul> |
| <a id="getColumns()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getColumns</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/util/Collection.html?is-external=true" title="class or interface in java.util" class="externalLink">Collection</a><<a href="../exp/Property.html" title="class in org.apache.cayenne.exp">Property</a><?>> getColumns()</pre> |
| </li> |
| </ul> |
| <a id="getHaving()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getHaving</h4> |
| <pre class="methodSignature">public <a href="../exp/Expression.html" title="class in org.apache.cayenne.exp">Expression</a> getHaving()</pre> |
| <div class="block">Returns a HAVING clause Expression of this query.</div> |
| </li> |
| </ul> |
| <a id="selectFirst(org.apache.cayenne.ObjectContext)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>selectFirst</h4> |
| <pre class="methodSignature">public <a href="ColumnSelect.html" title="type parameter in ColumnSelect">T</a> selectFirst​(<a href="../ObjectContext.html" title="interface in org.apache.cayenne">ObjectContext</a> context)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from interface: <code><a href="Select.html#selectFirst(org.apache.cayenne.ObjectContext)">Select</a></code></span></div> |
| <div class="block">Selects a single object using provided context. The query itself can |
| match any number of objects, but will return only the first one. It |
| returns null if no objects were matched. |
| <p> |
| If it matched more than one object, the first object from the list is |
| returned. This makes 'selectFirst' different from |
| <a href="Select.html#selectOne(org.apache.cayenne.ObjectContext)"><code>Select.selectOne(ObjectContext)</code></a>, which would throw in this situation. |
| 'selectFirst' is useful e.g. when the query is ordered and we only want |
| to see the first object (e.g. "most recent news article"), etc. |
| <p> |
| Selecting the first object via "Select.selectFirst(ObjectContext)" is |
| more comprehensible than selecting via |
| "ObjectContext.selectFirst(Select)", because implementations of "Select" |
| set fetch size limit to one.</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </main> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <footer role="contentinfo"> |
| <nav role="navigation"> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a id="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../index.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/ColumnSelect.html">Use</a></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 class="aboutLanguage"><a href="http://cayenne.apache.org" target="top">Apache Cayenne</a></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../allclasses.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> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li>Field | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a id="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| </nav> |
| <p class="legalCopy"><small>Copyright © 2001–2019 <a href="http://cayenne.apache.org/">Apache Cayenne</a>. All rights reserved.</small></p> |
| </footer> |
| </body> |
| </html> |