Skip to main content
P
PP_1047771511-Garnet
11-Garnet
February 26, 2024
Question

Get all the projects from TWX platform excluding PTC's project

  • February 26, 2024
  • 1 reply
  • 1029 views

Hi ,

I want to get all the projects from a TWX platform excluding PTC's project.

 

1 reply

A
Arun_C16-Pearl
16-Pearl
February 26, 2024

Hi @PP_10477715 ,

 

If you are expecting to retrieve project list in TWX JS code. Kinldy find the attached code FYR. If not please explain more about your query.

/////******////// To get all project details in TWX code /////******//////
let params = {
	maxItems: undefined /* NUMBER {"defaultValue":500} */ ,
	nameMask: undefined /* STRING */ ,
	type: 'Project' /* STRING */ ,
	tags: undefined /* TAGS */
};

// result: INFOTABLE dataShape: RootEntityList
let projectList = Resources["EntityServices"].GetEntityList(params);
/////******////// Remove the project name - PTCDefaultProject from all project list /////******//////
let params1 = {
	fieldName: 'name' /* STRING */ ,
	t: projectList /* INFOTABLE */ ,
	value: 'PTCDefaultProject' /* STRING */
};
// result: INFOTABLE
let result = Resources["InfoTableFunctions"].NEFilter(params1);

Thanks & Regards,

Arun C

P
PP_1047771511-GarnetAuthor
11-Garnet
February 27, 2024

Hello,

 

As i can see in above service first we are fetching all the projects and then we are using filter on that,

So unnecessarily we are loading all the rows, also i have multiple ptc's app deployed on platform and i have to exclude those.

May be we can use the tags, but i don't know how to exclude multiple tags.

 

one another service is SpotLightSearch, that may be we can use , where we can pass the not expression (the project name not starts with PTC) but i am not sure how we can use that expression.

 

var params = {
maxItems: 100 /* NUMBER */,
searchExpression: " <not expression>"/* STRING */, for eg. "My_proj*" (it will fetch all the project name starts with My_Proj
types: {"items" : ["Project"]} /* JSON */,
  withPermissions: true /* BOOLEAN */,
endDate: undefined /* DATETIME */,
aspects: {"isSystemObject":false} /* JSON */,
excludedAspects: undefined /* JSON */,
tags: [] /* TAGS */,
thingTemplates:  {}  /* JSON */,
searchDescriptions: true /* BOOLEAN */,
thingShapes: {} /* JSON */,
sortBy: undefined /* STRING */,
isAscending: undefined /* BOOLEAN */,
projectName: "" /* PROJECTNAME */,
maxSearchItems: undefined /* NUMBER */,
startDate: undefined /* DATETIME */
};
 
// result: INFOTABLE dataShape: SpotlightSearch
var result = Resources["SearchFunctions"].SpotlightSearch(params);
Rocko
Rocko19-Tanzanite
19-Tanzanite
February 27, 2024

So unnecessarily we are loading all the rows, also i have multiple ptc's app deployed on platform and i have to

Don't overengineer this. How many projects are on your systems? Even it's 100, if loading those is an issue, you're in trouble.

You can use this to name-filter projects starting with PTC:

 

let params = { nameMask: "(?!PTC).*", type: 'Project' };
result = Resources["EntityServices"].GetEntityListByRegEx(params);

 

But this is not guaranteed to filter out all projects coming from PTC. Especially older extensions (e.g. Analytics) might not comply with the naming scheme or use tags.

 

    Terms & ConditionsAccessibility statement