[Vtigercrm-developers] vtws_query_related with ORDER BY clause?

[Uma S]

Thanks! for the update Alan, We will review to include this in the
documentation.

On Tue, Aug 25, 2020 at 3:34 PM Alan Lord <alanslists at gmail.com> wrote:

> Just to finish this thread you can also use ORDER BY clauses in this
> extra argument, e.g.
>
> > $query = "SELECT * FROM SalesOrder";
> > $limit = "ORDER BY subject LIMIT 100, 200";
> > $moreRelatedStuff = vtws_query_related($query, $accWSId, 'SalesOrder',
> $current_user, $limit);
>
> Hope that helps.
>
> Al
>
>
> On 25/08/2020 10:52, Alan Lord wrote:
> > I wrote too soon ;-)
> >
> > https://code.vtiger.com/vtiger/vtigercrm/issues/1464
> >
> > Some documentation would have been helpful guys...
> >
> > Al
> >
> >
> > On 25/08/2020 10:47, Alan Lord wrote:
> >> This is becoming a right PITA.
> >>
> >> https://code.vtiger.com/vtiger/vtigercrm/issues/1464
> >>
> >> using vtws_retrieve_related, or vtws_query_related, it is not possible
> >> to get more than the first 100 records...
> >>
> >> Al
> >>
> >>
> >> On 13/07/2020 12:24, Uma S wrote:
> >>> Thanks! for the notification Alan. We will review this post release.
> >>>
> >>> On Fri, Jul 10, 2020 at 2:20 PM Alan Lord <alanslists at gmail.com
> >>> <mailto:alanslists at gmail.com>> wrote:
> >>>
> >>>     anyone?
> >>>
> >>>     On 07/07/2020 13:30, Alan Lord wrote:
> >>>      > I'm looking at the vtws_retrieve_related and the
> >>>     vtws_query_related apis.
> >>>      >
> >>>      > vtws_retrieve_related is OK - but it is limited in the sense
> >>> you get
> >>>      > back everything.
> >>>      >
> >>>      > I would like to, maybe, add LIMIT and/or ORDER BY clauses...
> >>>      >
> >>>      > If I keep the query extremely simple, e.g.
> >>>      >
> >>>      >> $query = "SELECT * FROM HelpDesk";
> >>>      >> $data = vtws_query_related($query, '11x566', 'HelpDesk',
> >>>     $current_user);
> >>>      >> print_r($data);
> >>>      >
> >>>      > Then it works - but I can't add an ORDER BY clause. I couldn't
> >>> add a
> >>>      > simple WHERE clause either. The VTQL_Parser threw an exception
> no
> >>>     matter
> >>>      > what I tried.
> >>>      >
> >>>      > Is it possible to use an ORDER BY clause? Can you provide some
> >>>      > documentation and/or examples? If not - what would a Marketplace
> >>>     module
> >>>      > have to do? Would it have to iterate/post process *all* the
> >>> returned
> >>>      > data to effectively introduce ordering and/or limits?
> >>>      >
> >>>      >
> >>>      > Also, I note that in my simple query above, unlike vtws_query,
> >>> if I
> >>>      > include the semi-colon in the query the query fails. This isn't
> >>>      > consistent - in vtws_query you MUST terminate the query with a
> >>> ";".
> >>>      > (I expect it is the preg_match test in QueryRelated.php that is
> >>>     causing
> >>>      > this.)
> >>>      >
> >>
> >>
> >>
> >> _______________________________________________
> >> http://www.vtiger.com/
> >>
> >
> >
> > _______________________________________________
> > http://www.vtiger.com/
>
>
> _______________________________________________
> http://www.vtiger.com/



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200826/e92b0121/attachment.html>