Materializing properties is the process to derive a value from a property path (like Property A->Property B->Property C) and store it as an artificial property of a document instance. To materialize a property based on the current property (i.e. the property whose control this is), a property paths must be specified that originates on the property. | Example Box |
|---|
A property Persons of doctype Organization is holding references to persons: | Property Control | Artificial Property Name | Artificial Property Value | Explanation |
|---|
mat:Name | Persons->Name | Hanna, Sarah, John | Materializes the name of the Person(s). | mat:Address->City | Persons->Address->City | New York, Rio, Tokio | Materializes the names of the person's city names. |
To use the materialized properties in queries (Where clause), use the following syntax. | Code Block |
|---|
| $<Persons->Name>=[Hanna]
$<Persons->Address->City>=[New York] |
|
| 
