I'm having a really strange issue happen where my ##WHERE## clause is being removed randomly along with the WHERE in the SQL query itself. This started happening after I upgraded from K8.2 to K12 ...
Hello Dev i was trying to display data based on this code but display only 3 page type where field is true here is my code I already try it but get an error private void GetDataRowOutput(DataRowVi...
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...
Hi,I am building email template and want use macro with where() which will use variable or fild name. I have Order table with fieled @GarageId@ and Garage table have the same filed as @DealerId@ so...
I use a repeater with custom query to get datas from two tables ('society' and 'activities'). For each society, I have a lot of activities and in this table, I have a field with 2 possible values. ...
I know you can specify simple where clause in your queries against the REST API.Does it support the keyword BETWEEN? I've tried a bit and could not get it to work.I want to return from REST a subse...
HIWhy my rest request return Forbidden Status Code for the following request?http://localhost:1469/rest/customtableitem.cms.assignedbikes?where=IssuedCardID LIKE '271381890076' AND StationAssignorI...
I'm having trouble specifying a where clause in a repeater using a string. The where clause in my repeater has this:{% strPostedBy = Querystring.GetValue(@p@); return#%} {% if (strPostedBy == @RB@)...
HI!My site is kentico portal base site and there is a repeater there. and within the repeater i need to set the where clouse. there is a column called @startDate@ so within the where clouse i need ...
I'm trying to add a filter to a document list. I've modified my code from a version 6 install to run under 8 and it seems fine until the filter is applied. Looking that the error it seems that gene...