Not Exist between this date

Question

Hi everyone, Can appian do this query? I would like to query all of the data of the merchant without transaction between a specified date range and show it in the read-only grid, I already have view table but I can show all of the merchant without transaction between a specified date range.

Abhay Dalsaniya · Answer

Appian a!queryFilter() supports " BETWEEN " operator however it does not support something like NOT BETWEEN. To achieve the same you can refer to the code below. a!queryEntity( entity: cons!ENT_MERCHANT, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "transaction", operator: "is null" ), /* Option-1 To get the data BETWEEN two dates*/ a!queryFilter( field: "transactionDate", operator: "between", value: {"01/01/2022","12/31/2022"} ), /* Option-2 To get the data NOT BETWEEN two dates*/ /*a!queryFilter(*/ /*field: "transactionDate",*/ /*operator: "<",*/ /*value: */ /*),*/ /*a!queryFilter(*/ /*field: "transactionDate",*/ /*operator: ">",*/ /*value: */ /*)*/ }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ) )

Not Exist between this date

Top Replies