Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

Metastorm BPM forums
Sign up Latest Topics

  Author   Comment  

Posts: 122
Reply with quote  #1 
This may be me missing something completely obvious, but when creating a Tabe Business Object and then using it in a grid, can you sort the data somehow?

Otherwise it means doing it in a Query Business Object, which isnt a problem, but kind of loses the point of the Table Business Object then?


Avatar / Picture

Posts: 5,507
Reply with quote  #2 

I have pointed it out, but nobody seems interested....

Try asking Metastorm.

Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.

Posts: 688
Reply with quote  #3 

This was a critical issue for us for which we raised a bug and was working with Development to resolve.  An initial work around was to create a very poorly designed primary key which go the sorting *closer* to what was desired, but it still was not a good fit.

Off the cuff they suggested building a view of the table with the desired ORDER BY in the view definition.  A little bit of tweaking and we were eventually able to get this to work.  We ended up doing (SQL, not sure if Oracle allows order by in view definitions):

SELECT TOP 99.9999999 PERCENT * FROM table ORDER BY sort1, sort2, sort3

Note that SQL will ignore the order by of TOP 100 PERCENT is used, hence the all 9s (billions is more than enough for our needs at this time).  Its a bit of a hack, but it works and gets around the bad primary key I had created trying to approximate the fix.

Previous Topic | Next Topic

Quick Navigation:

Create your own forum with Website Toolbox!