Insert clause text tab
One or more clauses define the terms for the creation of the segment. Each clause is true or false for a member, and can be connected to other clauses by using the AND, OR, NOT, or parentheses.
The table below explains the options available in Insert clause text tab:
Field Name | Description |
---|---|
If member text field | This is used to select the text field from the drop-down menu |
Is |
This is used to Select the desired command from the drop-down menu |
This value |
This is used to snter the value to determine the clause. For example: Selecting a text clause of If member text field domain_ is equal to yahoo.com, creates a segment for all members with a domain name of @yahoo.com. This can be paired with one or more clauses by using AND, OR, NOT, or the parentheses Note Some of the comparison options don't work for all kinds of text fields on different database platforms, so it is crucial to test the segment to see if the database raises errors. Generally, the problem, if any, is that equals, less than, and greater than are not allowed for some types of fields |
Match case | If this is checked, only those results which match the case upper, lower, or a mixture precisely is selected |