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 |