Forums (Obsolete)

Portal Engine Questions on portal engine and web parts.

Version 7.x > Portal Engine > Display(list) bizform records in front end website(*not cmsdesk etc)

View modes:


Member	ypezlzfw-sharklasers - 9/16/2013 6:44:24 AM Display(list) bizform records in front end website(not cmsdesk etc) is it possible to Display(list) bizform records in front end website ? (not cmsdesk etc) is it possible without custom code ? (ie editing vb etc).

Kentico Support

kentico_romank - 9/16/2013 7:00:42 AM

RE:Display(list) bizform records in front end website(*not cmsdesk etc)

Hi,

Yes, it is possible. In CMS Desk select the page where you want to display bizForm data. On that page place QueryDataSource web part and Basic Repeater. Now open the settings of QueryDataSource web part and there is a property called Query name - this is the place where you should use your query. And then simply bind QueryDataSource web part with Basic Repeater web part.

I hope this help. Best Regards,
Roman Konicek


Member	ypezlzfw-sharklasers - 9/16/2013 10:34:06 AM RE:Display(list) bizform records in front end website(*not cmsdesk etc) Hi Roman, Ive been able to display custom tables using this, would i be able to display form records ? would i have to create my own transformations for these ?


Kentico Legend	Brenden Kehren - 9/16/2013 12:51:27 PM RE:Display(list) bizform records in front end website(*not cmsdesk etc) Yes, you'd most likely have to create a new doc type that was simply a holder of that type of information (queries, transformations, etc) and select that doc type's transformation for your query repeater.

Kentico Support

kentico_romank - 9/18/2013 3:39:48 AM

RE:Display(list) bizform records in front end website(*not cmsdesk etc)

Hi,

I would recommend you to create document type which is only a container, as FroggEye mentioned. Then in query data source web part, select this document type and put there a query. It could look like this:

SELECT [ContactUsID]
,[FormInserted]
,[FormUpdated]
,[FirstName]
,[LastName]
,[Email]
,[PhoneNumber]
,[Message]
FROM [KenticoCMS_7_zero].[dbo].[Form_ContactUs]

Then open the properties of basic repeater web part and simply put something like this to the transformation:

<%# Eval("FirstName") %>

I hope this helps.

Best Regards,
Roman Konicek

Top