Hey all,
I need to look up on hardware assets records where
- Asset function == primary
- Warranty Expiration == today + 2 months (this is a custom field of Date type).
I set up the flow on Flow Designer:
1. Set the flow variable to 2 months from now:
2. Look up records:
All looks fine.
I have a record that meets the conditions:
I run a test. The variable is set correctly:
The lookup is run okay:
However, as you can see, the record is not returned.
When I set the filter before or after, it does not work either.
Any one has any idea why?
I tried to write a script to see what happens.
var gdt = new GlideDate();
gdt.addMonthsLocalTime(2);
var gd = new GlideRecord('alm_hardware');
gd.addEncodedQuery('asset_function=primary^u_glide_date_1ONgdt;');
gd.query();
while (gd.next()) {
gs.addInfoMessage(gd.getValue('asset_tag'));
}
This script returns all records.
So, something seems to be wrong but I don't know why.
Any ideas?
Thanks.
Best,
Firat
