PSST0101Just Trying to Remember and Share What I Learn in the PeopleSoft World

PeopleTools Reference: Meta-SQL %SelectByKey

December 27, 2006 — digitaleagle

generates a select statement based on the given record definition.

Remember that a record object (not a record definition) stores both the record structure (table name and field name) and the field values. Therefore, the system has everything it needs to write a select statement: select … list of fields … from … table name … where … key field name … = … value for that field … and so on.

Related: %SelectByKeyEffdt

does the same thing except it adds the effective dating criteria to limit it to the most recent rows.