Need Urgent Help on ThingWorx

[kshirod.mishra]

Dear All,

I need urgent help on ThingWorx Data Table. Example:  I have a data Table , i want to query on its data field. I have tried various ways to retrieve the data from my data table but problem is , i am getting my required data with unwanted data fields with  values which are  coming from ThingWorx. Can anybody , please help me how to solve this issue.

Note: From the below Data Table the "Red Color" field, i do not want after query.How to solve this issue?

timestamp	tags	sourceType	source	location	key	BookType	BookName	AuthorName	BookCount
2015-09-10 11:57:57		User	Administrator	0.0000 : 0.0000	A. GALVINPHYSICSSCIENCE	SCIENCE	PHYSICS	A. GALVIN	23
2015-09-10 11:57:57		User	Administrator	0.0000 : 0.0000	B. SEKHARPHYSICSSCIENCE	SCIENCE	PHYSICS	B. SEKHAR	12
2015-09-10 11:57:57		User	Administrator	0.0000 : 0.0000	C. ALEXBOTANYSCIENCE	SCIENCE	BOTANY	C. ALEX	12

Thanks $ Regards

kshirod

[Aanjan]

If you are displaying the query result on a grid in the Mashup, you can hide (or choose not to display) all the unwanted columns.

[kshirod.mishra]

Thanks Aanjan,

for your help..

[vtielebein]

Hello Kshirod,

As Aanjan says, you can select to not display those columns in a grid. You can do this by highlighting over the arrow in the top left corner of the grid and selecting "Configure Grid Columns". Then you can deselect the column headers in the list on the left side of the screen. If there is no check mark in the box, it will not display.

Hope this helps,

Tori

[kshirod.mishra]

Thanks Victoria,

Now i am able to write a service in Data Table level, which is capable of fetching my required data.

Thanks & Regards:

kshirod