Database Search on PowerCMS Site

I have a number of websites that I have added PowerCMS to and would now like to add a basic text search feature (using DataBridge) to the public pages.

Has anyone else done this?

Do you have any top tips?

What SQL did you use for the recordset?

are you looking to create a keyword search of the contetns?

The recordset would need to return the ContentValue column of the pcms2_contents table.


Then using DataAssist Search in databridge, you could create the keyword search form.

Hi Jason

Thats exactly what I'm trying to do.

The only thing that I couldn't figure out was how to create a link to a page with PowerCMS content within it.

How would I create a link to a page that has CMS content that is not created from a CMS Template?

There is not a way to link to the page that contains the content area, this is not known in the database.

i guess you could add a column to the contents table where you can store the name of the page that you add the content area to, but the default contents database only stores the content, it does not store information about the page the content is served on.