DataTime user filter

Hi Vattikundala Dinesh could try this code and let me know this meets your requirement

a!queryEntity(
  entity: /*your DSE*/,
  query: a!query(
    logicalExpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "date",
          operator: ">=",
          value: ri!startDate
        ),
        a!queryFilter(
          field: "date",
          operator: "<=",
          value: ri!endDate
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 50
    )
  ),
  fetchTotalCount: false
)

Vattikundala Dinesh  You can try this

   a!queryFilter(
      field: /*Replace with your createdOn Field*/,
      operator: "between",
      value: {
        todatetime("04/06/2024 1:00 am"), /*Add You StartDate*/
        todatetime("04/16/2024 2:00 am")  /*Add Your EndDate*/
        
      }
    )

But i am trying this for the userfilter field in record type ?

how to do the above functionality in user filter in record type?

hi Vattikundala Dinesh  are you looking this type of user filter in record type search ?

Hi Abhishek Karumuru yes along with that i need time as well to filter the records

Vattikundala Dinesh 
You go through this to understand date Range filter in record.


https://docs.appian.com/suite/help/24.1/filter-the-record-list.html#:~:text=To%20create%20a%20date%20range,Filter%20Type%2C%20select%20Date%20Range.

is the above one will give me the date and time filter  in user filter record type?

hiVattikundala Dinesh  AFAIK, you cannot show time in record date range user filter, you need add manually date time field and pass your value and filter your query data, based on the data time given . Please find the example below code for reference

a!localVariables(
  local!startDte,
  local!endDte,
  
 {
 
  a!dateTimeField(label: "start",value: local!startDte,saveInto: local!startDte),
  a!dateTimeField(label: "end",value: local!endDte,saveInto: local!endDte),
  
  a!gridField(
    data: :/*your query rule*/(startDate: local!startDte,endDate: local!endDte).data,
    columns: {
      a!gridColumn(
        label: "col1",
        value: fv!row.id
      ),
      a!gridColumn(
        label: "col2",
        value: fv!row.data
      ),
      a!gridColumn(
        label: "col3",
        value: fv!row.date
      )
    }
  )
  
  }
  )