Re: Nested queries

Hilary Stoupa — Wed, 10 Oct 2012 01:02:50 GMT

Mind sharing your form? It is a little hard to help without knowing more about the data structure.

Nested queries

adrianodl — Fri, 05 Oct 2012 05:21:24 GMT

Hi there,

Please refer to the attachment for the modelling of my DB.

What I'm trying to achieve is a form that displays the following:

provide the users with a list of servers to select from (done, I'm populating a multiple-selection list box (multServers) with data fed from the DB ([Table ABC].Column Server )
display all applications installed on selected servers (done, I created a repeating list (bound to the "Table DEF" table) with the following conditional formatting statement "count(@ServerName[. = xdXDocument:get-DOM()/my:myFields/my:group1/my:multServers]) != 1"
Display the Change Window of each application

That's what I'm currently struggling with (3). I basically need to display the Change Window when Table XYZ.Column Application = Table DEF.ApplicationName AND Table DEF.ServerName = multServers (the select items of the check box).

Any leads would be appreciated.

Cheers,

Adri

Data Connections

Re: Nested queries

Nested queries