\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{sudhirdaruwala} \pdfinfo{ /Title (lucene-query-syntax.pdf) /Creator (Cheatography) /Author (sudhirdaruwala) /Subject (Lucene Query Syntax Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{1A91A3} \definecolor{LightBackground}{HTML}{F0F8F9} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Lucene Query Syntax Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{sudhirdaruwala} via \textcolor{DarkBackground}{\uline{cheatography.com/20665/cs/3383/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}sudhirdaruwala \\ \uline{cheatography.com/sudhirdaruwala} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 24th February, 2015.\\ Updated 12th May, 2016.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{2} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Keyboard Matching}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{Search for word "foo" in the title field \newline % Row Count 1 (+ 1) `title: foo` \newline % Row Count 2 (+ 1) Search for phrase "foo bar" in the title field \newline % Row Count 3 (+ 1) `title: "foo bar"` \newline % Row Count 4 (+ 1) Search for phrase "foo bar" in the title field AND the phrase "quick fox" in the body field. \newline % Row Count 6 (+ 2) `title:"foo bar" AND body:"quick fox"` \newline % Row Count 7 (+ 1) Search for either the phrase "foo bar" in the title field AND the phrase "quick fox" in the body field, or the word "fox" in the title field. \newline % Row Count 10 (+ 3) `(title:"foo bar" AND body:"quick fox") OR title:fox` \newline % Row Count 12 (+ 2) Search for word "foo" and not "bar" in the title field. \newline % Row Count 14 (+ 2) `title:foo -title:bar`% Row Count 15 (+ 1) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Wildcard matching}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{Search for any word that starts with "foo" in the title field. \newline % Row Count 2 (+ 2) `title:foo*` \newline % Row Count 3 (+ 1) Search for any word that starts with "foo" and ends with bar in the title field. \newline % Row Count 5 (+ 2) `title:foo*bar` \newline % Row Count 6 (+ 1) {\emph{Note that Lucene doesn't support using a }} symbol as the first character of a *search.% Row Count 8 (+ 2) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Proximity matching}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{Search for "foo bar" within 4 words from each other. \newline % Row Count 2 (+ 2) `"foo bar"\textasciitilde{}4`% Row Count 3 (+ 1) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Range Searches}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{Range Queries allow one to match documents whose field(s) values are between the lower and upper bound specified by the Range Query. Range Queries can be inclusive or exclusive of the upper and lower bounds. Sorting is done lexicographically. \newline % Row Count 5 (+ 5) `mod\_date:{[}20020101 TO 20030101{]}`% Row Count 6 (+ 1) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Boosts}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{Query-time boosts allow one to specify which terms/clauses are "more important". The higher the boost factor, the more relevant the term will be, and therefore the higher the corresponding document scores. \newline % Row Count 5 (+ 5) A typical boosting technique is assigning higher boosts to title matches than to body content matches: \newline % Row Count 8 (+ 3) `(title:foo OR title:bar)\textasciicircum{}1.5 (body:foo OR body:bar)`% Row Count 10 (+ 2) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Boolean Operators}} \tn \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{To search for all transactions except MySQL transactions: \newline % Row Count 2 (+ 2) `NOT type: mysql` \newline % Row Count 3 (+ 1) To search for all MySQL SELECT queries with large attachments: \newline % Row Count 5 (+ 2) `mysql.method: SELECT AND mysql.size: {[}10000 TO *{]}` \newline % Row Count 7 (+ 2) Lucene also supports parentheses to group sub queries. \newline % Row Count 9 (+ 2) To search for either INSERT or UPDATE MySQL queries with a responsetime greater or equal with 30ms: \newline % Row Count 11 (+ 2) `(mysql.method: INSERT OR mysql.method: UPDATE) AND responsetime:{[}30 TO *{]}`% Row Count 13 (+ 2) } \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}