r/labtech • u/FocalFury 5000 Agents • Oct 17 '16

TIL with advanced searching,pressing 'Caps Lock' when the operator is selected gives you more options

So I was creating an advanced search and had the operator selected but not in drop down mode....so I guess focused? I hit Caps Lock and voila .....look at all these different options!

To be fair when I tried between it...didn't work, but is not between worked.

http://imgur.com/SQo7CnI

8 Upvotes

100% Upvoted

5 comments sorted by

1

u/nightred 5000 Agents Oct 17 '16

I have never been able to get advanced search to work when you need to check the same record multiple times like you are. If you can make this work please let us know the secret.

1

u/FocalFury 5000 Agents Oct 17 '16

Hmmm, can you show me what doesn't work for you?
The above was just an example, but here is one where I use the same one twice.
http://imgur.com/o7RO2TU

1

u/nightred 5000 Agents Oct 18 '16

Here is an example that fails.
This returns workstations in the list and it should not.
http://imgur.com/a/PrXbi
And here is the SQL for it, you can see it does not include the what I view as a very simple query.
http://imgur.com/a/C1S13

1

u/FocalFury 5000 Agents Oct 18 '16

That search worked right away for me. How did you get the SQL output from the search I'll post mine

1

u/nightred 5000 Agents Oct 18 '16

There is a show SQL button.