Finders
Displays search finder names and corresponding attributes for a specific view, helping locate and filter procurement data.
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 | The name of the view that the finder should search within. |
| FinderName | String | The name assigned to the specific finder being used. |
| AttributeFinderColumn | String | The name of the column in the finder that represents the attribute being searched. |
| Type | String | The data type of the finder attribute, specifying the kind of data it holds (for example, string or integer). |