Function call as a View Filter
While custom filters allow simple filed based expression to be evaluated, has anyone been able to call a function for each record in a view?
Background:
I have an IT equipment list containing date of purchase & I am trying to create a view called "Warranty Expiring". I have already written a function called isWarrantyExpired() which take in date of purchase & months of warranty included at time of purchase to compute & returns a boolean true/false if warranty is expired.
What I'd Like To Do:
Create a view filter that when applied filters out only records whose warranty has expired.
Obvious answer (so don't reply with this please!):
Set a filter static filter where date of purchase + xx months gives me warranty status.
Why the above doesn't work is that based on serial numbers the included warranty on each IT asset is variable & is picked up from a different subForm. Hence, the requirement of function.
Thanks.