I want to send an email that contains a filtered list of documents that the recipient can click on to open the document directly. I see there is a Context Object of Site that has QueryList and GetValues but so far I have been unsuccessful in getting the syntax correct. Can you help?
Here is the syntax that I have so far that fails:
[[@Site.QueryList('/sites/management/keydocs', ' <Query> <Where> <Eq> <FieldRef Name='TargetDate' /> <Value IncludeTimeValue='FALSE' Type='DateTime'>2017-11-21</Value> </Eq> </Where> </Query> <ViewFields> <FieldRef Name='FileLeafRef' /> <FieldRef Name='Entity' /> <FieldRef Name='Department12' /> <FieldRef Name='Document_x0020_Type' /> <FieldRef Name='TargetDate' /> <FieldRef Name='Editor' /> </ViewFields> <QueryOptions /> ', 20, 'Title', 'Viewattributes')]]