Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 6.x > Portal Engine > search results from custom document

View modes:

Member

sdonthineni-allianceglobalservices - 6/3/2012 5:00:15 AM

search results from custom document

1)

I have created custom document type with fields(Title,FirstName,LastName,Computer)
and i have binded the custom document type with cloned user contributions web part (modified the user contribution columns as custom document field names).

2) I have added smart search text on top of the user contributions and added search condition in where clause of user contributions

3) i wanted to search the custom document field columns but it is searching from different table but not the table created as part of custom document type.

Can you please suggest any solution for this.

Thanks
Surendar.D

Kentico Developer

kentico_ivanat - 6/3/2012 8:14:42 AM

RE:search results from custom document

Hi,

documents in user contribution web part are selected a similar way as here:

SELECT * FROM View_CMS_Tree_Joined_Versions WHERE ((((NodeSiteID = 2) AND (Published = 1)) AND (DocumentCulture = N'en-US')) AND (NodeAliasPath LIKE N'/Community/Wiki/%')) AND (ClassName IN ('CMS.SimpleArticle'))

This view contains only document, node and SKU data. So you cannot filter these data using custom document type fields.

The way you can use is to use smart search module as was suggested in one of previous -email.

Or you can modify a contribution list control more and select data by your own in a custom query data grid.

Best regards,
Ivana Tomanickova


Kentico Developer	kentico_ivanat - 6/3/2012 8:17:00 AM RE:search results from custom document Or one more idea. In a code behind you can use smart search code to find results. From data set you can only select documentID fields which could be used directly in a user contribution list web part. Something like: DocumentID IN (20,33,40) Best regards, Ivana Tomanickova


Member	sdonthineni-allianceglobalservices - 6/12/2012 9:48:32 AM RE:search results from custom document Can you please suggest step by step ,i am not get it.. thats would be a great help


Member	sdonthineni-allianceglobalservices - 6/12/2012 10:02:43 AM RE:search results from custom document can you please help me in providing the custom query which i can use

Kentico Developer

kentico_ivanat - 6/19/2012 5:18:36 AM

RE:search results from custom document

Hi,

you can use our consuliting service and we will provide you with step by step examples.

The smart search API example part based on which you can find appropriate IDs, you can find here:
Smart search API

Maybe the easiest solution would be to define a custom view in a database and used it with a grid control in a custom web part:
Developing web parts
Custom query data grid

Best regards,
Ivana Tomanickova

Top