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

[sebastian_g_snc]

Hi Rob,

I hope I understood the scenario correctly. 🙂
Your reference qualifier is looking whether or not the ooo checkbox is ticked, correct? This is not the functionality you want (I guess you knew that already ;D).

You have to check that <now> is between the 2 dates IF the checkbox is ticked.

I assume that the ooo functionality is somewhere on the HR Profile !? I am asking, because I think you might have to create an advanced reference qualifier  in order to implement it. So please provide some additional info.

Thanks

[Rob Sestito]

Hello Sebastian,

Yes, the reference qualifier within the Override of the dictionary, is checking whether or not the OOO checkbox is true or false. Yes, this OOO Section I put together is on the user account from the sys_user table.

I was trying to create an advanced reference qualifier from the dictionary of the field, rather than going to the Override dictionary, but I could not get it created correctly.

Did you need more information Sebastian, or was this good enough?

Please let me know 🙂

Thanks,

-Rob

[sebastian_g_snc]

Hi,

You can write an encoded query into that reference qual override field.

I think this condition should work for you (sorry, no encoded query, because I don't know your field names) - I gave it y quick try in incident not any HR case.

for me the encoded query would look like this:

u_out_of_office=false^u_ooo_start_date>=javascript:gs.beginningOfToday()^u_ooo_end_date>=javascript:gs.beginningOfToday()^NQu_out_of_office=false^u_ooo_start_date>javascript:gs.endOfToday()^u_ooo_end_date>javascript:gs.endOfToday()^EQ

Hope that helps

[Rob Sestito]

So the fields are right - when I use the encoded query you have provided, and put that into the Override Ref Qual, it ends up ignoring all users within the entire Assignment Group.

Not sure how or why it is doing that!

Thanks,

-Rob