Hi,
a) in Oxid CE 4.8.0 i found the select-query of the getAttributes() resp.
oxAttributeList::getCategoryArticles() wich is:
SELECT DISTINCT att.oxid, att.oxtitle, o2a.oxvalue ".
"FROM $sAttTbl as att, $sO2ATbl as o2a ,$sC2ATbl as c2a
".
"WHERE att.oxid = o2a.oxattrid AND c2a.oxobjectid =
$sActCatQuoted AND c2a.oxattrid = att.oxid AND o2a.oxvalue !='' AND
o2a.oxobjectid IN ($sArtIds) ".
"ORDER BY c2a.oxsort , att.oxpos, att.oxtitle,
o2a.oxvalue
so it doesn’t look like it’s filtered by active or not. Wich Oxid-Version do
you use?
Maybe the documentation could help you ->
http://docu.oxid-esales.com/CE/sourcecodedocumentation/
b) I’m not sure if you want to get the title or the oxid of the attribute while
using oxtitle__oxid, but you should know, that the object-attributes/variables
are built like this: {tablename}__{columnname} .
So if you want to get the oxid, you should use oxattribute__oxid and if you
want to get the title, oxattribute__oxtitle.
Hope I could help,
Daniel Leicht_______________________________________________
dev-general mailing list
[email protected]
http://dir.gmane.org/gmane.comp.php.oxid.general
