Skip to main content
沙竹_105321721-Visitor
1-Visitor
May 12, 2023
Question

Why are the count results different between Navigate and WRS?

Do you know why the count number retrieved in Navigate's Service is different from the count number retrieved in WRS?
When I created and ran the service in Navigate, I got odata.count: 35050.
But the result of the search in WRS was 34179.

When I logged the url accessed from Navigate and accessed it, it was 34179, so the numbers are different only on the Navigate screen.
Why is this difference in count results?

I am sorry if there are any errors in the text, as I am translating from Japanese.

4 replies

Velkumar19-Tanzanite
19-Tanzanite
May 12, 2023

Hi @沙竹_10532172 

 

Could you please provide more details like endpoint of WRS and Thingworx Service used to fetch data from Windchill

 

/VR

Translate
沙竹_105321721-VisitorAuthor
1-Visitor
May 12, 2023

Thanks for the reply.

This is the code for service.

I am running zuban with "*".

 

 

const selectAttribute = "ZUBAN%2CVersion%2CState%2CCreatedBy%2CCreatedOn%2CModifiedBy%2CLastModified%2CFolderLocation";
const commonURL = "servlet/odata/v4/DocMgmt/Documents?%24select="+selectAttribute;
var accessURL=commonURL+"&%24filter=ZUBAN%20eq%20''";

if(zuban!=null){
 accessURL=commonURL+"&%24filter=ZUBAN"+encodeURIComponent(" eq '"+zuban+"'")+"&%24count=true" ;

 if(zuban.length==1){
 if(zuban=='*'){accessURL=commonURL+"&%24filter=ZUBAN%20eq%20''&%24count=true";}
 }
 if(zuban.length>1){
 if(zuban=='**'){accessURL=commonURL+"&%24filter=ZUBAN%20eq%20''";}
 if(zuban.slice(0,1)=='*' && zuban.slice(-1)=='*' && zuban.length>2){
 	accessURL=commonURL+"&%24filter=contains(ZUBAN,'" + zuban.substr(1, zuban.length-2) + "')"+"&%24count=true";}
 if(zuban.slice(0,1)!='*' && zuban.slice(-1)=='*'){
 	accessURL=commonURL+"&%24filter=startswith(ZUBAN,'" + zuban.substr(0, zuban.length-1) + "')"+"&%24count=true";}
 if(zuban.slice(0,1)=='*' && zuban.slice(-1)!='*'){
 	accessURL=commonURL+"&%24filter=endswith(ZUBAN,'" + zuban.substr(1) + "')"+"&%24count=true";}
 }
}

var headerObject = new Object();
headerObject["Content-type"] = "application/json";
var header = JSON.stringify(headerObject);
var params = {	
	proxyScheme: undefined /* STRING */,
	headers: header /* JSON */,
	ignoreSSLErrors: undefined /* BOOLEAN */,
	useNTLM: undefined /* BOOLEAN */,
	workstation: undefined /* STRING */,
	useProxy: undefined /* BOOLEAN */,
	withCookies: undefined /* BOOLEAN */,
	proxyHost: undefined /* STRING */,
 url: me.WindchillUrl + accessURL,
	timeout: 3600 /* NUMBER ,{"defaultValue":60}*/,
	proxyPort: undefined /* INTEGER */,
	password: me.WindchillUserPassword /* STRING */,
	domain: undefined /* STRING */,
	username: me.WindchillUserId /* STRING */
};	
	
// response: JSON	
var response = Resources["ContentLoaderFunctions"].GetJSON(params);	
var result = response;	​

 


This is the RequestURL for WRS.

 

http://<host-name>/Windchill/servlet/odata/v2/CADDocumentMgmt/CADDocuments?%24select=ZUBAN%2CVersion%2CState%2CCreatedBy%2 CCreatedOn%2CModifiedBy%2CLastModified%2CFolderLocation&%24filter=ZUBAN%20eq%20''&%24count=true

 

Please help us.

Translate
Velkumar19-Tanzanite
19-Tanzanite
May 12, 2023

Hi @沙竹_10532172 

 

Are you using the same credentials for both Thingworx Rest Call & Windchill Rest Call?

 

I can see in Thingworx, you are using the fixed username and password to fetch data from the Windchill system.

 

/VR

 

Translate
Terms & ConditionsAccessibility statement