# Gems of War Sleuth - Advanced Troop Finder
**URL:** https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004
**Category:** Community Content
**Created:** [January 5, 2021, 6:44pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004 "2021-01-05T18:44:14Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 5, 2021, 6:44pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/1 "2021-01-05T18:44:14Z")
[https://slothies.neocities.org/gow/](https://slothies.neocities.org/gow/)
The GoW Sleuth is an unofficial database for the match-3 game “Gems of War” based on Lyya’s GoWDB API.
Sleuth’s primary goal is to be a fast, more advanced alternative to GoW’s in-game search allowing for more complex queries.
* * *
**Features:**
- Search results can be sorted and filtered by various criteria.
- Search terms and categories can be combined in various ways.
- Filters can be bookmarked and shared.
**Links to example queries:**
- [Directly compare troops](https://slothies.neocities.org/gow/?q=~~rowanne%3Ftesla%3Favatar%3Fketras)
- [Find troops summoning storms at the start of battle or their turn](https://slothies.neocities.org/gow/?q=~~__start%3Fturn%20storm)
- …[but exclude bonestorms and doomstorms](https://slothies.neocities.org/gow/?q=~~__start%3Fturn%20storm%20!bonestorm%20!doomstorm)
- [Find troops with increased mana starts](https://slothies.neocities.org/gow/?q=~~__fast%3Fempowered%3Fswift)
- [Find increased mana start troops modifying gems for purple guild wars day](https://slothies.neocities.org/gow/?q=~000010~_gem_fast%3Fempowered%3Fswift)
- [Find troops modifying gems on the board](https://slothies.neocities.org/gow/?q=~~_gems%20transform%3Fconvert%3Fexplode%3Fdestroy%3Fcreate%3Fdouble%3Fremove)
- [Find troops modifying skulls on the board](https://slothies.neocities.org/gow/?q=~~_skull%20transform%3Fconvert%3Fexplode%3Fdestroy%3Fcreate%3Fdouble%3Fremove)
* * *
More details can be found in the ‘ **Help** ’ section on the website.
The interface is available in English and German, other languages were machine-translated.
Contact me on the forums or post in this thread if you want to help translate, if you have suggestions, feedback or want to support me in some other way.
-sls
---
### Author:  [@mitamata](https://community.gemsofwar.com/u/mitamata)
#### Post date: [January 5, 2021, 7:07pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/2 "2021-01-05T19:07:35Z")
I only took a quick look for now, but WOW!!! 😃 This is awesome, thanks so much for the effort and for sharing ❤ I’ll have to learn all the tricks to search, looking forward to it 😃
---
### Author:  [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)
#### Post date: [January 5, 2021, 7:13pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/3 "2021-01-05T19:13:59Z")
Seems neat!
Just a personal opinion here, the interface/queries are super hard for me to understand.
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 6, 2021, 2:57pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/4 "2021-01-06T14:57:12Z")
**Update:**
- Added German translation for UI and help
- Minor changes to the help section
- Input fields should now update when pasting on mobile Safari
@NerdieBirdie Sorry to hear ☹. Any idea what would help?
---
### Author:  [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)
#### Post date: [January 6, 2021, 3:06pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/5 "2021-01-06T15:06:24Z")
If there were some way to make the queries into buttons or something more user-friendly I think that would help a lot!
---
### Author:  [@rbchaffe](https://community.gemsofwar.com/u/rbchaffe)
#### Post date: [January 6, 2021, 3:57pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/6 "2021-01-06T15:57:01Z")
Wonderful. 👍
I searched for traits: fortitude?impervious?sturdy?undying
Works beautifully to see all of the troops immune to poison.
May we have the ability to sort by Kingdom?
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 6, 2021, 5:09pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/7 "2021-01-06T17:09:35Z")
@rbchaffe Nice! Putting it on my todo.
@NerdieBirdie I’ll give it some thought. Right now I don’t really see how that could be accomplished without sacrificing flexibility ☹
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 7, 2021, 2:01pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/8 "2021-01-07T14:01:08Z")
- Added ‘ **Sort by kingdom** ’ and ‘ **Sort by type** ’
- Minor changes to icons, colors / font sizes for smaller phones
- Small bugfixes
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 10, 2021, 6:03pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/9 "2021-01-10T18:03:39Z")
- Added ‘ **Match at least one color** ’.
This is the color restriction mode used for Delves and World Events.
- You can now browse weapons. Pretty rudimentary, though.
- You can now paste team codes. Again, pretty rudimentary.
---
### Author:  [@Nullings](https://community.gemsofwar.com/u/Nullings)
#### Post date: [January 13, 2021, 4:24am UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/10 "2021-01-13T04:24:56Z")
I opened the link and saw “917 results” for troops. But the game has 924 troops ATM. Something is missing?
And I also can’t see “Magic” for troops.
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 13, 2021, 10:55am UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/11 "2021-01-13T10:55:28Z")
- Sort order is now preserved between searches
* * *
Underworld treasure troops (6 in total) aren’t included. Leaves one missing troop - ‘Daemon Gnome’. Pinging @Lyya!
I’ll add ‘Magic’ with the next bigger update.
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [January 17, 2021, 1:34pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/12 "2021-01-17T13:34:04Z")
- You can now search for exact order of terms using quotes. E.g.: [“boosted by my”](https://slothies.neocities.org/gow/?q=71~000000~_%22boosted%20by%20my%22) vs [boosted by my](https://slothies.neocities.org/gow/?q=71~000000~_boosted%20by%20my)
- Bookmarks/links now include the **last** used sort order
- Traits are now searched individually, reducing the number of false positives
- Scrolling should be much faster
- Misc changes & fixes
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [March 5, 2021, 3:15pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/13 "2021-03-05T15:15:55Z")
Only lightly tested.
- You can now filter by troop roles
- Bookmarks are much shorter now
- Bookmarks containing characters outside the ASCII range should work now
- Misc bug fixes
Note: I no longer test iOS \<13
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [April 17, 2021, 8:09pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/14 "2021-04-17T20:09:42Z")
- Terms containing whitespaces can now be combined with the **?** ( **OR** ) operator thanks to the power of parantheses: [true (“damage to the last”?“damage to the first”)](https://slothies.neocities.org/gow/?q=~~_true%20(%22damage%20to%20the%20last%22%3F%22damage%20to%20the%20first%22)~)
- Weapon artwork has been added
- Spell names have been added
- You can now search for magic multipliers [spell field \> magic\*](https://slothies.neocities.org/gow/?q=~~_magic*~)
- Search fields now auto-expand to accommodate longer queries
- A breakdown by kingdoms, types, rarities and roles has been added
There were quite a few changes under the hood, I likely broke something.
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [August 17, 2021, 2:18pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/15 "2021-08-17T14:18:08Z")
- The breakdown-view now lists percentages relative to your search results’ totals
- The breakdown-view now lists mana colours
- Minor changes and visual tweaks to card artwork
---
### Author:  [@sls](https://community.gemsofwar.com/u/sls)
#### Post date: [August 18, 2022, 10:06am UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/17 "2022-08-18T10:06:34Z")
Thanks for letting me know!
I tried with an older and a newer version of Firefox on both Windows and Android and those seem to load fine. Maybe just a hiccup on the host’s end that can be fixed by a reload (Ctrl-R/F5)?
---
### Author:  [@tweedle](https://community.gemsofwar.com/u/tweedle)
#### Post date: [August 18, 2022, 3:41pm UTC](https://community.gemsofwar.com/t/gems-of-war-sleuth-advanced-troop-finder/68004/18 "2022-08-18T15:41:35Z")
Not sure what the issue was, it works now, thank you for the fantastic tool!