cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get distinct rows of a grid(data table)

SOLVED
Highlighted
Regular Member

How to get distinct rows of a grid(data table)

Hi Everyone,

I have two grids namely products data and projects data

If I click product one in one grid, it should show projects under this product in another grid.

how to approach this.

I have created a common key for this I am trying to access it. but i am not successful in this way.

Could anyone suggest me with the service code for it.

Regards,

nalla

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to get distinct rows of a grid(data table)

Hi Madhu,

The binding is like this. First Grid is GetDataTableEntities and the second Grid is QueryDataTableEntities.

QueryDataTableEntities has parameters, bind the GetDataTableEntities's selected rows column to QueryDataTableEntities parameters.

The run tiem grid looks like this:

Should you have any concern, please let me know.

BR,

Lily

13 REPLIES 13

Re: How to get distinct rows of a grid(data table)

Hi Madhu,

The binding is like this. First Grid is GetDataTableEntities and the second Grid is QueryDataTableEntities.

QueryDataTableEntities has parameters, bind the GetDataTableEntities's selected rows column to QueryDataTableEntities parameters.

The run tiem grid looks like this:

Should you have any concern, please let me know.

BR,

Lily

Re: How to get distinct rows of a grid(data table)

Hi Li,

ThankYou for the response. While giving connection from key to values.Users. what is the relation between this. (key to values.Users). I have tried key to my fields like name and  IssueKey but It did not show any result in the another grid.

And one more thing I would need to manipulate thousands of rows, is it going to work?  Any another methods are available, Please let me know.

Regards,

Madhu

Re: How to get distinct rows of a grid(data table)

Hi Madhu,

The key-> values.Users is something like primary key-> foreign key. It can work for thousands rows but the performance may not good.

How about you attach you mashup here and I will check what's the wrong configuration in your mashup?

Best Regards,

Lily

Re: How to get distinct rows of a grid(data table)

Hi Madhu,

Did you bind GetDataTableEntities's  SelectedRowsChanged event to QueryDataTableEntities?

BR,

Lily

Re: How to get distinct rows of a grid(data table)

Hi Li,

ThankYou,

I am able to view the selected product projects. I tried it again.

Regards,

madhu

Re: How to get distinct rows of a grid(data table)

Hi Madhu,

I am very glad that I can help. If any concern, please feel free to let me know.

Best Regards,

Lily

Re: How to get distinct rows of a grid(data table)

Hi Lily,

I have a thing with a service of queryIssue. I want to display all of the issues with out requesting. Is it possible to view all these issues. The service is having input as id and output as infotable.

Regards,

Madhu

Re: How to get distinct rows of a grid(data table)

Hi Madhu,

Is queryIssue servcice a customized service? Where do you store these issues records? (DB or DataTable or an thing's property)

We can view all these issue records with customized serivce. I need to know our customized code. Please give use the screenshot of our code or attach your entities on this thread.

BR,

Lily

Re: How to get distinct rows of a grid(data table)

Hi Lily,

It is a in built service from a connector. These records stored in DB. I am sending the connection details. Do we need to write customized service for displaying issues in a grid. Though It is displaying single issue details if i give the input(Jql) but I would like to display whole issues.

Regards,

madhu

query.PNG