Power BI Connector for Business b-ridge

Build 24.0.9062

CDATA

CData テーブルに関する情報をクエリします。

Select

本製品 は Business b-ridge API を使用して、WHERE 句条件と選択されたカラムを処理します。 演算子：=、!=、

、>、<、>=、<=、AND、OR、CONTAINS はサーバー側で処理されます。 例えば、次のクエリはサーバー側で処理されます。 

SELECT * FROM CDATA WHERE CreateDate < '2020-02-14 00:13:57.5'

SELECT * FROM CDATA WHERE (CONTAINS (SampleColumn002, 'b-ri') AND SampleColumn001 = 'ADO') OR SampleColumn001 = 'JDBC'")

SELECT * FROM CDATA WHERE (SampleColumn002 > 2 OR SampleColumn002 = 5) AND (SampleColumn001 = 'M2' OR SampleColumn001 != 'M5') OR ItemId = '0205a94cd35f2a25025b5be9d7c4fc15'

親子関係をクエリするには、ParentTableName とParentItemId を指定します。 

SELECT * FROM Drivers WHERE ParentTableName = 'CDATA' AND ParentItemId = '3b47216073e89641b718ef07cb1f80a8'

Insert

レコードを挿入するには、ItemId以外の各カラムを指定して、INSERT ステートメントを発行します。 

INSERT INTO CDATA (SampleColumn002, SampleColumn003, StructureId) VALUES ('Businessbridge', 'JDBC', '2ef8217323d0d25632dbcd2a8dbca')

レコードを別のレコードの子として挿入する場合は、ParentTableName とParentItemId カラムを指定する必要があります。 

INSERT INTO Drivers (SampleColumn002, SampleColumn003, ParentTableName, ParentItemId) VALUES ('Businessbridge', 'Excel', 'CDATA', 3b47216073e89641b718ef07cb1f80a8)

Update

レコードを更新するには、ItemId を指定してUPDATE ステートメントを発行します。readOnly= false のすべてのカラムを更新できます。 

UPDATE CDATA SET SampleColumn002 = 'Businessbridge' WHERE ItemId = '0d6fd6470c1cf8e8bc96bc74b528d502'

Delete

レコードを削除するには、ItemId を指定してDELETE ステートメントを発行します。 

DELETE FROM CDATA WHERE ItemId = '93147a976bbe4dfa9f1949e78883395c'

Bulk Insert


INSERT INTO CDATA#TEMP (SampleColumn002, SampleColumn003, StructureId) VALUES ('Businessbridge', 'JDBC', '2ef82173227e3d0d25632dbcd2a8dbca')
INSERT INTO CDATA#TEMP (SampleColumn002, SampleColumn003, StructureId) VALUES ('Businessbridge', 'ADO', '2ef82173227e3d0d25632dbcd2a8dbca')
INSERT INTO CDATA (SampleColumn002, SampleColumn003, StructureId) SELECT SampleColumn002, SampleColumn003, StructureId FROM CDATA#TEMP

Bulk Update


INSERT INTO CDATA#TEMP (ItemId, SampleColumn002, SampleColumn003) VALUES ('36d1ad5f385d44259f264cfffdc9f9c9', 'Businessbridge', 'JDBC')
INSERT INTO CDATA#TEMP (ItemId, SampleColumn002, SampleColumn003) VALUES ('36d1ad5f385d44259f264cfffdc9f9c9', 'Businessbridge', 'ADO')
UPDATE CDATA (ItemId, SampleColumn002, SampleColumn003) SELECT ItemId, SampleColumn002, SampleColumn003 FROM CDATA#TEMP

Bulk Delete


INSERT INTO CDATA#TEMP (ItemId) VALUES (ff5e9e7782e74a189aeac478e64cd5a0)
INSERT INTO CDATA#TEMP (ItemId) VALUES (fed05ded8d504f0cb8da441c9dfdbc96)
INSERT INTO CDATA#TEMP (ItemId) VALUES (343434343434r234r3reedfsdfw23ere)
DELETE FROM CDATA WHERE EXISTS SELECT ItemId FROM CDATA#TEMP

Columns

Name Type ReadOnly Description
ItemId [KEY] String False

SampleColumn001 String False

SampleColumn002 String False

SampleColumn003 String False

SampleColumn004 String False

SampleColumn005 String False

SampleColumn006 String False

SampleColumn007 String False

SampleColumn008 String False

SampleColumn009 String False

SampleColumn010 String False

SampleColumn011 String False

SampleColumn012 String False

SampleColumn013 String False

SampleColumn014 String False

SampleColumn015 String False

SampleColumn016 String False

SampleColumn017 String False

SampleColumn018 String False

SampleColumn019 String False

SampleColumn020 String False

SampleColumn021 String False

SampleColumn022 String False

SampleColumn023 String False

SampleColumn024 String False

SampleColumn025 String False

SampleColumn026 String False

SampleColumn027 String False

SampleColumn028 String False

SampleColumn029 String False

SampleColumn030 String False

SampleColumn031 String False

SampleColumn032 String False

SampleColumn033 String False

SampleColumn034 String False

SampleColumn035 String False

SampleColumn036 String False

SampleColumn037 String False

SampleColumn038 String False

SampleColumn039 String False

SampleColumn040 String False

SampleColumn041 String False

SampleColumn042 String False

SampleColumn043 String False

SampleColumn044 String False

SampleColumn045 String False

SampleColumn046 String False

SampleColumn047 String False

SampleColumn048 String False

SampleColumn049 String False

SampleColumn050 String False

SampleColumn051 String False

SampleColumn052 String False

SampleColumn053 String False

SampleColumn054 String False

SampleColumn055 String False

SampleColumn056 String False

SampleColumn057 String False

SampleColumn058 String False

SampleColumn059 String False

SampleColumn060 String False

SampleColumn061 String False

SampleColumn062 String False

SampleColumn063 String False

SampleColumn064 String False

SampleColumn065 String False

SampleColumn066 String False

SampleColumn067 String False

SampleColumn068 String False

SampleColumn069 String False

SampleColumn070 String False

SampleColumn071 String False

SampleColumn072 String False

SampleColumn073 String False

SampleColumn074 String False

SampleColumn075 String False

SampleColumn076 String False

SampleColumn077 String False

SampleColumn078 String False

SampleColumn079 String False

SampleColumn080 String False

SampleColumn081 String False

SampleColumn082 String False

SampleColumn083 String False

SampleColumn084 String False

SampleColumn085 String False

SampleColumn086 String False

SampleColumn087 String False

SampleColumn088 String False

SampleColumn089 String False

SampleColumn090 String False

SampleColumn091 String False

SampleColumn092 String False

SampleColumn093 String False

SampleColumn094 String False

SampleColumn095 String False

SampleColumn096 String False

SampleColumn097 String False

SampleColumn098 String False

SampleColumn099 String False

SampleColumn100 String False

SampleColumn101 String False

SampleColumn102 String False

SampleColumn103 String False

SampleColumn104 String False

SampleColumn105 String False

SampleColumn106 String False

SampleColumn107 String False

SampleColumn108 String False

SampleColumn109 String False

SampleColumn110 String False

SampleColumn111 String False

SampleColumn112 String False

SampleColumn113 String False

SampleColumn114 String False

SampleColumn115 String False

SampleColumn116 String False

SampleColumn117 String False

SampleColumn118 String False

SampleColumn119 String False

SampleColumn120 String False

SampleColumn121 String False

SampleColumn122 String False

SampleColumn123 String False

SampleColumn124 String False

SampleColumn125 String False

SampleColumn126 String False

SampleColumn127 String False

SampleColumn128 String False

SampleColumn129 String False

SampleColumn130 String False

SampleColumn131 String False

SampleColumn132 String False

SampleColumn133 String False

SampleColumn134 String False

SampleColumn135 String False

SampleColumn136 String False

SampleColumn137 String False

SampleColumn138 String False

SampleColumn139 String False

SampleColumn140 String False

SampleColumn141 String False

SampleColumn142 String False

SampleColumn143 String False

SampleColumn144 String False

SampleColumn145 String False

SampleColumn146 String False

SampleColumn147 String False

SampleColumn148 String False

SampleColumn149 String False

SampleColumn150 String False

ArchiveFlg Integer False

CategoryCode String False

CategoryId String False

CreateDate Datetime False

CreatedBy String False

CreatedByUserName String False

ItemTypeId String False

LinkUrl String False

OutputSetId String False

ParamId String False

ParentParamId String False

ParentParamName String False

StatusId String False

StructureId String False

UpdateDate Datetime False

UpdatedBy String False

UpdatedByUserName String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062