Retrieve Profile Characters
A retrieve profile is used to control the scope of the data to be retrieved from the database. It consists of one or more values for one or more fields in an entity, often containing profile characters. In essence, a retrieve profile is a search query.
Note: Retrieve profiles cannot be used in server page
components.
This table lists the profile characters supported by Uniface.
| Character | Meaning |
|---|---|
| Gold * | Match 0 through n characters of a string, whether they are printable or not. Cannot be used to match numeric values. |
| Gold ? | Match any single character in a string, whether it is printable or not. Cannot be used for to match numeric values. |
| Gold = | Equals (if used without a qualifier: "is null"). |
| Gold < | Less than |
| Gold > | Greater than |
| Gold ! | Logical NOT |
| Gold & | Logical AND |
| Gold | Gold ; |
Logical OR Note: When Gold ; is used as a profile character, it is treated as a logical OR, not as a list separator. |
