Hi, I have page that display list of pages by using repeater. The repeater display the pages according the path field. I have created drop down list with the following text: - All Dates -Past 12 mo...
Kentico 12 portal engine:I am building out a custom query that will take the A/B testing cookie and pass it into a SQL query. What's the easiest way (at a high level) of passing a cookie into a we...
Hello guys,I want know how to add an input(field) on sql query.---QUERY---- IF THIS input IS NULL THEN SELECT ...Thank you
I am trying to query blog posts on my website using a data source web part.Using a SQL where clause in my data source I am doing the following to grab by category from the query string:('{%ToInt(Qu...
I have a form with 2 dropdown fields. The value of the first needs to be taken into account when populating the data source of the second. I have the dependant field checkboxes correctly set.I've t...
I'm trying to list several child pages based on most recent date, however for some sections I want the top 3 documents and some areas the rest of the articles from the same folder.My current SQL st...
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...