ValueListItems

Represents the items within a radar value list, including the item value and creator details.

Table-Specific Information

SELECT

The component uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the component.


Column	Supported Operators
Id	=
Created	>, >=, <, <=, =
Value	=, LIKE
ValueList	=
AccountId	=

Note: LIKE matching is case-sensitive. The case of the value provided in the LIKE expression must match the case of the corresponding value in the data.

You can select from the ValueListItems table with the following queries:

SELECT * FROM ValueListItems
SELECT * FROM ValueListItems WHERE Id = '123124'
SELECT * FROM ValueListItems WHERE Created >= '2023-07-14T05:36:46.000-04:00'
SELECT * FROM ValueListItems WHERE Value = 'This is the value.'
SELECT * FROM ValueListItems WHERE Value LIKE '%This is the value.%'
SELECT * FROM ValueListItems WHERE ValueList = 'rsl_1MGcyqSC4snQ'

INSERT

To create a value list item:

INSERT INTO ValueListItems (Value, ValueList) values ('This is the list item.', 'rsl_1MGcyqSC4snQ')

DELETE

To delete a value list item, specify the list item Id:

DELETE FROM ValueListItems WHERE Id = '123124'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the value list item.
Created	Datetime	True		The time at which the value list item was created, measured in seconds since the Unix epoch.
CreatedBy	String	True		The name or email address of the user who created this value list item.
Livemode	Boolean	True		Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists in test mode.
Value	String	False		The value of the item.
ValueList	String	False		The Id of the value list to which this item belongs.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
AccountId	String	The Id of the connected account to get value list items for.