Dears, i have layout where left side i have bullet link (repeater webpart), and right side have content (repeater with custom query webpart). on click of the link in left side i m able to change co...

I've had great success customizing my sitemap with the Sitemap webpart and specifying my custom page types and the directories, however for a great deal of pages, we generate them using information...

hello kentico dev i use repeater with custome query to display two date (NewsStartDate,NewsEndDate) and here is my query (SELECT DISTINCT NewsStartDate,NewsEndDate FROM cms.news order )i but i dont...

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,I often work with repeaters with custom query.How can I only get the documents with a 'Published' status (like the option 'Select only published' in a simple repeater).I noted that all is dis...

Hello, I have a custom query repeater with this as the querySelect * From MMH_EmployeeTracker ##WHERE## In the control I have the where condition set to Where UserName = '70'I get this error in th...

How can I execute some of the predefined queries in CMS_Queries within a macro expression?Example: {% Queries[@cms.user.selectbyusername@] #%} Which is basically this in SQL: SELECT * FROM CMS_User...

hiHow it is possible to execute Custom Query via Rest service?any one can provide a sample?at this time when i want to use rest for macro it always log security error in event log , event with glob...

Hi there,In many of the Kentico sites I build I often use a Universal Viewer with a Hierarchical transformation to display a list of nicely styled document type transformations. Using this approach...

Hi there,We are using Kentico 8.0. and trying to find some example How to pass parameters to stored procedure. Here is what I'm trying to do1- I have a stored procdure CREATE PROCEDURE Proc_Custo...