Index

Create, update, delete, and query the available indexes in SuiteCRM

Table Specific Information

Select

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

SELECT * FROM Index WHERE Location LIKE '%ACCOUNT%'

Insert

Create an Index by specifying any writable column.

INSERT INTO Index (Name, Location) VALUES ('Empty Index', 'Home')

INSERT INTO Index (Name, Location) VALUES ('Empty Index', 'Home')

Update

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

UPDATE Index SET Location = 'Index' WHERE Id = 'Test123'

Delete

Delete an Index by specifying the Id.

DELETE FROM Index WHERE Id = '10003'

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier of the index.
Assignedto	String	True	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 index
LastOptimised	Datetime	True	Date when the index was last optimized
Location	String	False	Module where the index is applicable
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.
Name	String	False	Name given to te index

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


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

Power BI Connector for SuiteCRM