Skip to main content
1-Visitor
April 5, 2019
Solved

Creating datashape relevant to saved search table in windchill

  • April 5, 2019
  • 4 replies
  • 2253 views

Hi all, I'm trying to fetch the saved search table from windchill in thingworx. Please suggest on how to create datashape relevant to that particular table?

Best answer by Akash1

This issue is fixed. We created data shape based on the internal ID of windchill data and it started working. Thank you for following it up.

4 replies

15-Moonstone
April 5, 2019

Can you be more specific and explain what exactly you trying to do? Are you trying to execute saved search and create data shape from data returned from that? If possible attach service code example.

Akash11-VisitorAuthor
1-Visitor
April 6, 2019

Yes. I'm trying to execute saved search. I'm using the below code. Here "ptc-sample-ds" is the datashape which I created according to the saved search table.  But apart from name and state other columns does not have values. I need help to fix this.

 

// result: JSON
var csrf_token = me.Security_Get_CSRF().items[0].attributes.nonce;
var params = {
infoTableName : "InfoTable",
dataShapeName : "ptc-sample-ds"
};
// CreateInfoTableFromDataShape(ptc-part-demo-shape)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);
var select = "";
// infotable datashape iteration
var dataShapeFields = result.dataShape.fields;
for (var fieldName in dataShapeFields) {
select += ',' + fieldName;
}
// result: JSON
var searchResult = me.Search_Get_SavedSearch_Results({
arguments: undefined /* JSON */,
oid: oid /* STRING */,
CSRF_NONCE: csrf_token /* STRING */,
$select: select /* STRING */
});
var row = {};
for each (var hit in searchResult.items) {
row = hit.attributes;
row.objectId = hit.id;
result.AddRow(row);
}

15-Moonstone
April 29, 2019

First of all can you verify the service you are using me.Search_Get_SavedSearch_Results returns data you expecting?