07-10-2012 03:25 AM - edited 07-10-2012 03:27 AM
Application "Portfolio Items". If we want to find Portfolio Item by specific Supervisor (first sort by Supervisor, then right mouse button click on the column in list and then click "Go to", enter the name of interest person) - the search is not correct. We did not get to the right person. As an example, the search is done for Voevodin Ivan (see attached screenshot "Search"). On the second attached screenshot "Result" a dedicated line - the position found by HP Asset Manager. It does not match what was expected to find. Does anyone know how to solve this problem?
HP Asset Manager Version 5.22
DBMS - MS SQL Server 2008 R2
07-10-2012 07:28 AM
This could be a bug however you are sorting on a linked field. Take note as to the display name value for the link. Do you get the same result if you use the Supervisor.Name as the column?
07-10-2012 11:35 AM
The query will tell you what is being looked for, though.
HP Software Support
07-11-2012 07:01 AM
If I use Supervisor.Name then the transition is working correctly, but this is only part of the full name. ie if I want to go to a specific person, who is the owner of a large number of portfolio items, we can not do it that way. Especially in this case there is another problem - if in the line I will point out the Supervisor Name of a non-existent, then the system will send me to a random record, and even will not give an error message that such Supervisor does not exist.
07-11-2012 07:21 AM
Yes, the error associated with the same type of fields (User and Supervisor), but these are different bugs and solving one of them may not be associated with the solving of the other
07-12-2012 04:58 AM
Query is SELECT TOP 1001 P1.lIconId, P1.lPortfolioItemId, P1.fQty, A2.AssetTag, U4.Symbol, M3.Name, U5.Name, U5.FirstName, U5.FirstName2, U5.Name, U5.FirstName, U5.FirstName2, U5.Name, U5.FirstName, U5.FirstName2 FROM amPortfolio P1, amAsset A2, amModel M3, amUnit U4, amEmplDept U5 WHERE U5.Name > (SELECT E1.Name FROM amEmplDept E1 WHERE E1.lEmplDeptId = 2035596) AND P1.lAstId=A2.lAstId AND P1.lModelId=M3.lModelId AND M3.lUseUnitId=U4.lUnitId AND P1.lUserId=U5.lEmplDeptId ORDER BY 10.
Therefore, the error is "...U5.Name > (SELECT ...".
It must be "...U5.Name >= (SELECT ..." or "...U5.Name = (SELECT ...".
Who knows how to change the query sent by a HP AM client?
07-12-2012 06:55 AM
HP Software Support