Home » Microsoft » 70-489 » Which FQL statements should you use?
A legal company uses SharePoint for document and records management. You search all documents by using extractors and managed properties FAST Query Language (FQL) is enabled for the result sources, and the content of the document is indexed as full text. All documents are named by using the following pattern "AAA-Axxxx-AA".
You must find documents that were created in May 2012 and contain the ordered keywords "liable", "advocate", and "adjudication" Results that are returned must include only document names that begin with "HCT-Q" and end only with "AB".
You need to create the FQL query that returns the required results.
Which FQL statements should you use? (Each correct answer presents part of the solution. Choose all that apply)
A. write>=05/01/2012 and write<=05/31/2012
B. string("liable advocate adjudication", mode="onear")
C. title:HCT-Q*
D. title:HCT-Q????-AB
E. NEAR(liable, advocate, adjudication)
F. write:range(2012-05-01, 2012-05-31)
Correct Answer: BDF
Explanation/Reference:
B (not E)
The ordered variant of NEAR, and requires an ordered match of the terms. The ONEAR operator can be used to restrict the result set to items that have N terms within a certain distance of.
Returns only items that don’t match the operand. The operand may be any valid FQL expression one another.
NEAR Restricts the result set to items that have N terms within a certain distance of one another.
ONEAR The ordered variant of NEAR, and requires an ordered match of the terms. The ONEAR operator can be used to restrict the result set to items that have N terms within a certain distance of one another.
D (not C)
All documents are named by using the following pattern "AAA-Axxxx-AA".
Results that are returned must include only document names that begin with "HCT-Q" and end only with "AB".
F (not A)
Range Enables range matching expressions The RANGE operator is used for numeric and date/time managed properties FQL provides the dateti me data type for date and time.
The following ISO 860 1-compati ble dateti me formats are supported in queries
YYYY-MM-DD
YYYY-MM-DDThhmmss
YYYY-MM-DDThhmmssZ
YYYY-MM-DDThhmmssfrZ
// Return all results between and including 2013-07-17T12:35:57.0000000Z and 2013-07-17T13:35:57.0000000Z
/_api/search/query?querytext=’*’&refinementfilters=’write:range(2013-07-17T12:35:57.0000000Z,2013-07-17T13:35:57.0000000Z, from="ge",to="le")’
http://msdn.microsoft.com/en-us/library/office/ff394606.aspx
http://techmikael.blogspot.de/2013/07/limiting-search-results-by-exact-time.html