Hello.
I’m trying to create a search module for my site using Site Search Input module.
I have a couple of questions.
Is there a way to specify a specific HubDB column to search by? If not, are there alternatives?
Should such column be printed in the template?
Thank you in advance.
Hi in order to help you I need more info. The search functionality that is embeded in hubspot will use a parameter in the url to search all your site. So, are you trying to search a table you have in hubdb? if that is the case you can use pass a value to the url and use that to filter the table
{% for row in hubdb_table_rows(<tableId>, <filterQuery>) %}
the value for row {{ row.hs_id }} is {{ row.<column name> }}
{% endfor %}
this is an example
{% set filter = '&orderBy=-hs_created_at' %}
{% set testimonials = hubdb_table_rows(999, filter) %}
{% if testimonials %}
{% for row in testimonials %}...
this are the options you have for filters is the same as the API
EDITED:
You can use {{ request.query }} to get the parameters in the url you are passing example… www.mydomain.com/page?find=this is the text you want
this variable will give you access to the query of your url to use it in your search