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. | ||||
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 |
|
merged, thanks | |
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 |