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)