| 1 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'notes.subject', 'title', '0', 'field'); |
|---|
| 2 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'notes.category', 'category', '1', 'field'); |
|---|
| 3 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'notes.content', 'content', '2', 'field'); |
|---|
| 4 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'assignedto.firstname like \"{{value}}%\"or assignedto.lastname like \"{{value}}%\"', 'assigned to', '3', 'whereclause'); |
|---|
| 5 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'assignedby.firstname like', 'assigned by', '4', 'whereclause'); |
|---|
| 6 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:0fcca651-6c34-c74d-ac04-2d88f602dd71', 'notes.id', 'id', '5', 'field'); |
|---|
| 7 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:29925e0a-c825-0067-8882-db4b57866a96', 'tabledefs.displayname', 'table', '2', 'field'); |
|---|
| 8 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:29925e0a-c825-0067-8882-db4b57866a96', 'smartsearches.name', 'name', '1', 'field'); |
|---|
| 9 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:29925e0a-c825-0067-8882-db4b57866a96', 'modules.displayname', 'module', '3', 'field'); |
|---|
| 10 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2ad5146c-d4c0-db8e-592a-c0cc2f3c2c21', 'widgets.id', 'id', '1', 'field'); |
|---|
| 11 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'notes.subject', 'title', '0', 'field'); |
|---|
| 12 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'notes.category', 'category', '1', 'field'); |
|---|
| 13 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'notes.content', 'content', '2', 'field'); |
|---|
| 14 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'assignedto.firstname like \"{{value}}%\"or assignedto.lastname like \"{{value}}%\"', 'assigned to', '3', 'whereclause'); |
|---|
| 15 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'assignedby.firstname like \"{{value}}%\"or assignedby.lastname like \"{{value}}%\"', 'assigned by', '4', 'whereclause'); |
|---|
| 16 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:2bc3e683-81f9-694a-9550-a0c7263057de', 'notes.id', 'id', '5', 'field'); |
|---|
| 17 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:3f71ab66-1f84-d68b-e2a3-3ee3bb0ec667', 'log.type', 'type', '0', 'field'); |
|---|
| 18 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:3f71ab66-1f84-d68b-e2a3-3ee3bb0ec667', 'log.ip', 'ip address', '1', 'field'); |
|---|
| 19 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'tabledefs.maintable', 'main table', '0', 'field'); |
|---|
| 20 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'tabledefs.displayname', 'display', '1', 'field'); |
|---|
| 21 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3', 'tabledefs.id', 'id', '2', 'field'); |
|---|
| 22 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:7e75af48-6f70-d157-f440-69a8e7f59d38', 'tabs.name', 'name', '1', 'field'); |
|---|
| 23 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:7e75af48-6f70-d157-f440-69a8e7f59d38', 'tabs.tabgroup', 'group', '0', 'field'); |
|---|
| 24 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:80b4f38d-b957-bced-c0a0-ed08a0db6475', 'files.name', 'name', '0', 'field'); |
|---|
| 25 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'menu.name', 'name', '0', 'field'); |
|---|
| 26 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'parentmenu.name', 'parent name', '1', 'field'); |
|---|
| 27 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:83187e3d-101e-a8a5-037f-31e9800fed2d', 'menu.id', 'id', '2', 'field'); |
|---|
| 28 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:83de284b-ef79-3567-145c-30ca38b40796', 'scheduler.name', 'name', '0', 'field'); |
|---|
| 29 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:87b9fe06-afe5-d9c6-0fa0-4a0f2ec4ee8a', 'roles.name', 'name', '0', 'field'); |
|---|
| 30 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:8d19c73c-42fb-d829-3681-d20b4dbe43b9', 'relationships.id', 'id', '0', 'field'); |
|---|
| 31 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'notes.subject', 'title', '0', 'field'); |
|---|
| 32 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'notes.content', 'content', '2', 'field'); |
|---|
| 33 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'assignedto.firstname like \"{{value}}%\"or assignedto.lastname like \"{{value}}%\"', 'assigned to', '3', 'whereclause'); |
|---|
| 34 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'assignedby.firstname like \"{{value}}%\"or assignedby.lastname like \"{{value}}%\"', 'assigned by', '4', 'whereclause'); |
|---|
| 35 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'notes.id', 'id', '5', 'field'); |
|---|
| 36 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:a4cdd991-cf0a-916f-1240-49428ea1bdd1', 'notes.category', 'category', '1', 'field'); |
|---|
| 37 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', '(users.lastname like \"{{value}}%\" or users.firstname like \"{{value}}%\" )', 'name', '0', 'whereclause'); |
|---|
| 38 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', 'users.accesslevel', 'access level', '2', 'field'); |
|---|
| 39 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', 'users.login', 'log in name', '1', 'field'); |
|---|
| 40 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', 'users.id', 'id', '3', 'field'); |
|---|
| 41 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'reports.name', 'name', '0', 'field'); |
|---|
| 42 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'reports.reporttable', 'table', '1', 'field'); |
|---|
| 43 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'reports.type', 'type', '2', 'field'); |
|---|
| 44 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:d595ef42-db9d-2233-1b9b-11dfd0db9cbb', 'reports.id', 'id', '3', 'field'); |
|---|
| 45 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', 'usersearches.name', 'name', '0', 'field'); |
|---|
| 46 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', '({{value]]=\"global\" or users.firstname like \"{{value}}%\" or users.lastname like \"{{value}}%\")', 'user', '1', 'whereclause'); |
|---|
| 47 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', 'usersearches.table', 'table', '2', 'field'); |
|---|
| 48 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:e251524a-2da4-a0c9-8725-d3d0412d8f4a', 'usersearches.id', 'id', '3', 'field'); |
|---|
| 49 | INSERT INTO `tablesearchablefields` (`tabledefid`, `field`, `name`, `displayorder`, `type`) VALUES ('tbld:ea159d67-5e89-5b7f-f5a0-c740e147cd73', 'modules.id', 'id', '0', 'field'); |
|---|
