Reference Qualifier help

[Rob Sestito]

Hey SN Comm,

I had recently built an out of office function within our instance. The objective is to have users put in their out of office dates, and when then do they are ignored from being assigned Cases and Tasks. Within the Assigned To dictionary field, then into the Override Dictionary Tab, I have the following under the ref qual: u_out_of_office=false. However, I need to also add in somehow, to have the ref qual check the dates (Start Date field at least). For example, If I put in out of office dates to the fields provided, the Start Date could be starting a couple of days from today when being entered. But the ref qual is only looking at a true/false field as of right now. So if I put in future dates, I am already being ignored from being assigned cases and tasks. Can anyone help me figure out how to add in to the ref qual what I need, to also check the start date field?

(Date fields are read-only until someone checks the Out of Office checkbox)

Thanks in advance!

-Rob

[Rob Sestito]

I even made my own - as you did and saw the difference between our two queries. Using mine did the same exact thing. I put my query within the ref qual override, and it too ignored the entire group from being selected within the assigned_to field..

-Rob

[Rob Sestito · Accepted solution]

Taking a different approach to this.

User will enter in their Out of Office Date fields, and not even bother with the Out of Office true/false field. My scheduled job will handle making that field true or false - so then I can leave the ref qual as I had it from the start. And if the user returns prior to their End Date of being out of the office, they will be able to uncheck the true/false OOO field - which will make my client script clear the fields for them.

Scheduled Job

Client Script

I want to thank you for all your help!

-Rob