Group Query Conditions

Group Query Conditions

Anonymous
Not applicable
326 Views
1 Reply
Message 1 of 2

Group Query Conditions

Anonymous
Not applicable
Hi all,
How I can group query conditions (with char "(" and ")" )?

Thanks and Regards
--
Matteo Conte
0 Likes
327 Views
1 Reply
Reply (1)
Message 2 of 2

Anonymous
Not applicable
"Matteo Conte" wrote in message
news:686E624403D0CBBB1124FB92D5D4F83A@in.WebX.maYIadrTaRb...
> Hi all,
> How I can group query conditions (with char "(" and ")" )?
>

Hello Matteo,

You don't say which API you're using, but for
AdsRx/Lisp the 2nd and 6th arguments to
ade_qrydefine allow you to specify grouping.

For example, the following query tree:

Location: All
AND (Property: AREA > 100000
OR Data: Demographics.State = CA)

That has a group around the Property and Data
conditions and is created like this in lisp:

(ade_qrydefine '("" "" "" "Location" ("ALL" )""))
(ade_qrydefine '("AND" "(" "" "Property" ("AREA" ">" "100000")""))
;;;;;;;;;;;;;;;;;;;;;;;;^ begin group here
(ade_qrydefine '("AND" "" "" "Data" ("objdata" "Demographics.State" "="
"CA")")"))
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; end group here
;;;^

Cheers-

rdh.
0 Likes