Hello -

This has been baking my noodle for some time.. I'm not sure if it can be done with LLBLGEN or infact if my architecture is fundamentally floored.

I have a table of products which is used by multiple consumers. Because each consumer needs to store different data there is a text field inwhich an XML document is stored, containing consumer specific elements.

This works well mostly as core business functionality can be reused and indiviual functionality can be added on top fairly easily.

Where I'm stuck is this.. I want to sort the products by a node in the xml document, this is okay, but the problem is I need to subsort the by different nodes.

Any idea if this can be done through LLBLGEN or even if my approach is floored.

Any help you can give would be great, the only solutions I can come up with are pretty manual.

Best,

Phil.

For some reason I marked this as done by accident.

It's still very much active.

Are the manual ways that you have setup done using LLBLGen? If so can you post those examples.

I don't understand the question;

what I have is an element within the database;

xmlproperties (text)

this contains raw xml doc.

Maps into the element object and is then cast as an xml doc.

Then the nodes specific to the consumer extracted. So LLBLGEN isn't really used. Search is okay because you can just do a like clause on the node, but sorting... well that's where I'm stuck.

Please post the SQL query you want to end up with.

Anyway I think this can be done by implementing an IExpression and set this expression to a field in a sortClause object.

Please refer to the following thread for more details on implementing an IExpression: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829