I can't figure out if I'm doing something wrong or if this is a bug.
I created a global schema called contracts, with 2 fields:
- customer_name: type lookup -> links to field "fullname" in schema "customer"
- contract_description: type text
Further, I have a schema called "project" that is assigned to the projects: namespace. This schema also has a field "customer_name" which is also a lookup to "customer.fullname".
My goal is to display the global data "contract_description" filtered by the customer name of the current project page. This here works:
== WORKS ==
---- struct global ----
schema: contract_positions
filter: customer_name = John Doe
----
But I can't figure out how to reference the page data. I tried the following variations with no success:
---- struct global----
schema: contracts
filter: customer_name=$STRUCT.project.customer_name$
----
---- struct table ----
schema: contracts
cols: description,customer_name
filter: customer_name= $STRUCT.project.customer_name$
----
Would much appreciate some help on this as I'm stuck...