Search code examples
google-app-maker

Calculated_SQL Table - Search

i have done a calculated sql with a custom query.

Implemented a table from that data model. Until here we are ok.

My problem is the next step: In my custom query i have a field concatAll(that is all fields concatenated). In my page i want to put a search box to do a "contains" search in my field concatAll and present those results in my table.

Anyone knows how to do this?

Tried multiple approaches, but could not have the result.

Thanks

Solution

  • As @Pavel Shkleinik send to me this is possible using :params in the query of calculated_sql. Example: or (c.phone like concat(CONCAT("%", ifnull(:concatAll,''), "%"))) and you put concatAll as a string parameter on datasource page.

    Regards