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
customize list compagny  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
janvanegmond
SysAider


SysAider from release 6 Netherlands
Joined: 14/12/2009
Messages: 9
Location: Rotterdam
Offline

Hi,

I want to make a customized list for selecting a compagny in Helpdesk -> List
Where can I find the info for creating this?

Thank you.
[Email] [WWW]
itayH
SysAid Customer Relations


Joined: 23/09/2009
Messages: 1092
Offline

Hi janvanegmond,

In order to add a Company filter to the the software products List, please do the following:

1. Go to Help Desk -> List and click on the “Customize List” button (blue cogwheel icon).

2. In the Customize List window, click on “Add” (to the right of Filter Menus) and enter the following information in the appropriate fields:

Name: Company (any name of your choice)
List Field: u.company
Lookup Table: company
Lookup Field: company_id
Lookup Caption: company_name

3. Click on “Close”.

4. Back in the Customize List window, you can save this “view” as a new view name, so you can always go back to the DEFAULT view if this one does does work.

5. Click on “Save”.

Best Regards,
Itay
itayH
SysAid Customer Relations


Joined: 23/09/2009
Messages: 1092
Offline

Hi Jan,
It works, thank you.
What about the field u.company because I do not understand the prefix u.
Is this a generated sql script?

Can I put this new field before the second field "Active"

Cheers,

Jan


Yes, this is an SQL query.
"u." represent the user table.
"company" represent the columns.

Best Regards,
Itay
Forum Index » SysAid Installation & Beyond
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