persistent class %BI.WebContacts
extends %Persistent
property Company
as %String(TRUNCATE=1);
property Descp
as %String(TRUNCATE=1);
property Email
as %String(TRUNCATE=1);
property FName
as %String(TRUNCATE=1);
property Fax
as %String(TRUNCATE=1);
property GroupCon
as %String(TRUNCATE=1);
property Name
as %String(TRUNCATE=1);
property Tel
as %String(TRUNCATE=1);
property UsdID
as %String(TRUNCATE=1);
query ListAll()
SQL Query
:
SELECT %ID,Company,"Descp",Email,Fax,FName,"GroupCon",Name,Tel
FROM %BI.WebContacts
index (Group on GroupCon);
index (Name on Name);