ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Welcome!

This spreadsheet contains all the possible search terms for exiletrade. As these worksheets are actually loaded by the site.

The Search Terms are separated into different sheets for easier navigation.
3
4
5
6
Columns on each sheet:

1. Regex - This is the regular expression which is used to match the input search term
2. Query - This is the resulting query that will be sent to ExileTools API
3. Filter - A special code that can be applied to the regex captured group - currently only used by buyout terms.
4. Sample1, Sample2, SampleN - Provides a sample actual input from the user. This is also conditionally
formatted to tell if the regex supports the sample (green) or not (red).
7
8

We need help:
- adding up more search terms
- adding samples

If you wanna contribute, feel free to contact us at:
Just in case you feel reading.
Below are links that would give you a better idea on how everything works.
9
10
Introduction to Regex:
http://regexone.com/
11
ExileTools Indexer Mapping Documentation:http://exiletools.com/info/indexer-docs.html
12
ElasticSearch Query String Documentation:
https://www.elastic.co/guide/en/elasticsearch/reference/2.2/query-dsl-query-string-query.html
13
Gitter Github Group Chat
14
Official Forum Thread
15
16
17
Dev notes:

ExileTrade loads these worksheets via url like this:

https://docs.google.com/spreadsheets/d/1jG2gzYuAukoJtYonlWghbkk9m5W6yGzM21cscpqJ5TU/gviz/tq?tqx=out:html&tq=SELECT+A,+B,+C&gid=675822745&headers=1

Notice that we specify columns A, B and C. ExileTrade will expect that first column is the regex, next is query, third is filter. Note that the ff does not matter:
1. Column names in the worksheet. As we specify columns via letters.
2. Worksheet Tab name. As we specify the worksheet via gid.

tqx - this specifies the output type, can be out:html or out:csv, otherwise it will be json. ExileTrade uses csv format.
tq - this is the query language defined by google visualization language api
headers - specifies header config
gid - the unique id of the worksheet

For higher-level search terms (HLST), make sure to enclose in parens as that might trip up the user input. For example, `Sai OR `GeminiClaw should be (`Sai OR `GeminiClaw).
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100