Maps

Create, update, delete, and query maps via Google Maps.

テーブル固有の情報

WHERE 句で任意の条件を使用して、Maps テーブルをクエリできます。本製品はSuiteCRM API を使用して結果をフィルタリングします。

SELECT * FROM Maps WHERE [Distance (Radius)] > 5000

書き込み可能なカラムを指定して、Map エントリを作成します。

INSERT INTO Maps (Name, [Distance (Radius)], [Related to (Center)], [Unit Type]) VALUES ('Enclosed Area', 10, 'Dublin', 'KM')

Id を指定して、書き込み可能なMap エントリカラムを更新できます。

UPDATE Maps SET [Unit Type] = 'metres',[Distance (Radius)] = 700 WHERE Id = 'Test123'

Id を指定して、Map を削除します。

DELETE FROM Maps WHERE Id = 10003


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the map.
Assignedto	String	False	The user name of the user assigned to the record.
AssignedUserId	String	False	The Id of the user assigned to the record.
CreatedById	String	True	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
DateCreated	Datetime	True	The date the record was created.
DateModified	Datetime	True	The date the record was last modified.
Deleted	Bool	False	The record deletion indicator.
Description	String	False	Description for the map
Distance(Radius)	Double	False	Radius being covered in the map
ModifiedById	String	True	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
ModuleTypetoDisplay	String	False	Module linked to the map
Name	String	False	Name assigned to the map
ParentID	String	False	Id of the map's parent record
ParentType	String	False	Type of the map's parent
Relatedto(Center)	String	True	Name of the map's parent. Also identifies the map's center location
UnitType	String	False	Length unit expressing the radius

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


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.