Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

For information on migrating to InterSystems IRISOpens in a new tab, see Why Migrate to InterSystems IRIS?

User.Person

persistent class User.Person extends %Library.Persistent, %Library.Populate

SQL Table Name: SQLUser.Person

Property Inventory

Properties

property city as %String (POPSPEC = "City()", TRUNCATE = 1);
Property methods: cityDisplayToLogical(), cityGet(), cityGetStored(), cityIsValid(), cityLogicalToDisplay(), cityLogicalToOdbc(), cityNormalize(), citySet()
property dob as %Date;
Property methods: dobDisplayToLogical(), dobGet(), dobGetStored(), dobIsValid(), dobLogicalToDisplay(), dobLogicalToOdbc(), dobNormalize(), dobOdbcToLogical(), dobSet()
property name as %String (POPSPEC = "Name()", TRUNCATE = 1);
Property methods: nameDisplayToLogical(), nameGet(), nameGetStored(), nameIsValid(), nameLogicalToDisplay(), nameLogicalToOdbc(), nameNormalize(), nameSet()
property salary as %Float (POPSPEC = "Float(5000,400000,2)");
Property methods: salaryDisplayToLogical(), salaryGet(), salaryGetStored(), salaryIsValid(), salaryLogicalToDisplay(), salaryNormalize(), salarySet()
property score as %Integer (POPSPEC = "Integer(0,100)");
Property methods: scoreDisplayToLogical(), scoreGet(), scoreGetStored(), scoreIsValid(), scoreLogicalToDisplay(), scoreNormalize(), scoreSet()

Indexes

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (cityIDX on city:SQLSTRING);
Index methods: cityIDXExists()
index (dobIDX on dob);
Index methods: dobIDXExists()
index (nameIDX on name) [Data = name];
Index methods: nameIDXExists()
index (ncIDX on name,city);
Index methods: ncIDXExists()
index (nsIDX on name,score);
Index methods: nsIDXExists()
index (salaryIDX on salary);
Index methods: salaryIDXExists()
index (salaryStrIDX on salary:SQLString);
Index methods: salaryStrIDXExists()
index (scoreIDX on score:SQLUPPER);
Index methods: scoreIDXExists()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (User.Person)

^User.PersonD(ID)
=
%%CLASSNAME
city
dob
name
salary
score
FeedbackOpens in a new tab