[SMW-devel] Feature request

[<zeh...@mo...>]

Hi,

I would like to be so bold and add two feature request suggestions for future
releases. These suggestions are with the old storage engine in mind as I can't
really say I have a clue yet how the new engine handles especially nary
properties (and therefore how to 'translate' my suggestion according to the new
storage) but I hope these additions would make it possible for me to use queries
to the new storage engine without having to access the db directly. 


1) An optional parameter 'nary' for the function getPropertyValues()

If this parameter is set with a numerical value and the PropertyObjectTypeID of
the specified property is '__nry' only values from the indicated nary
position would be retrieved (adding the condition 'and nary_pos = nary parameter
value' to the SQL query) instead of all values of the multivalue property.


2) Support of the SQL option DISTINCT for SMWRequestOptions objects

One of the SQL options supported in MW's Database.php is DISTINCT, however, the
SMWRequestOptions object in SMW doesn't have a variable for it.

So if the object would get an additional 'distinct' variable besides 'limit' and
'offset', one could in function getSQLOptions($requestoptions, $valuecol = NULL)
simply set the SQL option and the db select function could use it

     if ($requestoptions->distinct > 0) {
        $sql_options['DISTINCT'] = 1;
     }


Thanks very much,
Gu