Select Clause

Suppose there is a Person document with a property Organization that references an Organization document with information about the corporation the person is working for. If this person document is part of a query result, the following deep link allows to render the organization's website as a column in the table that shows the result.

Organization->Website

Note that the value of the Organization property needs to be a link to an organisation document. This may be a Confluence link or a link created with a macro from the projectdoc Toolbox, Display Document Property Macro for instance.

More information on using deep links to select on property values in Select Clauses in Display Macros. Besides query macros deep links can also be used in macros that display properties such as Display Document Property Macro or Display Document Properties Macro.

Constraints in Where Clause

If you want to put a constraint on a query, where the type of a person's organization should match the type of organizations in the query result, the following could be used in the Where Clause of a query macro (e.g. Display Table Macro).

$<Type>=[${Organization->Type}]

Suppose you query for documents of type organization and the query – in form of a Display Table Macro – is part of a document of type person.

Limitations of Deep Links

What you cannot do is match a property referenced by a property of a document in the result set of a query.

$<Organization->Type>=$[Type]

For this example you want to make sure that the result set contains only persons that work in organizations that match the type of the current document.

If you need this sort of query you need to support this in your information model. To do so you need to materialize this reference in the person document.

Property Reference

Assume that the type is NGO, we could add a property "Works for Organization of Type" and set the string NGO as its value. Better yet, so that changes to the type on the organization document are reflected in the person document, use the Display Document Property Ref Macro.

This way you can use the type of the organization in your queries like this:

$<Works for Organization of Type>=$[Type]

Effectively, the property reference Organization->Type has been materialized in Works for Organization of Type.

Parent Property Reference

There is a special form of a property reference to another document which is the Parent Property Macro. Per default this macro is used for the value of the Parent Property in every doctype provided by smartics. You can take advantage of this property to materialize properties from the parent of this document.

Property Reference with Concat

Concat stands for concatenation and this feature is provided by the Display Document Property Ref Concat Macro. This macro does essentially the same as the Display Document Property Ref Macro but allows to add a text string to the property value. This is useful for properties like phone numbers, where the base phone number is specified in the organization document and you need to append the phone number extension to the phone number stem.