| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 19/08/2008 21:58:11
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
We have been having a problem using any filter that uses the "Belongs to" filter. We were originally using Firebird database and I had hoped that when we migrated to MSSQL that this would have been resolved, but it still exists.
We have user accounts that are setup for each branch location. These user accounts have a username that is the location number and appear similar to the following:
Username: 10
FirstName: FacilityName
LastName: 010 (ManagerName #151)
Anytime that we try to use a filter that is based on the "Belongs to" and choose one of these usersnames that is a numeric value instead of alphanumeric, it seems to "crash" and give no results back. For example, if we have a ticket and the Request User is one of these users, and we click the "change" button to choose an "Asset" to assign to the ticket, we get a blank screen in the pop-up, with no results ---- if the request user is a user with a alphanumeric name, the popup works properly.
This is completely reproducible in every instance and is limited to the user accounts that have a numeric username.
I would have been happy to just go back and change all of the usernames to be something like HHI-010 instead of just 10 or 010, but since there is no way to edit the username once it has been created, this isn't an option. Also, I don't want to delete and recreate all of the users because I would lose all of my historical reporting, etc. for these accounts.
Hopefully you can help me find a solution for this?
Thanks in advance.
|
|
|
20/08/2008 02:46:05
|
th
SysAid Mod
Joined: 11/06/2008
Messages: 250
Offline
|
Never tried numeric user names but have you tried to put the filter expression in brackets? The helped me a couple of times when I had issues with non-working filters.
|
|
|
23/08/2008 20:13:07
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
There is no way to customize the filter screen for the popup that I am talking about. There is no "gear" icon to customize the page or filters that I can find.
When I have a helpdesk ticket open and click the "Change" button for the Asset, there is no way for me to add brackets to the filter because there is no way to customize this screen.
|
|
|
24/08/2008 03:17:49
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello Harold,
Thank you for your response.
Can you please tell me which version of SysAid are you currently using? you can find this information on the top bar in SysAid.
|
Pushing IT forward |
|
|
24/08/2008 11:27:41
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
version 5.5.05
|
|
|
24/08/2008 11:37:41
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
Now, after having tried to use brackets in the "Default View" under Inventory and then having changed it back to no brackets (just in case this was the view that was used) -- whenever I go into the "Asset List" view, I get no results but instead get "Error in query". In fact, all of the views that have any filters at all now show "Error in query" with no results.
I have a "Browse Assets" view that has no filters and it will display the results, but somehow all of my other views are now broken.
|
|
|
24/08/2008 11:47:16
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
If I remove the ${list.belongs.to.caption} from the filter menus on one of the views, it will work again. It almost seems as though whatever setting marks what I last had this filter selection set to is what is "crashing" the filter and views from displaying any information.
|
|
|
07/10/2008 08:18:55
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
I have had similar issues like this before, like the one being discussed here:- http://www.ilient.com/Sysforums/posts/list/716.page I have also just read this post which mentions a similar problem if one of your views is missing the "All" filter http://www.ilient.com/Sysforums/posts/list/676.page
Lets hope we can get to the bottom of all these "Error in Query" issues and produce a list of causes/things you should not do when customising filters and views.
This message was edited 1 time. Last update was at 07/10/2008 08:22:29
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
01/11/2008 11:41:55
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
*BUMP* Haim?
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
16/02/2009 10:21:58
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
Sorry to bump this topic again, but I am still looking for some help on this one.
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
16/02/2009 10:42:02
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
We are still having this issue even after the latest upgrade. We pretty much can't do searches for inventory. We have to browse to find it instead. This is really frustrating.
Do I need to just plan a time to get involved with support for a resolution remotely or on the phone?
|
|
|
16/02/2009 14:40:28
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
Harold,
How did you created the "belong to" filter?
Did you received the instructions from the support team?
I'm not sure if creating this drop down filter is even possible, i'm going to check it with our development team and going to update this post.
Best regards.
Haim
|
Pushing IT forward |
|
|
18/02/2009 11:47:25
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
I never modified the filter. It always was the original filter that came with the product.
I ended up eventually trying to fix it on my own and modify the filter, but could not get anything to work.
|
|
|
22/05/2009 15:49:38
|
thinksecurity
SysAider
Joined: 22/04/2009
Messages: 39
Offline
|
Bump
I'm currently experiencing the same issue with version 6.0.0.4
|
|
|
24/05/2009 02:26:53
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello thinksecurity
Please post a screenshot of the filter settings so i can review it.
You can find the settings under "customize list" in the asset list and then by choosing this filter under "filter menus" and then click on the "edit" button.
Also, are you receiving an error in query when trying to choose a owner? please re-create the issue, then check the ...\SysAidServer\root\WEB-INF\logs\sysaid.log if one of the last errors relate to the issue and post it here.
Thanks.
Haim
|
Pushing IT forward |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
