Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 6.x > Portal Engine > Filter sql search results

View modes:

Member

morgot666-mail - 11/8/2011 1:03:41 PM

Filter sql search results

Hello. I have a problem with SQL search results web part.
I have document type 'vacancy' with custom field 'CityID'.
I am using SQLSearchResult web part to show results using query string parameters. I search vacancies by all fields (name, description etc), but also i need to filter results by CityID, but if I write WHERE statement 'CityID'={%cityid%} in web part parameters I get error that column CityID doesn't exist.

Thanks.

Member

kentico_michal - 11/10/2011 2:14:16 AM

RE:Filter sql search results

Hello,

The sql search uses CMS_View_Tree_Joined and since document data are not included in this view you receive the error message.

You could use a repeater web part for this purpose. In document types you can select your document type and define Where condition the same way as in the SQL search web part. It will display a document with a defined CityID.

Best regards,
Michal Legen

Top