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...

Hello Kentico Team,I am trying to build a simple report for the total number of page views for all blog posts within a certain blog.My code so far returns all of the page views for all of the pages...

I have a user area where I need logged in users to edit data that is stored in a Kentico custom table. I could also use a straight SQL table. What is the best way to do this? I am struggling with...