\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{Greg Finzer (GregFinzer)}
\pdfinfo{
/Title (elasticsearch-example-queries.pdf)
/Creator (Cheatography)
/Author (Greg Finzer (GregFinzer))
/Subject (Elasticsearch Example Queries 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}{369A8F}
\definecolor{LightBackground}{HTML}{F2F8F8}
\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{Elasticsearch Example Queries Cheat Sheet}}}} \\
\normalsize{by \textcolor{DarkBackground}{Greg Finzer (GregFinzer)} via \textcolor{DarkBackground}{\uline{cheatography.com/15280/cs/32188/}}}
\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}Greg Finzer (GregFinzer) \\
\uline{cheatography.com/gregfinzer} \\
\uline{\seqsplit{www.kellermansoftware.com}}
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
\SetRowColor{FootBackground}
\mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\
\vspace{-2pt}Published 28th September, 2023.\\
Updated 28th September, 2023.\\
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}{Count items in an index}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET customer\_index/\_count \newline \{ \newline "query" : \{ \newline "match\_all" : \{\} \newline \} \newline \}} \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}{Return the top 200 products that are movies}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET product\_index/\_search \newline \{ \newline "size" : 200, \newline "query" : \{ \newline "bool" : \{ \newline "must" : {[} \newline \{ \newline "match" : \{ \newline "category" : "Movie" \newline \} \newline \} \newline {]} \newline \} \newline \} \newline \}} \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}{Get an aggregate list of product categories}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET product\_index/\_search \newline \{ \newline "size" : 0, \newline "aggs" : \{ \newline "category" : \{ \newline "terms" : \{ \newline "field" : "category.keyword", \newline "order" : \{ \newline "\_key" : "asc" \newline \} \newline \} \newline \} \newline \} \newline \}} \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}{Get a list of products that do not have a category}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET product\_index/\_search \newline \{ \newline "size" : 200, \newline "query" : \{ \newline "bool" : \{ \newline "must\_not" : {[} \newline \{ \newline "exists" : \{ \newline "field" : "category" \newline \} \newline \} \newline {]}, \newline "minimum\_should\_match" : 1, \newline "should" : {[} \newline \{ \newline "match" : \{ \newline "product\_type" : \{ \newline "query" : "Physical" \newline \} \newline \} \newline \} \newline {]} \newline \} \newline \} \newline \}} \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}{Group by Aggregate}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET product\_index/\_search \newline \{ \newline "size" : 0, \newline "query" : \{ \newline "bool" : \{ \newline "must" : {[} \newline \{ \newline "match" : \{ \newline "product\_type" : "Physical" \newline \} \newline \}, \newline \{ \newline "wildcard" : \{ \newline "category.keyword" : \{ \newline "value" : "{\emph{DVD}}" \newline \} \newline \} \newline \} \newline \newline {]} \newline \} \newline \}, \newline "aggs" : \{ \newline "group\_by\_column" : \{ \newline "terms" : \{ \newline "field" : "category.keyword", \newline "size" : 10000 \newline \} \newline \} \newline \newline \} \newline \}} \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}{Get top 200 from the customer\_index}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET customer\_index/\_search \newline \{ \newline "size" : 200, \newline "query" : \{ \newline "match\_all" : \{\} \newline \} \newline \}} \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}{Search that have DVD in the name with a wildcard}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET product\_index/\_search \newline \{ \newline "size" : 200, \newline "query" : \{ \newline "wildcard" : \{ \newline "name" : \{ \newline "value" : "{\emph{DVD}}" \newline \} \newline \} \newline \} \newline \}} \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}{Perform a search and order by using functions}} \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{GET product\_index/\_search \newline \{ \newline "size": 200, \newline "query": \{ \newline "function\_score": \{ \newline "query": \{ \newline "bool": \{ \newline "must": {[} \newline \{ \newline "bool": \{ \newline \seqsplit{"minimum\_should\_match":} 1, \newline "should": {[} \newline \{ \newline "term": \{ \newline "category.keyword": "Books" \newline \} \newline \}, \newline \{ \newline "term": \{ \newline "category.keyword": "Movies" \newline \} \newline \} \newline {]} \newline \} \newline \} \newline {]}, \newline \seqsplit{"minimum\_should\_match":} 1, \newline "should": {[} \newline \{ \newline "match\_phrase": \{ \newline "nameLowercase": "journey" \newline \} \newline \}, \newline \{ \newline "match\_phrase": \{ \newline "descriptionLowercase": "journey" \newline \} \newline \} \newline {]} \newline \} \newline \}, \newline "functions": {[} \newline \{ \newline "filter": \{ \newline "bool": \{ \newline "must": {[} \newline \{ \newline "term": \{ \newline "nameLowercase.keyword": "journey" \newline \} \newline \} \newline {]} \newline \} \newline \}, \newline "weight": 3 \newline \}, \newline \{ \newline "filter": \{ \newline "bool": \{ \newline "must": {[} \newline \{ \newline "match\_phrase": \{ \newline "nameLowercase": "journey" \newline \} \newline \} \newline {]} \newline \} \newline \}, \newline "weight": 2 \newline \}, \newline \{ \newline "filter": \{ \newline "bool": \{ \newline "must": {[} \newline \{ \newline "match\_phrase": \{ \newline "descriptionLowercase": "journey" \newline \} \newline \} \newline {]} \newline \} \newline \}, \newline "weight": 1 \newline \} \newline {]}, \newline "score\_mode": "first", \newline "boost\_mode": "replace" \newline \} \newline \}, \newline "sort": \{ \newline "\_score": \{ \newline "order": "desc" \newline \} \newline \} \newline \}} \tn
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}
% That's all folks
\end{multicols*}
\end{document}