topic Re: How to get distinct rows of a grid(data table) in ThingWorx Developers

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

mnalla — Mon, 28 Aug 2017 11:54:26 GMT

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

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

liliu — Tue, 29 Aug 2017 02:44:48 GMT

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)

mnalla — Tue, 29 Aug 2017 11:53:20 GMT

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)

liliu — Wed, 30 Aug 2017 01:30:33 GMT

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)

liliu — Wed, 30 Aug 2017 02:46:00 GMT

Hi Madhu,

Did you bind GetDataTableEntities's SelectedRowsChanged event to QueryDataTableEntities?

BR,

Lily

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

mnalla — Wed, 30 Aug 2017 04:17:59 GMT

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)

liliu — Wed, 30 Aug 2017 05:21:21 GMT

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)

mnalla — Wed, 30 Aug 2017 05:59:07 GMT

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)

liliu — Wed, 30 Aug 2017 06:29:25 GMT

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)

mnalla — Wed, 30 Aug 2017 07:29:49 GMT

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

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

liliu — Wed, 30 Aug 2017 08:48:42 GMT

Hi Madhu,

As I checked, JiraConnectorThing is not a built in Thing. So the service QueryIssues should be editable.

We can query out all issue records as long as JiraConnectorThing can access to DB.

What you need to do is opening the JiraConnectorThing service and finding out QueryIssues service. Check the code in QueryIssue. JiraConnectorThing's service QueryIssues may inherited from a ThingTemplate or ThingShape, if so, please check the service in associated ThingTemplate/ThingShape.

If you get to code, please attach to this thread.

Best Regards,

Lily

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

mnalla — Wed, 30 Aug 2017 09:30:53 GMT

Hi Lily,

the code is written in java not in JS so it is not possible to share the code. QueryIssue service is inherited from Thingtemplate which is written in java

Regards,

Madhu

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

liliu — Wed, 30 Aug 2017 09:40:52 GMT

Hi Madhu,

I'd like to have a remote meeting with you and access your computer to check this issue. Is that possible?

If you can have a remote meeting with me, please let me know where are you located and when will you be available tomorrow. And I will send the meeting link to you.

Best Regards,

Lily

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

mnalla — Wed, 30 Aug 2017 10:01:22 GMT

Hi Lily,

Yes, we can have a remote meeting. May be it is possible. My location is Bangalore, India.

Regards,

Madhu