Black Friday Sale! Use promo code: DMXBF20 valid only for hours

DMXzone Database Connector PHP Support Product Page

SQL Query Builder

Asked 27 Feb 2017 11:06:38
1
has this question
27 Feb 2017 11:06:38 User  posted:
Would I be able to have nested parts within a query, such as:

(SELECT Count(DISTINCT UserIDPL, LodgeIDPL)

or use things like GROUP and HAVING in my queries?

Replies

Replied 07 Mar 2017 16:33:39
07 Mar 2017 16:33:39 User  replied:
Anyone?
Replied 14 Mar 2017 20:12:49
14 Mar 2017 20:12:49 User  replied:
Surely someone must know?

Also, if I'm paying £94 a month for these extensions, is support always going to be so slow?
Replied 15 Mar 2017 06:42:35
15 Mar 2017 06:42:35 Teodor Kuduschiev replied:
Hello,
AS replied in the support ticket you opened for the same topic - the group by filter is available with the Data Formatter extension, it is not in the query builder. But instead of group by you can also nest queries and filter the second query by the value of the first one, in the server connect steps.
As for having - what exactly needs to be achieved?
Replied 15 Mar 2017 15:14:01
15 Mar 2017 15:14:01 User  replied:
Thanks Teodor - I'll try to recreate some examples I have using the DMX extensions and come back if I need any assistance.

Reply to this topic