Join (query directive) - Revision history

Olli: /* Notes */

2013-11-29T15:20:29Z

‎Notes

Olli at 11:07, 21 August 2009

2009-08-21T11:07:47Z

Olli: /* Example */

2009-08-21T10:58:19Z

‎Example

Olli: /* Example */

2009-08-20T09:10:44Z

‎Example

Olli at 09:10, 20 August 2009

2009-08-20T09:10:32Z

Olli at 07:44, 20 August 2009

2009-08-20T07:44:36Z

Olli at 07:38, 20 August 2009

2009-08-20T07:38:46Z

New page

== Description ==

Joins the results of inner directives by performing a cartesian product on the results of them.

== Constructor ==

Join(Directive d1,Directive d2,...)

== Notes ==

This directive is best used using the join method present in every directive. Calling A.join(B) will resolve to new Join(A,B). In many cases you do not need to refer to join specifically at all. Instead you may provide several directives to form method which will implicitly join them.

@@ Line 60: / Line 60: @@
   | align="center" | B1
   | align="center" | C2
-  | align="center" | D3
+  | align="center" | D2
   |-
   | align="center" | A2

@@ Line 10: / Line 10: @@
 This directive is best used using the ''join'' method present in every directive. Calling ''A.join(B)'' will resolve to ''new Join(A,B)''. In many cases you do not need to refer to join specifically at all. Instead you may provide several directives to [[From (query directive)|from]] method which will implicitly join them.
 == Example ==
@@ Line 26: / Line 90: @@
 Following example gets variant names of the input topic in various languages and joins the results.
-importPackage(org.wandora.query2);
+ importPackage(org.wandora.query2);
-importPackage(org.wandora.topicmap);
+ importPackage(org.wandora.topicmap);
-new Join(
+ new Join(
-  new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("en")).as("#en"),
+   new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("en")).as("#en"),
-  new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("fi")).as("#fi"),
+   new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("fi")).as("#fi"),
-  new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("se")).as("#se"),
+   new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("se")).as("#se"),
-  new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("it")).as("#it")
+   new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("it")).as("#it")
-−
+ )
 [[Category:Query directives]]

← Older revision		Revision as of 10:58, 21 August 2009
Line 24:		Line 24:
	Above example joins instances and subclasses of input. Typically the results of joins are filtered by comparing some values of the result rows. In this case only rows where the topics with roles "#instance" and XTMPSI.SUBCLASS are the same are selected (see [[Compare (query directive) \|Compare]] directive). Effectively this query finds out if any of the instances of the input topic are also subclasses of it.		Above example joins instances and subclasses of input. Typically the results of joins are filtered by comparing some values of the result rows. In this case only rows where the topics with roles "#instance" and XTMPSI.SUBCLASS are the same are selected (see [[Compare (query directive) \|Compare]] directive). Effectively this query finds out if any of the instances of the input topic are also subclasses of it.

		+	Following example gets variant names of the input topic in various languages and joins the results.
		+
		+	importPackage(org.wandora.query2);
		+	importPackage(org.wandora.topicmap);
		+	new Join(
		+	new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("en")).as("#en"),
		+	new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("fi")).as("#fi"),
		+	new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("se")).as("#se"),
		+	new Variant(XTMPSI.DISPLAY,XTMPSI.getLang("it")).as("#it")
		+	)

	[[Category:Query directives]]		[[Category:Query directives]]

@@ Line 13: / Line 13: @@
 == Example ==
-importPackage(org.wandora.query2);
+  importPackage(org.wandora.query2);
-importPackage(org.wandora.topicmap);
+  importPackage(org.wandora.topicmap);
-new Join(
+  new Join(
    new Instances().as("#instance"),
    new Players(
      XTMPSI.SUPERCLASS_SUBCLASS,
      XTMPSI.SUBCLASS).whereInputIs(XTMPSI.SUPERCLASS)
-).where("#instance","t=",XTMPSI.SUBCLASS)
+  ).where("#instance","t=",XTMPSI.SUBCLASS)
 Above example joins instances and subclasses of input. Typically the results of joins are filtered by comparing some values of the result rows. In this case only rows where the topics with roles "#instance" and XTMPSI.SUBCLASS are the same are selected (see [[Compare (query directive) |Compare]] directive). Effectively this query finds out if any of the instances of the input topic are also subclasses of it.

@@ Line 9: / Line 9: @@
 == Notes ==
-This directive is best used using the join method present in every directive. Calling A.join(B) will resolve to new Join(A,B). In many cases you do not need to refer to join specifically at all. Instead you may provide several directives to form method which will implicitly join them.
+This directive is best used using the ''join'' method present in every directive. Calling ''A.join(B)'' will resolve to ''new Join(A,B)''. In many cases you do not need to refer to join specifically at all. Instead you may provide several directives to [[From (query directive)|from]] method which will implicitly join them.
 [[Category:Query directives]]

← Older revision		Revision as of 07:44, 20 August 2009
Line 10:		Line 10:

	This directive is best used using the join method present in every directive. Calling A.join(B) will resolve to new Join(A,B). In many cases you do not need to refer to join specifically at all. Instead you may provide several directives to form method which will implicitly join them.		This directive is best used using the join method present in every directive. Calling A.join(B) will resolve to new Join(A,B). In many cases you do not need to refer to join specifically at all. Instead you may provide several directives to form method which will implicitly join them.
		+
		+
		+	[[Category:Query directives]]