It may be useful to display data related to the project. To do that, you can reference project attributes in a Connected item query.
The $project variable is available and exposes 5 attributes:
| Type | Name | Description | Example |
|---|
| String | key | Returns a string which corresponds to the current project key | $project.key
> "ECC" |
| String | name | Returns a string which corresponds to the current project name | $project.name
> "Elements Connect Cloud" |
| String | id | Returns a unique identifier which corresponds to the current project id | $project.id
> "10001" |
| String | type | Returns a string which corresponds to the current project type | $project.type
> "Software" |
| String | category | Returns a string which corresponds to the current project category | $project.category
> "Apps" |
Referencing properties of the current project works the same way as referencing the value of other Connected items.
Here is an example:
SELECT role, manager, company
FROM employees
WHERE company= $project.name
SQL
is evaluated to:
SELECT role, manager, company
FROM employees
WHERE company = 'Elements'
SQL