We have a stored value on a web part which is a PIPE separated list of NodeGUIDs, which also indicate the custom sort order of the selected items.How would we use the stored value to retrieve the l...

I'm about to try an upgrade from Kentico 9 to 10. I had to change a column from varchar to nvarchar.To do this I had to update an index so it didn't use the column and then remove a view, then adde...

I have a news page where I need to display DISTINCT News date month and year in the drop down. So I created a Query Repeater with Effect web part and I have this query insideSELECT DISTICT DAT...

I have a large amount of data from a previous site that I'd like to bulk import into my Kentico 11 build. I'd hoped to be able to do this with a SQL script (simple insert statements) but wasn't sur...

I am new to kentico cms.I am working on existing kentico project.In that one unigrid used for displaying record from database and for binding unigrid they were using "query" property of unigrid.But...

I have a Repeater set up on the page which is used to repeat Blog Posts. If the user clicks on the author a transformation is used to set ?author=[id] as a query parameter and lists all the blogs f...

Our website currently uses a catchall Page Type for news. This page type has a DDL which is used to specify the type of news (article, press release, video, etc.) it is, and then through the magic ...

I have a list of events that are shown on "Events" page using a repeater. Each event is a page type and has a field "EventStartDateTime". I want to show only those events where the event start date...

I want to query all the CMS_Document.[documentName]s where custom_page_type.[custom_field] = 'Y'. How in Kentico's database do you relate a custom table (representing a pagetype you've created) to ...

I don't typically write custom SQL queries, so please forgive the inefficiencies in the following test code. I'm trying to retrieve data from both a page type (table) and a custom table via a Query...