Queries and Joins

Discussions about modeling, execution and management of process/application data.
Forum rules
Make sure every topic contains information about your LSPS version and if relevant also your server OS, client OS, database name and version, and application server name and version.
Byron Glueck
 
Posts: 85
Joined: Thu Apr 26, 2012 8:17 pm

Queries and Joins

Mon Jun 25, 2012 10:06 pm

When constructing a query in the LPS designer, assume the following:

Primary iterator is of shared record type A. Join iterator is of type B.

Can you please provide an example of a valid path expression for an inner join? Please also provide a use-case and sample value for the Condition parameter/clause.

Thanks in advance.

Maros Bajtos
 
Posts: 145
Joined: Mon Feb 27, 2012 2:52 pm

Re: Queries and Joins

Tue Jun 26, 2012 9:18 am

Inner join must be always only on the association (otherwise use a full-join). Let's say we have standard relation ship, Parent -> Child, the query would look like this:

Name: getAllParentsWithDaughtersOlderThan18
Record Type: Parent
Iterator: parent

Join:
Iterator: child
Record Type: Child
Join Type: INNER_JOIN
condition: child.sex = "FEMALE"
path: parent.children

Query condition:
child.age > 18

I also attach a sample model, with sample data model and given query.
Attachments
SampleJoinQuery-1.0.zip
(52.91 KiB) Downloaded 358 times

Return to Data modeling

Who is online

Users browsing this forum: No registered users and 1 guest