Bar chart user filter validation

HI Bruno, If you are querying data based on filters then add the date validation condition  while querying the data as well. i suppose you are querying data in a local variable , if so then add a conditon in the filter parameter based on date validation. below is an basic example ,

a!localVariables(
  local!data:a!queryEntity(
    entity: cons!entity_emp,
    query: a!query(
      pagingInfo: a!pagingInfo(startIndex: 1,batchSize: -1),
      filter: a!queryFilter(
        field: "id",
        operator: "=",
        value: ri!id,
        applywhen: local!startDate<local!endDate
      )
    )
  )
)

HI Bruno, If you are querying data based on filters then add the date validation condition  while querying the data as well. i suppose you are querying data in a local variable , if so then add a conditon in the filter parameter based on date validation. below is an basic example ,

a!localVariables(
  local!data:a!queryEntity(
    entity: cons!entity_emp,
    query: a!query(
      pagingInfo: a!pagingInfo(startIndex: 1,batchSize: -1),
      filter: a!queryFilter(
        field: "id",
        operator: "=",
        value: ri!id,
        applywhen: local!startDate<local!endDate
      )
    )
  )
)

Ty 4 reply !

Sorry, maybe I wasn't so clear: I wanna validate the inputs, instead the result. If user's input not satisfy my condition, report shouldn't to refresh. Pretty much like Javacript validation, preventing a post.

Hi Bruno,

Given what you're looking for I would do an if() statement within the saveInto. Something like the below. You can also have an validation parameter that shows up as expected when this happens so the user knows, you'd just have to validate based on the tempDate variable.

saveInto: {
local!tempDate,
    if(
        local!tempDate>local!dateTwo,
        a!save(local!tempDate, null),
        a!save(local!dateOne, local!tempDate)
    )
}