When a project task record is created the position of project task in the schedule is automatically created and these values cannot be searched because user set the order by insert before option, there project task id and position will be same hence we can use suitescript 2.0 code to search that record
Search via Project Task record.
require(['N/search'],
function(search) {
var projecttaskSearchObj = search.create({
type: "projecttask",
filters:
[
["internalid","anyof","projectTaskId"]
],
columns:
[
search.createColumn({name: "title", label: "Name"}),
search.createColumn({name: "parent", label: "Parent"}),
search.createColumn({name: "id", label: "ID"})
]
});
var searchResult = projecttaskSearchObj.run();
var resultRange = searchResult.getRange({
start: 0,
end: 1
});
for (var i = 0; i < resultRange.length; i++) {
log.debug(resultRange[i]);
};
});
2. Search via Project record.
require(['N/search'],
function(search) {
var jobSearchObj = search.create({
type: "job",
filters:
[
["internalid","anyof","projectId"]
],
columns:
[
search.createColumn({name: "altname", label: "Name"}),
search.createColumn({
name: "internalid",
join: "projectTask",
label: "Internal ID"
}),
search.createColumn({
name: "title",
join: "projectTask",
label: "Name"
}),
search.createColumn({
name: "id",
join: "projectTask",
sort: search.Sort.ASC,
label: "Id"
})
]
});
var searchResult = jobSearchObj.run();
var resultRange = searchResult.getRange({
start: 0,
end: 50
});
for (var i = 0; i < resultRange.length; i++) {
log.debug(resultRange[i]);
}
});
source: Get Project Tasks Order With SuiteScript 2.0 (custhelp.com)