The field type enables you to assign a column for an ID number to a tracker. You can either use the itemID from tiki (which counts all items in all trackers) or an ID you define using a string and a consecutive increasing numeric value.
For instance
with a parameter: 1,File
The first item field value will be File1, the second item field value will be File2
with a parameter: 0,,,itemId
The field value will be the itemId
Options
Value
Description
Tiki version
numeric
Initial value, default 1
tw>2.0
string
Prepend string
tw>=2.0
string
Append string
tw>=2.0
the string itemId
the field will contain the itemId
tw>=2.0
The option are separated with comma.
Since Tiki9, this field can be used in PluginTrackerFilter to allow users to do custom searches of items in a tracker based also on their auto-increment field.
Limitation
an auto-increment field is only set up when the item is created
an itemId field is only set up when the item is created or modified
In order to set a new itemId field on existing items. this sql query can be used
Copy to clipboard
DELETE FROM `tiki_tracker_item_fields` WHERE `fieldId`=317;
INSERT INTO `tiki_tracker_item_fields` ( `itemId` , `fieldId` , `value` )
SELECT `itemId` , 317, `itemId`
FROM tiki_tracker_items
WHERE `trackerId` =54
Where 317 is your itemId field and 54 your trackerId.
Note about ItemID before version 2.0
In later versions of the 1.9.x series, ItemID was available via System Tracker Field
Auto-increment Field / ItemId Field tw>=2.0 The field type enables you to assign a column for an ID number to a tracker. You can either use the itemID from tiki (which counts all items in all trackers) or an ID you define using a string and a consecutive increasing numeric value. For instance with a parameter: 1,File The first item field value will be File1, the second item field value will be File2 with a parameter: 0,,,itemId The field value will be the itemId