s_dyn_criteria table - SuperOffice

s_dyn_criteria Table (350)

Contains criterias for a dynamic list.

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
list_id	Connects the criteria to a list.	FK s_list	No
sort_order	The order to sort the query. Not really relevant	Int	No
field	Which field to test in this criteria	String(64)	No
operator	Equals, gt, lt etc.	operator	No
value	The value	String(64)	No
log_op	And/or	log_op	Yes

Indexes

Fields	Types	Description
list_id	FK	Index

Relationships

Table	Description
s_list	A list, dynamic or static

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

s_list table Dynamic selections MailingsDynamicSelectionSingleCriteriaGroup MailingsShadowDynamicSelectionSingleCriteriaGroup SelectionDynamicSelectionSingleCriteriaGroup Dynamic date range as criteria

⌘I