Views

Controls the app views that define filtered, sorted, or custom-formatted record lists, supporting administration of user-facing data presentations.

Select

WHERE 句ではAppId カラムが必須です。本製品はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品はクライアント側で本製品内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM Views WHERE AppId = 6
SELECT * FROM Views WHERE AppId = 6 AND Lang = 'en'
SELECT * FROM Views WHERE AppId = 6 AND IsPreview = false

Update

Views を更新するには、Views を集計として指定します。集計に記載されていないビュー名は削除されます。Views を更新するには、AppId カラムが必須です。

UPDATE VIEWS SET Views = '{"(Assigned to me)":{"index":0,"type":"LIST","name":"(Assigned to me)","filterCond":"Assignee in (LOGINUSER())","sort":"Record_number asc"},"subTableTest2":{"index":1,"type":"CALENDAR","name":"subTableTest","date":"Updated_datetime","filterCond":"","sort":"Record_number asc"}}' WHERE AppId = 6

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Identifier of the view, used to reference the specific view configuration within the app.
AppId	Integer	False		Identifier of the Kintone app that contains the view being retrieved or updated.
Index	String	False		Ascending display order of the view, determining its position relative to other views in the app.
Name	String	False		Display name of the view as presented to users in the Kintone interface.
Title	String	False		Field code used as the title field when displaying calendar views, returned only for calendar-type views.
Type	String	False		Type of view, such as list, calendar, or custom, defining how records are presented to the user. 使用できる値は次のとおりです。LIST, CALENDAR, CUSTOM
BuiltinType	String	False		Indicates the type of built-in view being used when the view is not custom.
Date	String	False		Field code used as the date field for calendar views, returned only when the view is configured as a calendar view.
Fields	String	False		List of field codes that determine which fields appear in the view's record list.
FilterCond	String	False		Filter condition expressed as a query string, defining which records appear in the view.
Html	String	False		HTML content used to render a custom view, returned only when the view is defined as a custom layout.
Pager	Boolean	False		Indicates whether pagination is enabled for the view, returned only for custom views.
Device	String	False		Specifies the device contexts where the view is displayed, such as desktop or mobile.
Sort	String	False		Sort order expressed as a query string, defining how records are ordered within the view.
Revision	String	True		Revision number of the app settings, helping track updates made to the view configuration.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。


Name	Type	Description
Lang	String	Locale code used to retrieve view details in a specific language.
IsPreview	Boolean	Indicates whether to retrieve view details from the preview environment ('true') or from the live environment ('false'). The default value is 'true'.
Views	String	Value used only when performing an update to supply modified view settings.

Power BI Connector for Kintone

Views

Select

Update

Columns

Pseudo-Columns