Members
Retrieve and query information related to members.
Select
The 本製品 will use the GMO MakeShop API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- MemberId, MemberNameKana columns support the = operator.
- JoinDate column supports the >,>=,=,<=,< operators.
- GetDeleted pseudo-column supports the = operator.
Ordering is supported for JoinDate.
For example, the following queries are processed server side:
SELECT * FROM Members WHERE MemberId = 'MemberIdHere' AND JoinDate >= '2018-09-04 22:54:43+01:00' AND JoinDate <= '2018-09-04 23:54:43+01:00' ORDER BY JoinDate ASC
SELECT * FROM Members WHERE MemberNameKana = 'Firstname Lastname' AND JoinDate > '2018-09-04 22:54:43+01:00' AND JoinDate < '2018-09-04 23:54:43+01:00' ORDER BY JoinDate DESC
SELECT * FROM Members WHERE JoinDate = '2018-09-04 23:54:43+01:00' AND GetDeleted = '1'
Insert
All columns except JoinDate can be specified. MemberId, MemberName, MemberNameKana, Email, MemberPassword, HomePost, HomePrefecture, HomePrefectureCode, HomeAddress1, HomePhone are required for an insert.
INSERT INTO Members (MEmberId, MemberName, MemberNameKana, Email, MemberPassword, HomePost, HomePrefecture, HomePrefectureCode, HomeAddress1, HomePhone) VALUES ('mymemberid', 'the name', 'Firstname Lastname', '[email protected]', 'Passw0rd', '1508512', 'Prefecture', '13', 'Address here', '453-345')
Update
All columns except JoinDate can be updated. MemberId is required in the criteria for an update.
UPDATE Members SET MemberName = 'updName' WHERE MemberId = 'MemberIdHere'
Delete
A member can be deleted by specifying MemberId.
DELETE FROM Members WHERE MemberId = 'MemberIdHere'
Columns
Name | Type | ReadOnly | Description |
MemberId [KEY] | String | False |
Member ID. |
MemberName | String | False |
Member name. |
MemberNameKana | String | False |
Member name phonetic. |
JoinDate | Date | True |
Date of registration. |
GroupId | Integer | False |
Member group ID. |
GroupName | String | False |
Member group name. |
String | False |
Member email address. | |
MemberPassword | String | False |
Member password - specified on an Insert. |
EmailMagazineReceive | String | False |
Indicator whether to receive mail magazine - Y: Wish to distribute e-mail newsletter, N: I do not wish to deliver e-mail newsletters. 使用できる値は次のとおりです。Y, N |
Sex | Integer | False |
Member gender - 0: Male 1: Female. 使用できる値は次のとおりです。0, 1 |
Birthday | Date | False |
Member birthday. |
MemberPoint | Integer | False |
Store shop points owned by members. |
MemberPointExpireDate | Date | False |
Owned shop point expiration date. |
RecommendMemberId | String | False |
Store introducer's member ID. |
HomePost | String | False |
Home zip code. |
HomePrefectureCode | String | False |
Home prefecture code. |
HomePrefecture | String | False |
Home prefecture name. |
HomeAddress1 | String | False |
Home address. |
HomeAddress2 | String | False |
Other address. |
HomePhone | String | False |
Home phone number. |
HomeFax | String | False |
Home fax number. |
MobilePhone | String | False |
Mobile phone number. |
MobileEmail | String | False |
Mobile email address. |
OfficeName | String | False |
Company name. |
OfficeNameKana | String | False |
Company name phonetic. |
OfficeDepartment | String | False |
Company department. |
OfficePost | String | False |
Company zip code. |
OfficePrefectureCode | String | False |
Company prefecture code. |
OfficePrefecture | String | False |
Company prefecture name. |
OfficeAddress | String | False |
Company address. |
OfficePhone | String | False |
Company phone number. |
AdditionalOption1 | String | False |
Additional input item 1. |
AdditionalOption2 | String | False |
Additional input item 2. |
AdditionalOption3 | String | False |
Additional input item 3. |
AdditionalOption4 | String | False |
Additional input item 4. |
AdditionalOption5 | String | False |
Additional input item 5. |
AdditionalOption6 | String | False |
Additional input item 6. |
AdditionalOption7 | String | False |
Additional input item 7. |
LoginEmail | String | False |
Mail address authentication setting - Y: allow member login with e-mail address N: do not allow member login with e-mail address. |
Memo | String | False |
Member information memo. 使用できる値は次のとおりです。Y, N |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
GetDeleted | Integer |
Specify this as 1 to acquire deleted members. Defaults to 0 and deleted members will not be retrieved. 使用できる値は次のとおりです。0, 1 |