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

Samples OperationsINSERT INTO Customer ( FirstName, LastName, Email, PhoneNumber) VALUES ( @FirstName, @LastName, @Email, @PhoneNumber)SELECT CustomerID, FirstNa...

Need to list what roles have Modify permission for a given TreeNode. I need a SQL query. Thanks