• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Creating HQL Query which works on Collections

 
ankisinghal singhal
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am having following Model

Host

{
Long Id
String fqdn2
Set <HostDiscoveredReg > files
}

HostDiscoveredReg{

Long ID
Host hst
String filename

}

SoftwareRegFiles{

String filename

Set <SoftwareApps> apps

}


SoftwareRegApps{

String appName;

Set <SoftwareRegsFiles> files

}


Now I want to find the set of HostDiscoveredReg objects for a Set of Apps and Set of Hosts.

for given Set of Apps first we need to find set of SoftwareRegFiles and need to match the filename from SoftwareRegFiles to filename of HostDiscoveredReg and also match hst of HostDiscoveredReg to set of Hosts.

I am not able to create a HQL of this.

Can any one help me in this?

Ankit
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic