Filter

Hi Guys,

If I have to search the record based on assessment year For example, I select 2021 from the dropdown it must show me the record of  (Assessment from date(2021)) .See the attachment .

What filter should I apply here???

Thanks

DateRange.oml

Hi Rohan,

Use Year inbuilt function in aggregate filter some thing like Year(Date).

Best Regards

Devendra


Hello Rohan,

In the way you're implementing it, you could add a filter to your GetEmployeesByAssessmentfromdate query.

Year = NullIdentifier() or 
GetYear(Year).Year.Year = Year(Employee.Assessmentfromdate)

Hope it helps,

João

Hi,

In case of applying the filter, take one local variable and associate with dropdown widget. Then in aggregate filter

your local variable=NullIdentifier() or entity.attribute= your local variable.

This will produce filtered results.

I hope it will help you


Best Regards,

Tanisha

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.