Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-devel digest..."
Today's Topics:
1. [Netdot - Bug #1689] (New) Site Type Model Report showing
Unknown instead of the manufacturer ([email protected])
----------------------------------------------------------------------
Message: 1
Date: Wed, 19 Sep 2012 06:04:26 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1689] (New) Site Type Model
Report showing Unknown instead of the manufacturer
To: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1689 has been reported by moe kraus.
----------------------------------------
Bug #1689: Site Type Model Report showing Unknown instead of the manufacturer
https://osl.uoregon.edu/redmine/issues/1689
Author: moe kraus
Status: New
Priority: Normal
Assignee:
Category: UserInterface
Target version:
Resolution:
Dear all,
there is a bug in the Report "Site Type Model". The column "Model" displays as
Manufacturer always Unknown.
I have identified this bug in the raw sql statement, reading the info from the
database. The Column product type is missing. I have tested the fixed statement:
html/reports/device_inventory.html:118
SELECT device.site,
asset.product_id,
site.name AS site_name,
product.name AS product_name,
-----> producttype.name AS product_type,
entity.name AS manufacturer
FROM device
LEFT JOIN site ON site.id=device.site
LEFT JOIN (asset CROSS JOIN product CROSS JOIN entity)
ON (asset.id=device.asset_id
AND asset.product_id=product.id
AND entity.id=product.manufacturer)
--->LEFT JOIN producttype ON product.type = producttype.id
ORDER BY site_name,product_name
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 66, Issue 15
********************************************
