Ticket T704669

Only Visible to You and DevExpress Support

Visible to All Users

Modify support ticket and change its visibility

Urgent Duplicate

How to show self referencing data in a single grid

AC AC

andre chevallier andre chevallier

created 6 years ago (modified 6 years ago)

Hi Guys
I have a show stopper problem and am hoping you guys can help.
This issue is simple using our current grid provider but doesnt appear to be supported by DEV express
I have a data table made up of three columns…(in real life its actually a lot more but for this issue i only need to demonstrate 3)

GroupGroupHeader RowGUID SelfReferenceID
Application 1 1

Application 2 2
Application 3 2

Application 4 4
Application 5 4
Application 6 4

It should display in a grid something like the following

Application as a group
1

2
3 (record 3 "belongs" to record 2 as its self reference key is 2)

4
5 (record 5 "belongs" to record 4 as its self reference key is 4)
6 (record 6 "belongs" to record 4 as its self reference key is 4) etc

Unfortunately my reading of the support tickets suggest this carnt be done in the Dev Express grid control.
Perhaps Im missing something

Thanks

Show previous comments (0) Comments (0)

Answers approved by DevExpress Support

DevExpress Support Team DevExpress Support Team

created 6 years ago (modified 6 years ago)

Hi Andre,

To display a self-referenced data table, create a relation for your data table and filter the grid's data source to show only "root" records. We discussed this in the How to display a self-referenced data table via master and detail grid views thread. Review it for more information. Refer also to the How to display a self-referenced data table via master and detail grid views example illustrating this approach.
Please let us know if you have further questions.

Show previous comments (8) Comments (11)

AC AC

Private andre chevallier Private andre chevallier 6 years ago

Thanks Igor
Unfortunately it dosnt meet my requirements
Firstly any groupings are carried through to the expanded display. Is there a way to remove the group column or hide it in the in the hierarchy

Our root record selfreference key will always be the same as the ID of the root record.
Your sample assumes that the selfreference key is null for the root record…unfortunately for our requirements the selfreference key must be the same as the ID of the record…

using a filter statement selfreference = Id hides the roots from displaying as additional records in the main grid but As you can probably appreciate this means that the root record is displayed in the hierarchy…can you think of a work around for this.

thanks again for your help

Private DevExpress Support Team Private DevExpress Support Team 6 years ago

Hi,

Before we proceed further with GridControl, would you please clarify if you tried to use Tree List ? I am asking you this since this control seems to exactly what you need. Refer to the Tree Generation Algorithm in the Tree List help article to learn how to accomplish your task.

If you have already tried this control and it is not suitable, please explain why.

I look forward to your response.

Private Nadezhda (DevExpress Support) Private Nadezhda (DevExpress Support) 6 years ago

Hello,

In this case, I suggest you group rows based on your SelfReferenceID column. I have attached a project to illustrate this approach. Please test it and let me know if it meets your requirements. If it does not help, provide a couple of screenshots to illustrate how data should be shown.
I look forward to your response.

T704669.zip

AC AC

Private andre chevallier Private andre chevallier 6 years ago

Once again thank for your help
I have research th etree grid to some small extent and am not convinced it can meet the bill

I have attached to screen shots showing how actual data should look

Janus Grid is our current solution

Devexpress grid i show the same data looks using Dev express

Devexpress grid.png

AC AC

Private andre chevallier Private andre chevallier 6 years ago

opps seem you carnt attach multiple files

Janus Grid.png

Private DevExpress Support Team Private DevExpress Support Team 6 years ago

Andre,

Thank you for the screenshots. It looks like the solution suggested by Nadezhda with grouping by the SelfReferenceID column should work fine for your task. Have you had an opportunity to test the sample project? Could you please share the results?

AC AC

Private andre chevallier Private andre chevallier 6 years ago

No Unfortunately this wont work. Grouping is NOT done on the selfReference key rather it done on another column

DEV express seems not to be able to
1: Hide the group column
2: Hide the root record
3: Hide the relation tab (this is a bit of a worry as I dont get how this hasn't been mentioned before)
in the displayed hierarchy

I have attached further screen shots will illustrate what im looking for

For the above data sample supplied grouping is done by the "GroupGroupHeader" = "Application"

Janus Grid.png

AC AC

Private andre chevallier Private andre chevallier 6 years ago

second screen shot

DevExpressgrid.png

Private DevExpress Support Team Private DevExpress Support Team 6 years ago

Hi Andre,

Please accept my apologies for the delayed response. After examining your screenshots, I recommend that you give our TreeList control another try. I believe it will better suit your scenario. I updated Nadezhda's project to show how to set up this control for your task. Please note that I'm using the CustomDrawRow event to render "parent" rows in code so that they look as group rows. Once you've had an opportunity to test this project, let me know what you think about it.

T704669.zip

AC AC

Private andre chevallier Private andre chevallier 6 years ago

We have opted for an alternate solution in this case

Private DevExpress Support Team Private DevExpress Support Team 6 years ago

Andre,

Thank you for letting us know of your decision. We appreciate it.

Should you have any further questions, do not hesitate to contact us.

Created: January 7, 2019 7:35 AM

Modified: January 24, 2019 9:44 AM

Platform: WinForms

Product: XtraGrid Suite

Build: 18.2.4

IDE: Microsoft Visual Studio 2017

Related Tickets

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

How to show self referencing data in a single grid

Answers approved by DevExpress Support

Recently viewed tickets