This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - Dsiplaying the result of an query in a grid/relationship tab

andherrm - Thursday, April 9, 2009 7:21 AM:

I created a special item type for documents (because these documents are different from the existing documents in innovator).

For these documents I want to execute a query. In this query again "my" documents are requested. This means the query result is a subset of documents and there is no document-document-relationship.

The query is dependent on the selected document type. So it is necessary to get the document type from the form.

The result of this query should be shown in a relationship tab. Additional it is necessary that in the tab these documents should be "clickable". This means a feature like "open item" should be available.

I already tried to do that with a new relationship and a new grid, but I failed when I tried to get the document type from the form and I also had some problems to open a document from the new grid.

I would be happy to get some hints! Thanks in advance!



RobMcAveney - Thursday, April 9, 2009 11:11 AM:

Hi andherrm -

The simplest way to display the results of a query on a grid is to use a configurable grid, but this will not get you the interactivity you are looking for.  Another option is to make a "fake" relationship and use server events to manipulate the results the way you want them.  If you want complete control over the UI, you'd have to create a Form, embed a grid and create the menus, toolbars, etc.  This has been done in a few community packages, so there are some examples out there.  If you can give me a few more specifics (like maybe a sample query), I can help you figure out which way is best.

Regards -

Rob