where on DevNet

Display specifc documents with where condition

web dev — May 29, 2020 — Question

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

How do I select offset documents in Kentico?

Lambert Chan — Jun 17, 2019 —

sql where kentico

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

Where() in macro use variable or field name

Szymon Mosiolek — Sep 4, 2017 — Question

macro where

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

Displaying information following the number of items

Monjoie Dominique — Jun 1, 2017 — Question

count transformation where

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

REST API's Where clause

Yang Wen — Sep 9, 2016 — Question

rest where

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

why rest request return forbiden status code

benyamin jain — Sep 9, 2016 — Question

rest api where

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

repeater where clause string literal

Kàren Vaganyan — Apr 13, 2016 — Question

clause kentico 8.2 literal repeater string where

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

where condition in repeater

ramesh perera — Oct 27, 2015 — Question

repeater where

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

Invalid column name - When order / where clause applied to filter.

Shane Harris — Sep 18, 2015 — Question

conditions error filter order where

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