Cross-List Lookup Filter
Posted by MES5464 - Sep 4 ’13 at 09:46
Are there any constants we can use in the filter portion of a "Request items" function?
Like a Now(), Today(), etc?
This is what I have so far:
function (term, page) {
if (!term || term.length == 0) {
return "{WebUrl}/_api/web/lists('{ListId}')/items?$select=Id,{LookupField}, Occuring, Location&$orderby=Show_x0020_Start, Show_x0020_End asc&filter=(new Date(Show_x0020_Start).getFullYear()>=Date().getFullYear())&$top=10";
}
return "{WebUrl}/_api/web/lists('{ListId}')/items?$select=Id,{LookupField}, Occuring, Location&$orderby={LookupField} asc&$filter=startswith({LookupField}, '" + term + "')&$top=10";
}
-
DmitryAdminMember for: 10 years 11 months 28 daysCross-site Lookup column uses OData queries. You can find the complete list of available operations in the following article:
http://msdn.microsoft.com/en-us/library/office/fp142385.aspx -
MES5464MemberMember for: 9 years 9 months 12 days
What am I doing wrong here?:
function (term, page) {
if (!term || term.length == 0) {
return "{WebUrl}/_api/web/lists('{ListId}')/items?$select=Id,{LookupField},Office,Email,Classification&$orderby={LookupField}&filter=startswith(Classification, 'Employee')&$top=10";
}
return "{WebUrl}/_api/web/lists('{ListId}')/items?$select=Id,{LookupField},Office,Email,Classification&$orderby={LookupField}&$filter=startswith({LookupField}, '" + term + "')&$top=10";
}
-
peter0900MemberMember for: 6 months 29 days
I want to display every relevant Reporting Period in my quest.
Get our Professional Air Conditioning Services in San Francisco CA.
Show more messages