String input parameter(sort asc or desc)

Hi, i wanted to created a livereport that return first 25 entries and sort according to asc or desc depending on the user.First, about the asc and desc. How do i the SQL statment to be dynamic with the user selection. I tried using the input String parameter in the live report. Select DTree.* from DTree order by DTree.Name %1.%1 is the Param %1. It fails, it say sql statment not end properly. Any one know how do workabout it..thanks

Find more posts tagged with

Comments

Martin_Gäckler

No, there is no solution without customization. The reason is, that the sort direction cannot be passed via bind variable.

dsta001_dsta001_(dsta001_-_(deleted))

Thanks for the reply.. By the way, is there any documentation on all the livelink table. For example, i want to know for a category , what is the attributes inside that category.. which table should i call, i saw LLATTRDATA table, but it onli have the atrribute values not the attributes name. E.g Author: MR Chee. LLATTRDATA table have the Mr Chee not Author. I finding this because i want to sort the result in according to the attributes.. Thanks

Martin_Gäckler

Yes, there is a documentation available. Ask Open Text how to order.