Fetching data from DB on date range.

Question

Hello Everyone, 
 I am trying to achieve something like below in Appian. 
 select * from EMPLOYEE where '15-Nov-2018' BETWEEN START_DATE and END_DATE. 
 Note i need to fetch rows whose date range (From Start_Date and End_Date) falls within input date. 
 Above query must return me below data 
 Employee_Name || Start_Date || End_Date 
 Ricky Chaware || '01-Nov-2018' || '30-Nov-2018' 
 
 Is there any way to achieve this? 
 Thank you

ekanshj · Answer

Hi, 
 Hope this helps and is what you require a!queryEntity(
 entity: /* Employee Data Store Entity */,
 query: a!query(
 logicalExpression: a!queryLogicalExpression(
 operator: "AND",
 filters:{
 a!queryFilter(
 field: "START_DATE",
 operator: "<",
 value: /* 15-Nov-2018 */
 ),
 a!queryFilter(
 field: "END_DATE",
 operator: ">",
 value: /* 15-Nov-2018 */
 )
 }
 ),
 pagingInfo: a!pagingInfo(
 1,
 - 1
 )
 )
 )