MarkLogic 9 Product Documentationop:from-view
op:from-view( $schema as xs:string?, $view as xs:string, [$qualifier as xs:string?], [$systemCols as map:map?] ) as map:map
Summary
This function reads a row set from a configured view over TDE-indexed rows or a predefined view over range indexes.
This function creates a row set without a limit. Use op:limit or op:offset-limit to set a limit.
| Parameters | |
|---|---|
| $schema | The name identifying the schema containing the view. If the schema name is null, the engine searches for a view with the specified name. |
| $view | The name identifying a configured template or range view for rows projected from documents. |
| $qualifier | Specifies a name for qualifying the column names in place of the combination of the schema and view names. Use cases for the qualifier include self joins. Using an empty string removes all qualification from the column names. |
| $systemCols | An optional named fragment id column returned by op:fragment-id-col. One use case for fragment ids is in joins with lexicons or document content. |
Example
xquery version "1.0-ml";
import module namespace op="http://marklogic.com/optic"
at "/MarkLogic/optic.xqy";
op:from-view("main", "employees")
=> op:select(("EmployeeID", "FirstName", "LastName"))
=> op:order-by("EmployeeID")
=> op:result()
Example
xquery version "1.0-ml";
import module namespace op="http://marklogic.com/optic"
at "/MarkLogic/optic.xqy";
op:from-view("main", "employees", (), op:fragment-id-col('docId'))
=> op:select(("EmployeeID", "FirstName", "LastName", "Position", "docID"))
=> op:order-by("EmployeeID")
=> op:result()