Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
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
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.
Thanks Aanjan,
for your help..
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
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