Can't set or change JOIN settings in DB Query Bulider

Server Side Components Bugs
1

Wappler 4.4.2
NodeJS
MariaDB 10.1.48

Can't change any of these settings
image

Demo

File:

{
  "meta": {
    "$_GET": [
      {
        "type": "text",
        "name": "sort"
      },
      {
        "type": "text",
        "name": "dir"
      }
    ]
  },
  "exec": {
    "steps": {
      "name": "query",
      "module": "dbconnector",
      "action": "select",
      "options": {
        "sql": {
          "type": "SELECT",
          "columns": [],
          "table": {
            "name": "team_in_game"
          },
          "joins": [
            {
              "table": "team",
              "column": "*",
              "alias": "team123",
              "type": "INNER",
              "clauses": {
                "condition": "AND",
                "rules": [
                  {
                    "table": "team123",
                    "column": "id",
                    "operator": "equal",
                    "value": {
                      "table": "team_in_game",
                      "column": "id"
                    },
                    "operation": "="
                  }
                ]
              }
            }
          ],
          "query": "SELECT *\nFROM team_in_game\nINNER JOIN team AS team123 ON (team123.id = team_in_game.id)",
          "params": []
        },
        "connection": "dbconnection1"
      },
      "output": true,
      "meta": [
        {
          "type": "number",
          "name": "id"
        },
2

This has been reported already and will be fixed in this weeks update:

3

Indeed, sorry. I didn’t check all bugs category, just watched for “server side”.

4

This has been fixed in Wappler 4.4.3

6

This topic was automatically closed after 47 hours. New replies are no longer allowed.