RE: [Emerald] Error while processing a custom search

New Message Reply Date view Thread view Subject view Author view
Dale Reed (daler@iea-software.com)
Thu, 9 Oct 2003 11:32:11 -0700



From: "Dale Reed" <daler@iea-software.com>
Subject: RE: [Emerald] Error while processing a custom search
Date: Thu, 9 Oct 2003 11:32:11 -0700
Message-ID: <MNEDJOKKCMEOCDBBIABFEEDHCAAA.daler@iea-software.com>

This issue along with the double search results for non-admin users was resolved in Emerald 4.5.5. You can download Emerald 4.5.5 from the download center on our website:

http://www.iea-software.com/download/

-----Original Message----- From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Nada Sent: Thursday, October 09, 2003 1:50 AM To: emerald@iea-software.com Cc: support@iea-software.com Subject: [Emerald] Error while processing a custom search

Hello,

We have just installed the new version of Emerald 4.5.4. When we perform a custom search from the user which is not an admin user we get the below error. Please check and reply to us how can we solve it.

Thank you for the support, Regards, Nada Syriani IDM sal.

+++ error +++

[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'Data'.

SELECT CASE WHEN ma.Active = 0 THEN 'inactive.gif' WHEN ma.CancelDate IS NOT NULL THEN 'canceled.gif' ELSE 'normal.gif' END AS status, ma.FirstName, ma.LastName, Company, adt.Description as Login, ad.Data as AccountType, ma.CustomerID FROM MasterAccounts ma, MasterAccountData ad, MasterAccountDataTypes adt , MetaTables mt, Objects o, OperatorGroupAccess oga WHERE ma.CustomerID = ad.CustomerID AND ad.DataTypeID = adt.DataTypeID AND ad.DataTypeID = 1 AND Data LIKE '%DM320%' AND mt.MetaTableID = o.Value AND o.ObjectTypeID = 2 AND mt.TableName = 'MasterAccounts' AND oga.OperatorGroupID = 3 AND oga.ObjectGroupID = o.ObjectGroupID AND oga.AccessType & 1 = 1 AND oga.GroupID IN (ma.GroupID,1)



New Message Reply Date view Thread view Subject view Author view
This archive was generated on Thu Oct 09 2003 - 11:32:54 Pacific Daylight Time