Common Tickets
Attribute Creation
Jira ticket - KOET-2552
NL - attribute creation extranet
- In this kind of ticket you get a attachment in from that you have to create new attributes
You can find the attributes in sys_status table
INSERT INTO toolstation_nl.sys_status (sst_uid, sst_type, sst_desc, sst_settings)
VALUES
(992, 'partnotes', 'Number of blades', '{\"type\":\"integer\"}'),
(993, 'partnotes', 'Blade length (mm)', '{\"type\":\"integer\"}'),
(994, 'partnotes', 'Clamp capacity (mm)', '{\"type\":\"integer\"}'),
(995, 'partnotes', 'Max. clamping force (kg)', '{\"type\":\"integer\"}'),
(996, 'partnotes', 'Handle materia', '{\"type\":\"text\"}'),
(997, 'partnotes', 'Jaw width (mm)', '{\"type\":\"integer\"}'),
(998, 'partnotes', 'Metric or imperial sizes', '{\"type\":\"text\"}'),
(999, 'partnotes', 'Autolock', '{\"type\":\"text\"}'),
(1000, 'partnotes', 'Detection depth (mm)', '{\"type\":\"integer\"}'),
(1001, 'partnotes', 'Marking depth (mm)', '{\"type\":\"integer\"}'),
(1002, 'partnotes', 'Cutting length (mm)', '{\"type\":\"integer\"}'),
(1003, 'partnotes', 'Max. tile thickness (mm)', '{\"type\":\"integer\"}'),
(1004, 'partnotes', 'Joint width (mm)', '{\"type\":\"integer\"}'),
(1005, 'partnotes', 'Tile thickness (mm)', '{\"type\":\"integer\"}'),
(1006, 'partnotes', 'Jaw size (mm)', '{\"type\":\"integer\"}'),
(1007, 'partnotes', 'Number of cutting edges', '{\"type\":\"integer\"}'),
(1008, 'partnotes', 'Perforated', '{\"type\":\"text\"}'),
(1009, 'partnotes', 'Dry or wet use', '{\"type\":\"text\"}'),
(1010, 'partnotes', 'Segment height (mm)', '{\"type\":\"integer\"}'),
(1011, 'partnotes', 'Grit type', '{\"type\":\"text\"}'),
(1012, 'partnotes', 'Type of binding', '{\"type\":\"text\"}'),
(1013, 'partnotes', 'No load speed', '{\"type\":\"text\"}'),
(1014, 'partnotes', 'Belt speed', '{\"type\":\"text\"}'),
(1015, 'partnotes', 'Stroke length (mm)', '{\"type\":\"integer\"}'),
(1016, 'partnotes', 'Planing width (mm)', '{\"type\":\"integer\"}'),
(1017, 'partnotes', 'Staple length (mm)', '{\"type\":\"integer\"}'),
(1018, 'partnotes', 'Including screw', '{\"type\":\"text\"}'),
(1019, 'partnotes', 'Screwhead size (mm)', '{\"type\":\"integer\"}');