Properties

Each InfoObject contains properties and property bags that can be retrieved with a SELECT <Properties> statement. <Properties> can be one or more of the query language properties listed in the query language reference.

You can use SELECT * to retrieve all of an object's properties; however, it is recommended that you avoid using the asterisk operator (*), unless TOP N is attached to the *, or the WHERE clause limits the selection to a small number of objects. For examples, see Performance issues.

Note:    

• In Crystal Enterprise, SELECT * returns an upper limit of 1000 objects.
• The parser will ignore misspelled properties and will return empty record sets when you query on them.