I have an OLD site .. still done with wappler 2.4 i think.. I need a temp solution for LIMIT value on a query please

I have an OLD site … still done with wappler 2.4 i think… I need a temp solution for LIMIT value on a query please… i dont want to just update the site with new CODE in wappler as it will break loads of other queries… and will cost me to redo the complete site NOW…

For now i need just to apply a quick LIMIT to QUERY … that was created back then…

@ben i know you are the go to guy with simple things (*for you) but does our normal peoples head in…


     {
                "table": "blog",
                "column": "intros",
                "bool": "or",
                "operator": "contains",
                "value": "{{$_GET.filter_blog}}",
                "type": "text",
                "condition": "{{$_GET.filter_blog}}"
              },
              {
                "table": "blog",
                "column": "content",
                "bool": "or",
                "operator": "contains",
                "value": "{{$_GET.filter_blog}}",
                "type": "text",
                "condition": "{{$_GET.filter_blog}}"
              }
            ],
            "orders": [
              {
                "table": "blog",
                "column": "dates",
                "direction": "DESC",
              }
            ],
            "joins": []
          }

Where can I add LIMIT to make this work…

Has anyone manually added a LIMIT to an older “QUERY”
Maybe something like this?

     {
                "table": "blog",
                "column": "intros",
                "bool": "or",
                "operator": "contains",
                "value": "{{$_GET.filter_blog}}",
                "type": "text",
                "condition": "{{$_GET.filter_blog}}"
              },
              {
                "table": "blog",
                "column": "content",
                "bool": "or",
                "operator": "contains",
                "value": "{{$_GET.filter_blog}}",
                "type": "text",
                "condition": "{{$_GET.filter_blog}}"
              }
            ],
            "orders": [
              {
                "table": "blog",
                "column": "dates",
                "direction": "DESC",
              }
            ],
           "limit" : [
            {
            "LIMIT" : 10,
            }
           ],
            "joins": []
          }
Community Page
Last updated: