topic Custom search module for site pages and HubDB rows in CMS Development

Custom search module for site pages and HubDB rows

annaboateng — Fri, 05 Jul 2024 17:25:18 GMT

Hi, I am trying to create a custom search page that searches both site pages and a HubDB table (the table has a URL row that references external pages).

I tried cloning the default search input page and edited the "Search results include" options to include a hubDB table. I also added a hidden input type with the table name.

{% if module.content_types.hubdbtable_field %}
<input type="hidden" name="table_name" value="testing_search">
{% endif %}

I am assuming there is more to it than this, and I am not even sure if its even possible to combine search results in this way. The requestURL for internal pages must be different from the requestURL for HubDB rows...?

I am new to CMS dev and know only basic JS so any help would be much appreciated!

Re: Custom search module for site pages and HubDB rows

Phil_Vallender — Mon, 08 Jul 2024 09:10:33 GMT

Hi @annaboateng

As far as I am aware it may not be possible to customise the native HuBSpot search module to search in and return results from within a HubDB table. Other discussions on the topic appear to be inconclusive:

If the content has indexable pages, either auto-generated or linked, my suggestion would be to look at implementing a thirdparty solution instead - something like Swiftype or Site Search 360.

Hope this helps.

Re: Custom search module for site pages and HubDB rows

annaboateng — Mon, 08 Jul 2024 15:20:34 GMT

Yeah I have been searching all over for an answer to this but could not find a conclusive answer.

I was able to add the HubDB table as an search option in the design manager but not sure where to go from there

Re: Custom search module for site pages and HubDB rows

NChappell — Fri, 22 Nov 2024 16:36:09 GMT

Did you ever find a solve for this other than the suggestions from Phil?

Re: Custom search module for site pages and HubDB rows

annaboateng — Fri, 22 Nov 2024 20:02:48 GMT

I ended up creating a search page with two custom modules in it, one was the regular search module and one that filtered a hubDB table and returned the results as a list. I set the queryParam to use the search term in the url.

There are probably more elegant solutions but this worked for our purposes!

For the custom HubDB search module:

{% set queryParam = "" %}
{% set searchTerm = request.query_dict['term'] %}

{% set queryParam = "tags__icontains="~searchTerm %}

{% if searchTerm %}
<p>
<b>Suggested Support Articles</em>
</p>
<ul>
{% set rows = hubdb_table_rows(module.hubdbtable_field, queryParam) %}
{% for row in rows %}
<li><a href="{{ row.url }}">{{ row.title }}</a></li>
{% endfor %}
</ul>
{% endif %}