With the help of the advanced filters (Ctrl + F3), you can create filters quickly and easily that lead to the desired information. The dynamic filters…
With the help of the advanced filters (Ctrl + F3), you can create filters quickly and easily that lead to the desired information. The dynamic filters relating to date, employee and user in particular can be set up once and always deliver up-to-date figures. Search function Description abc All records that have abc in the relevant field abc* Starting with “abc” *abc* Contains “abc” X..Z All values between X and Z (up to and including) ? Placeholder for a single character >X, <X Greater than / less than X X, Y, Z X or Y or Z !abc Not equal to “abc”; also works, e.g., “!A, !B” (neither A nor B) ““ Empty (greaterThanDate(x)) Greater than today + x days (lessThanDate(x)) Less than today + x days (day(x)) Today + x days (dayRange(x, y)) Today + x days .. today + y days e.g. today = 10.05.2016; dayRange(-3,0) à 07.05.2016 – 10.05.2016 (monthRange(x, y)) Start of month (today + x months) – end of month (today + y months) e.g. today = 10.05.2016; monthRange(-2,1) à 01.03.2016 – 30.06.2016 (yearRange(x, y)) Start of year (today + x years) – end of year (today + y years) e.g. today = 10.05.2016; yearRange(1,3) à 01.01.2017 – 31.12.2019 (currentEmployeeId()) Employee ID of the currently used user (currentUserId()) User ID of the currently used user With the help of the Dyxon Smart Query add-on, the possibilities can be extended even further. Instead of the standard Exist Join link to related tables in a query, Not Exist Join can be used to explicitly find data where a link is missing (e.g. all customers that have no contact person stored). Dyxon Smart Query also makes it possible to save filters and make them available to all employees. This way, a filter created with the parameters responsible employee = currentEmployeeID() and delivery date = dayRange (0,3) can be saved to show all employees their orders that are due to be delivered in the next 3 days.