Different Result for Query on Server & Wappler

tofix

#21
"wheres": {
        "condition": "AND",
        "rules": [
          {
            "id": "tbl_locker_master.IsActive",
            "field": "tbl_locker_master.IsActive",
            "type": "double",
            "operator": "equal",
            "value": "1",
            "data": {
              "table": "tbl_locker_master",
              "column": "IsActive",
              "type": "number"
            },
            "operation": "="
          },
          {
            "id": "tbl_locker_master.Cabinet",
            "field": "tbl_locker_master.Cabinet",
            "type": "string",
            "operator": "equal",
            "value": "CB1",
            "data": {
              "table": "tbl_locker_master",
              "column": "Cabinet",
              "type": "text"
            },
            "operation": "="
          },
          {
            "condition": "OR",
            "rules": [
              {
                "condition": "AND",
                "rules": [
                  {
                    "id": "lkm.IsActive",
                    "field": "lkm.IsActive",
                    "type": "double",
                    "operator": "equal",
                    "value": "1",
                    "data": {
                      "table": "lkm",
                      "column": "IsActive",
                      "type": "number"
                    },
                    "operation": "="
                  },
                  {
                    "id": "lkm.ToSwap",
                    "field": "lkm.ToSwap",
                    "type": "double",
                    "operator": "equal",
                    "value": "0",
                    "data": {
                      "table": "lkm",
                      "column": "ToSwap",
                      "type": "number"
                    },
                    "operation": "="
                  }
                ],
                "conditional": null
              },
              {
                "condition": "AND",
                "rules": [
                  {
                    "id": "lkm.IsActive",
                    "field": "lkm.IsActive",
                    "type": "double",
                    "operator": "equal",
                    "value": "0",
                    "data": {
                      "table": "lkm",
                      "column": "IsActive",
                      "type": "number"
                    },
                    "operation": "="
                  },
                  {
                    "id": "lkm.ToSwap",
                    "field": "lkm.ToSwap",
                    "type": "double",
                    "operator": "equal",
                    "value": "1",
                    "data": {
                      "table": "lkm",
                      "column": "ToSwap",
                      "type": "number"
                    },
                    "operation": "="
                  }
                ],
                "conditional": ""
              }
            ],
            "conditional": null
          }
        ],
        "conditional": null,
        "valid": true
      }

PHP and MySQL - Yes.


assigned patrick #22

unassigned patrick #24