I have a saved query in TMS that I run every day. And every day, I have to change the date field to reflect the current date. Perhaps in the future, Gallery Systems will provide a new relationship “Is Today” for date fields, but until that happens here’s a hack to try.
Tag :querying
Looking for What Isn’t There
My coworkers seem to have an “infinite capacity to not know what can’t be done,” manifest in the myriad of queries they want to perform within TMS. Not satisfied with searching for records that meet a criteria, they’d rather look for records that don’t.