waveQl Playground

Reset / initialise database (disabled in config)

Write mode is disabled. Only read operations allowed.
📋 Manifest
##### tableManifest{
    "tableName": "countries",
    "tableKey": "c",
    "joinList": [
        {
            "type": "LEFT",
            "tableName": "continents",
            "tableKey": "cnt",
            "connectColumn": "id",
            "connectWith": "c.continent_id"
        }
    ]
}
##### keyManifest{
    "AreaKm2": {
        "rowName": "c.area_km2",
        "type": "integer"
    },
    "Capital": {
        "rowName": "c.capital",
        "type": "string"
    },
    "ContinentId": {
        "rowName": "cnt.id",
        "type": "integer"
    },
    "ContinentName": {
        "rowName": "cnt.name",
        "type": "string"
    },
    "CountryName": {
        "rowName": "c.name",
        "type": "string"
    },
    "FoundedDate": {
        "rowName": "c.founded_date",
        "type": "date"
    },
    "Population": {
        "rowName": "c.population",
        "type": "integer"
    },
    "~meta~": {
        "sort": ">CountryName",
        "pageSize": 20,
        "searchTarget": "CountryName,Capital,ContinentName"
    }
}
🔍 Current Filter
##### setValues:[]
##### setMeta:[]
📄 Generated SQL
No query generated yet.
🎛️ Filters / Write Input
FieldValueintegrate in
Fulltext-Search
⚙️ Meta (sorting, pagination)
🎮 Control