[/map {"- map/map "}) [/map/title {"- topic/title "}) Statements (title][/map/topicref {"- map/topicref "}) [/map/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle {"- topic/navtitle "}) Statements and Clauses (navtitle][/map/topicref/topicmeta/linktext {"- map/linktext "}) Statements and Clauses (linktext][/map/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This section describes the types of clauses used in EQL statements. (shortdesc] (topicmeta][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) DEFINE clause (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) DEFINE clause (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) DEFINE is used to generate an intermediate result that will not be included in the query result. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) RETURN clause (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) RETURN clause (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) RETURN indicates that the statement result should be included in the query result. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) SELECT clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) SELECT clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The SELECT clause defines the list of attributes on the records produced by the statement. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) AS clause (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) AS clause (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The AS clause allows you to give an alias name to EQL attributes and results. (shortdesc] (topicmeta][/map/topicref/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Using AS expressions to calculate derived attributes (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Using AS expressions to calculate derived attributes (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) EQL statements typically use expressions to compute one or more derived attributes. (shortdesc] (topicmeta] (topicref] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) FROM clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) FROM clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) You can include a FROM clause in your statement to specify a different record source from the result of the containing search and navigation query. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) JOIN clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) JOIN clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) JOIN clauses allow records from multiple statements and/or named states to be combined, based on a relationship between certain attributes in these statements. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) WHERE clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) WHERE clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The WHERE clause is used to filter input records for an expression. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) HAVING clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) HAVING clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The HAVING clause is used to filter output records. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) ORDER BY clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) ORDER BY clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The ORDER BY clause is used to control the order of result records. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) PAGE clauses (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) PAGE clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The PAGE clause specifies a subset of records to return. (shortdesc] (topicmeta] (topicref] (topicref] (map]