Hi All,

I am using Pentaho Enterpise Edition 3.8.

We are creating prpt report based on the Metadata Model. In MQL Query for ORDER BY

the default is

<orders>
<order>
<direction>asc</direction>
<view_id>Business View ID</view_id>
<column_id>Business Column ID</column_id>
</order>
</orders>


But in one of the thread it was said we can use table_id tag instead of view_id. And so i tried as below


<orders>
<order>
<direction>desc</direction>
<table_id>Business Table ID</table_id>
<column_id>Business Column ID</column_id>
</order>
</orders>

But this is not working in this case. Even direction is DESC , it is not considering the order clause itself. It shows data as it is is DB.



I am changin view_id to table_id for the following reason.

The metadata model is security enabled.

We provided Execute access to the Model and no acess to business views. This is because users can access the canned reports created based on the model and to restrict them to create Ad Hoc reports in the User Console.


Thanks... MK