JDBC Driver for SuiteCRM

Build 22.0.8462

Products

Create, update, delete, and query the products registered for the SuiteCRM project

Table Specific Information

Select

You can query the Products table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Products WHERE Name = 'test'

Insert

Create a Product by specifying any writable column.

INSERT INTO Products (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Product column that is writable, by specifying the Id.

UPDATE Products SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete

Delete a Product by specifying the Id.

DELETE FROM Products WHERE Id = '10003'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier of the ACL Action.

Name String False

DateEntered Datetime False

The date the record was created.

DateModified Datetime False

The date the record was last modified.

ModifiedUserId String False

The Id of the user who last modified the record.

ModifiedByName String True

The name of the user who last modified the record.

CreatedBy String False

The Id of the user who created the record.

CreatedByName String True

The name of the user who created the record.

Description String False

The action description.

Deleted Bool False

The record deletion indicator.

CreatedByLink String True

Link to the record who created it

ModifiedUserLink String True

Link to the record who modified it.

AssignedUserId String False

The Id of the user assigned to the record.

AssignedUserName String True

AssignedUserLink String True

Link to the user which the record has been assigned to

SecurityGroups String True

The security group associated with the record.

AosProductsPurchases String True

Maincode String False

PartNumber String False

Part number of the product.

Category String False

Name of the product's category.

Type String False

Type of the product.

Cost String False

Cost of the product.

CostUsdollar String False

CurrencyId String False

Price String False

Price of the product.

PriceUsdollar String False

Url String False

Url where the product can be seen.

ContactId String False

Product's point of contact id.

Contact String True

Product's point of contact name.

ProductImage String False

Image uploaded for the product.

FileUrl String False

AosProductCategory String True

AosProductCategoryName String True

AosProductCategoryId String False

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462