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

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