Employee Name List with DOJ > Voucher Date

I have written the below code to get the employee name as list to display in mt invoice screen. But this collection is showing all the employees along with the other cost center names.

I want to display only the Employee name whose date of joining is greater than voucher date. How do i apply filter in a collection. Below is the code.


[Collection: EmployeeListPick]
Type: CostCentre
Fetch: ShowEmpDisplayName

[Field: My Field]
Table : EmployeeListPick, Not Applicable
Show Table : Always
Use: short name Field
Storage: EmployeeAllocatedName

 

hello,

Use the filter in your collection.

 

Yeah I found out. Thank you!!!

Sample Code for the same.

[Collection: EmployeeListPick]
Type: CostCentre
Fetch: Employee DisplayName
Title : $$LocaleString:"List of Employees"
Filter : EmployeeDeactiveInCurrDate
Filter : EmployeesFilter
Filter : NotEmployeeGroupFilter