View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 949 | RackTables | default | public | 2013-07-23 12:35 | 2013-09-04 13:05 |
| Reporter | gibnix | Assigned To | |||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.20.5 | ||||
| Target Version | 0.20.6 | Fixed in Version | 0.20.6 | ||
| Summary | 949: add feature to search for asset tag in "port list filter" when connecting ports | ||||
| Description | we use barcode labes on our equipment as asset tags. When connecting ports within racktables it would be useful to search for asset tags in the "Port list filter" pop-up. So we only need to scan the barcode to find the right Object. At this moment we use a little hack to achieve this (see attachment) | ||||
| Tags | No tags attached. | ||||
| Attached Files | racktables-assettag-hack-v2.patch (669 bytes)
--- a/inc/popup.php 2013-06-23 23:50:37.000000000 +0200
+++ b/inc/popup.php 2013-08-01 12:46:17.744628358 +0200
@@ -47,7 +47,8 @@
pii.iif_name,
d.dict_value as oif_name,
p.object_id,
- o.name as object_name
+ o.name as object_name,
+ o.asset_no as asset
FROM Port p
INNER JOIN Object o ON o.id = p.object_id
INNER JOIN PortInnerInterface pii ON p.iif_id = pii.id
@@ -105,7 +106,8 @@
// objectname filter
if (! empty ($filter['objects']))
{
- $query .= 'AND o.name like ? ';
+ $query .= 'AND (o.name like ? OR o.asset_no LIKE ?) ';
+ $qparams[] = '%' . $filter['objects'] . '%';
$qparams[] = '%' . $filter['objects'] . '%';
}
// portname filter
| ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-07-23 12:35 | gibnix | New Issue | |
| 2013-07-23 12:35 | gibnix | File Added: racktables-assettag-hack.patch | |
| 2013-08-01 12:53 | gibnix | File Added: racktables-assettag-hack-v2.patch | |
| 2013-08-01 12:53 | gibnix | File Deleted: racktables-assettag-hack.patch | |
| 2013-09-04 13:05 | andriyanov | Note Added: 0001743 | |
| 2013-09-04 13:05 | andriyanov | Status | new => closed |
| 2013-09-04 13:05 | andriyanov | Resolution | open => fixed |
| 2013-09-04 13:05 | andriyanov | Fixed in Version | => 0.20.6 |
| 2013-09-04 13:05 | andriyanov | Target Version | => 0.20.6 |
