simimpact custom query examples

[srliao]

How to use

Copy and paste the code block (modifying to your requirement) into the custom query box at the top of the filter selections:

Note that using custom query will ignore any other UI options you have selected (like character filter). They cannot be both used at the same time (maybe for future...)

Examples

Filtering by submitter Discord ID (copy Discord ID by right clicking on the user's name in Discord), replace the 12345 with actual id:

{
    "submitter": {
        "$eq": "12345"
    }
}

Filter by target count:

{
    "summary.target_count": 2
}

Filter by characters (i.e) includes:

{
    "summary.char_names": {
        "$all": ["nilou", "furina"]
    }
}

Special case for Traveler (due to lumine vs aether both being valid)

{
  "$and": [
    {
      "summary.char_names": "nilou"
    },
    {
      "summary.char_names": {
        "$in": ["luminedendro", "aetherdendro"]
      }
    }
  ]
}

Same as above but this time no Nilou

{
  "$and": [
    {
      "summary.char_names": {
        "$ne": "nilou"
      }
    },
    {
      "$or": [
        {
          "summary.char_names": "luminedendro"
        },
        {
          "summary.char_names": "aetherdendro"
        }
      ]
    }
  ]
}

Using regex to search entry descriptions. More on what's allowed for $regex here

{
    "description": {
        "$regex": "national"
    }
}

Using regex to search configs

{
    "config": {
        "$regex": "national"
    }
}

[Charlie-Zheng]

Search for entries containing C6 Furina

{
    "summary.team": {
        "$elemMatch": { 
            "name":"furina",
            "cons": 6
        }
    }
}

[ErzaDuNord]

Here's a filter excluding five star constellations and weapons. It includes both standard and limited five stars. It's up to date with version 5.3 (Mavuika and Citlali and their signature weapons).

{
    "summary.team": {
        "$not": {
            "$elemMatch": {
                "$or": [
                    {
                        "name": { "$in": [
                        "albedo", "alhaitham", "aloy", "arlecchino", "ayaka", "ayato", 
                        "baizhu", "chasca", "chiori", "citlali", "clorinde", "cyno", "dehya", "diluc", 
                        "emilie", "eula", "furina", "ganyu", "hutao", "itto", "jean",
                        "kazuha", "keqing", "kinich", "klee", "kokomi", "lyney", "mavuika", "mona",
                        "mualani", "nahida", "navia", "neuvillette", "nilou", "qiqi",
                        "raiden", "shenhe", "sigewinne", "tartaglia", "tighnari", 
                        "venti", "wanderer", "wriothesley", "xianyun", "xiao", "xilonen",
                        "xianyun", "yaemiko", "yelan", "yoimiya", "zhongli"
                        ] },
                        "cons": { "$gte": 1}
                    },
                    {
                        "weapon.name": { "$in": [
                            "athousandblazingsuns", "athousandfloatingdreams", "absolution", "amosbow", "aquasimulacra",
                            "aquilafavonia", "astralvulturescrimsonplumage", "beaconofthereedsea",
                            "calamityqueller", "cashflowsupervision", "cranesechoingcall",
                            "crimsonmoonssemblance", "elegyfortheend", "engulfinglightning",
                            "fangofthemountainking", "freedomsworn", "harangeppakufutsu",
                            "hunterspath", "jadefallssplendor", "kagurasverity", "keyofkhajnisut",
                            "lightoffoliarincision", "lostprayertothesacredwinds", "lumidouceelegy",
                            "memoryofdust", "mistsplitterreforged", "peakpatrolsong", "polarstar",
                            "primordialjadecutter", "primordialjadewingedspear", "quantumcatalyst",
                            "redhornstonethresher", "silvershowerheartstrings", "skywardatlas",
                            "skywardblade", "skywardharp", "skywardpride", "skywardspine",
                            "songofbrokenpines", "splendoroftranquilwaters", "staffofhoma",
                            "staffofthescarletsands","starcallerswatch", "summitshaper", "surfsup", "thefirstgreatmagic",
                            "theunforged", "thunderingpulse", "tomeoftheeternalflow",
                            "tulaytullahsremembrance", "urakumisugiri", "verdict", "vortexvanquisher",
                            "wolfsgravestone"
                        ]}
                    }
                ]  
            }
        }
    }
}

[soloxcx]

hu tao should be hutao

[ErzaDuNord]

Fixed and updated

[jwalk-511]

Filter to include 1 or more characters, within a given constellation range, optionally allow other characters but keeping them below a con range if included, and completely exclude other characters.
Teams returned will include c0-c2 Hu Tao, c0-c1 Yelan, may include up to c0 Kazuha, and won't include Xilonen or Xingqiu.
Refer to Erza's comment, above, to expand the set of characters to exclude.
Something's wrong; results still include teams without Furina.

{
    "$and": [ 
    { "summary.team": {
        "$elemMatch": {                               
            "name": { "$in": [ "hutao" ] },
            "$or": [
                { "cons": { "$gte": 1, "$lte": 2 } },
                { "cons": null }
            ]             
        }
    } },

    { "summary.team": {
        "$elemMatch": {                               
            "name": {  "$in": [ "yelan" ] },
            "$or": [
                { "cons": { "$gte": 1, "$lte": 1 } },
                { "cons": null }
            ]             
        }
    } }, 

    { "summary.team": {
        "$not": {
            "$elemMatch": { "$or": [                               
                    {   "name": {  "$in": [ "kazuha" ] },
                        "cons": {"$gte": 1}   
                    },

                    {   "name": { "$in": [ "xilonen", "xingqiu" ] } }  
            ] }
        }
    } } 
    ]
}