SELECT AND PROPERTY BAG

[ZedEnter]

Hi -

Using: BO XI

is it possible to access a value of a property bag via a select statement, i.e. using the "Query Builder".

For instance I have a property bag named SI_PROP and a value inside named ORDER.

<SI_PROP>
<ORDER>1</ORDER>
</SI_PROP>

Now I want to query for the ORDER property inside the SI_PROP property bag.

Something like this I thought:

SELECT * FROM CI_INFOOBJECTS ORDER BY SI_PROP.ORDER

This doesn't work and I tried many other select statements. Of course I could take the result collection and then order by the ORDER-property but I would like to have it right away ordered during the query.


Greetz - Chris.