Text field - Revision history

Drn@ecs.soton.ac.uk at 13:27, 16 April 2023

2023-04-16T13:27:11Z

2023-04-16T11:59:07Z

‎Additional Properties

2023-04-11T21:52:01Z

A subclass of Id

2023-04-09T23:05:56Z

2023-03-21T08:32:47Z

Add examples and link to API page. Moved description to top

2007-01-11T15:24:46Z

2007-01-11T13:37:34Z

2007-01-10T16:34:13Z

2007-01-10T16:33:40Z

2007-01-10T15:52:01Z

@@ Line 24: / Line 24: @@
 | '''sql_index''' || <tt>0</tt> || NO || Whether field should be index for quicker lookup by the database. || Different from [[Id field]] default (<tt>1</tt>).
 |-
-| '''text_index''' || <tt>1</tt> || NO || Whether field should be index for quicker lookup by the database. || Different from [[Metadata]] default (<tt>0</tt>).
+| '''text_index''' || <tt>1</tt> || NO || Whether the text for this field should be indexed. || Different from [[Metadata]] default (<tt>0</tt>).
 |}

@@ Line 15: / Line 15: @@
 == Additional Properties ==
-As for [[Id field#Additional_Properties|Id fields]] except for:
+As for [[Id field#Additional_Properties|Id fields]] except for
 {| border="1" cellpadding="3" cellspacing="0"
-| name || default || description
+! Name !! Default Value !! Required !! Description !! Notes
 |-
-| '''sql_index''' || 0 || ''as for [[Metadata]] but with a different default.''
+| '''match''' || <tt>IN</tt> || NO || How to match values in search results. || Different from [[Id field]] default (<tt>EX</tt>). Treat the search value as a list of whitespace-separated words rather than an exact single string to match.
 |-
-| '''text_index''' || 1 || ''as for [[Metadata]] but with a different default.''
+| '''sql_index''' || <tt>0</tt> || NO || Whether field should be index for quicker lookup by the database. || Different from [[Id field]] default (<tt>1</tt>).
 |}

@@ Line 11: / Line 11: @@
 == Inheritance ==
 * [[Metadata]]
-** [[Text field]]
+** [[Id field]]
 == Additional Properties ==
 {| border="1" cellpadding="3" cellspacing="0"
 | name || default || description
@@ Line 23: / Line 25: @@
 == Required Phrases ==
-No additional phrases  beyond the [[Metadata#Required_Phrases|standard metadata field phrases]].
+No additional phrases beyond those required for [[Id field#Required_Phrases|Id fields]].
 == Database ==

@@ Line 13: / Line 13: @@
 ** [[Text field]]
-== Properties ==
+== Additional Properties ==
 {| border="1" cellpadding="3" cellspacing="0"
 | name || default || description
@@ Line 23: / Line 23: @@
 == Required Phrases ==
-No additional phrases.
+No additional phrases  beyond the [[Metadata#Required_Phrases|standard metadata field phrases]].
 == Database ==

@@ Line 1: / Line 1: @@
 {{fieldtypes}}
 == Description ==
 This is a very simple type of metadata field, which is used as a basis for several others.
@@ Line 13: / Line 8: @@
 Note that 255 bytes does not mean 255 characters! UTF-8 can use 1 to 4 bytes to store a character. ASCII characters (a-z,0-9 etc) only use 1 byte so it will store 255 ASCII characters, but less of latin and much less of chinese.
 == Properties ==
 {| border="1" cellpadding="3" cellspacing="0"
 | name || default || description
@@ Line 25: / Line 23: @@
 == Required Phrases ==
+No additional phrases.
 == Database ==
 Text fields are stored in the database as
   fieldname VARCHAR(255)

← Older revision		Revision as of 15:52, 10 January 2007
Line 23:		Line 23:

	None		None
		+
		+	== Database ==
		+
		+	Text fields are stored in the database as
		+
		+	fieldname VARCHAR(255)