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

Wappler General How To
#1

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": []
          }
#2

limit is just a number

     {
                "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": [],
            "limit": 10
          }
1 Like
#3

@patrick thank you Patrick… yes it might seem simple to a few. but yes to some this can take the forever to try and do it yourself… but at least one try before just asking…

thank you once again for the help and making my life easier.

1 Like