[jira] [Commented] (FINERACT-1058) Add support for "limit" and "order by" query in SQLBuilder

["Manthan Surkar (Jira)" <ji...@apache.org>]

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

Manthan Surkar commented on FINERACT-1058:
------------------------------------------

Extending this to a more general case, we cannot just add support for limit and order by since then Offset query comes into the picture. The general case would be to support a non-operator based query.

The problem: They need to be written in a particular order in a query which makes It little bit harder.
 [ ORDER BY sort_expression1 [ASC | DESC] [, sort_expression2 [ASC | DESC] ...] ]  [ LIMIT { number | ALL } ] [ OFFSET number ]





> Add support for "limit" and "order by" query in SQLBuilder 
> -----------------------------------------------------------
>
>                 Key: FINERACT-1058
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1058
>             Project: Apache Fineract
>          Issue Type: Improvement
>            Reporter: Manthan Surkar
>            Assignee: Manthan Surkar
>            Priority: Major
>
> This is in continuation of the work done by [~vorburger] in https://github.com/apache/fineract/pull/725 
> The SQL builder currently does not support limit and order by operation. We can either keep the operations independent of SQLbuilder (which is certainly not recommended imo) or add it as a part of it.
> WDYT [~vorburger] [~awasum]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)