eQL Mapping Examples
Below are eQL Mapping statement examples.
Input Examples {<start_with_object>|<select_data_field>} |
eQL /Search starts with |
---|---|
{DistributionOrder|Organization.Code} |
START WITH DistributionOrder
SELECT Organization.Code |
{DistributionOrder|Attribute["ABC”,"XYZ"].Value} |
START WITH DistributionOrder
SELECT Attributes["ABC", "XYZ"].Value |
{Transmittal|Code} |
START WITH Transmittal
SELECT Code |
{Transmittal|LineItems.Project.Code} |
START WITH Transmittal
SELECT LineItems.Project.Code |
{Transmittal|IssuedTo.FirstName+''+IssuedTo.Surname} |
START WITH Transmittal
SELECT IssuedTo.FirstName + ' ' + IssuedTo.Surname |
{TransmittalItem|Projects.Project.Code} |
START WITH Document
SELECT Projects.Project.Code |
{TransmittalItemFile|Name|Id = 2 } |
START WITH Files
SELECT Name WHERE Id = 2 |