[jira] [Commented] (OFBIZ-9890) Having condition is ignored on queryList() and queryFirst() calls in EntityQuery

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (OFBIZ-9890) Having condition is ignored on queryList() and queryFirst() calls in EntityQuery

Nicolas Malin (Jira)

    [ https://issues.apache.org/jira/browse/OFBIZ-9890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16223523#comment-16223523 ]

Prakhar Kumar commented on OFBIZ-9890:
--------------------------------------

Researched around this issue and found that there is no support for HAVING condition in the findList method itself. So this ticket seems to be an 'Improvement' type instead of 'Bug'.

I've started working for providing the path for the same.

> Having condition is ignored on queryList() and queryFirst() calls in EntityQuery
> --------------------------------------------------------------------------------
>
>                 Key: OFBIZ-9890
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9890
>             Project: OFBiz
>          Issue Type: Bug
>          Components: ALL COMPONENTS
>    Affects Versions: Trunk
>            Reporter: Gareth Carter
>            Assignee: Prakhar Kumar
>            Priority: Critical
>
> queryList() and queryFirst() both call internal private query() method. This method calls delegator.findList if a normal Entity/ViewEntity is used (not a DVE). This has no option to include a having condition and so must opt to use queryIterator(). Even queryCount() can use a having condition



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)