[ 
https://jira.nuxeo.org/browse/NXP-4969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Florent Guillaume resolved NXP-4969.
------------------------------------

    Resolution: Fixed

Done.
http://hg.nuxeo.org/nuxeo/nuxeo-core/rev/93b15480c991

Syntax is straightforward:
        String query = "SELECT DISTINCT dc:title FROM File";
        IterableQueryResult res = session.queryAndFetch(query, "NXQL");


> VCS: allow SELECT and SELECT DISTINCT of explicit columns using queryAndFetch
> -----------------------------------------------------------------------------
>
>                 Key: NXP-4969
>                 URL: https://jira.nuxeo.org/browse/NXP-4969
>             Project: Nuxeo Enterprise Platform
>          Issue Type: Improvement
>          Components: Core SQL Storage
>            Reporter: Florent Guillaume
>            Assignee: Florent Guillaume
>             Fix For: 5.3.2
>
>
> CoreSession.queryAndFetch allows fetching of records depending on the 
> QueryMaker.
> The NXQLQueryMaker should allow SELECTing explicit columns, not just the id.
> Also allow SELECT DISTINCT on such queries.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets

Reply via email to