Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Static filter with priority <> "GEEN"  XML
Forum Index » Helpdesk
 
Author Message
[Post New]08/09/2010 10:29:26
    Subject: Static filter with priority <> "GEEN"
[Up]
Philip
SysAider

SysAider from release 5.5 Netherlands
Joined: 16/09/2009
Messages: 8
Offline
I want to have two views, 1 for records with priority='GEEN' and one for records with priority<>'GEEN'

I've tried static filter with the above filters, but I get the message 'Error in Query'.

What am i doing wrong, see screenprints

Thanks,
Philip
[Thumb - 1.jpg]
 Filename 1.jpg Download
 Description
 Filesize 71 Kbytes
 Downloaded:  1 time(s)

[Thumb - 2.jpg]
 Filename 2.jpg Download
 Description
 Filesize 72 Kbytes
 Downloaded:  2 time(s)

This message was edited 1 time. Last update was at 08/09/2010 10:42:27
[Post New]13/09/2010 10:58:22
    Subject: Static filter with priority <> "GEEN"
[Up]
itayH
SysAid Customer Relations


Joined: 23/09/2009
Messages: 1092
Offline
Hi Philip,

If I understand correctly "GEEN" is "No". But if you want to use a static filter according to the "priority" you need to use "Low - Highest" and not Yes\No. You also need to write the priority value and not the field name, you can find the value in Customize > Lists > from the list choose Priority.

For example, if you want to show only SR's in Normal Priority you need to add this static filter: priority = 4
If you want to show priority low, high, very high, highest please add this static filter: priority <> 4.

Let me know if this helps.
Best Regards,
Itay
[Post New]15/09/2010 02:45:33
    Subject: Re:Static filter with priority <> "GEEN"
[Up]
Philip
SysAider

SysAider from release 5.5 Netherlands
Joined: 16/09/2009
Messages: 8
Offline
And that solved my problem. I had to use the values instead of the names of the field.

Thank you,

Philip
[Post New]16/09/2010 11:49:37
    Subject: Static filter with priority <> "GEEN"
[Up]
itayH
SysAid Customer Relations


Joined: 23/09/2009
Messages: 1092
Offline
Hi Philip,

Thanks, I love these comments
Best Regards,
Itay
Forum Index » Helpdesk
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
    SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011 		   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   02:00 AM - 04:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use