Finders
Displays available finder functions and their queryable attributes for different views, aiding in data retrieval and analysis.
SELECT
ViewName は、マッピングするFinderName とファインダーパラメータカラムを取得するために必要です。
ViewName カラムは= および IN 演算子をサポートします。
SELECT * FROM Finders where viewname = 'Invoices'
SELECT * FROM Finders where viewname IN ('Invoices','InvoicesinvoiceLines')
Columns
| Name | Type | Description |
| ViewName | String | Name of the view for which the finder is used, specifying the data context in which the finder operation is performed. |
| FinderName | String | Name of the finder, used to identify and reference a specific search function or query operation within the system. |
| AttributeFinderColumn | String | Name of the specific attribute within the finder, used to identify which column or data point the search function is applied to. |
| Type | String | Datatype of the finder attribute, specifying the data type (for example, string, integer, date) for the attribute being searched in the view. |