GetFieldAndColumnSamples method
Get sample values from either a column in a table or from a field. Supports wildcard matches in tables or field names:
- '*' for zero or more characters.
- '?' for one character.
Parameters
| Name | Description | Mandatory | Type |
|---|---|---|---|
| qFieldsOrColumnsWithWildcards |
Pairs of table (optionally) and field names. Support wildcard matches. |
Yes | Array of FieldOrColumn |
| qMaxNumberOfValues |
Max number of sample values returned. Depending on the column or field size the number of returned samples can be less than MaxNumberOfValues. If MaxNumberOfValues is negative all sample values are returned. |
Yes | Integer |
| qRandSeed |
Optional. Sets the random number seed. Should only be set for test purposes. |
No | Integer |
Returns
| Name | Description | Type |
|---|---|---|
| qResult |
Array of samples for each table/field pair. |
Array of SampleResult |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!