Norway script example

gistfile1.js

const mongolayer = require("mongolayer");

async function findDraft(civid) {
	
}

async function findNav(civid) {
	const contentResult = await findContent(civid);
	const result = await site.plugins.nav.apis.navItemVersions.promises.aggregate([
		{
			$match : {
				_id : { $in : contentResult.drafts.map(val => val._id) }
			}
		},
		{
			$lookup : {
				from : "plugins_nav_navItems",
				localField : "nav_id",
				foreignField : "_id",
				as : "navItem"
			}
		},
		{
			$project : {
				_id : 1,
				active : 1,
				folderHref : "$navItem.folderHref"
			}
		}
	]);
	
	return result;
}

async function findContent(civid) {
	const [navItemVersions, contentVersions] = await Promise.all([
		site.plugins.nav.apis.navItemVersions.promises.find({ civid, active : true }),
		site.plugins.nav.apis.contentVersions.promises.find({ "content.civid" : civid })
	]);
	
	if (contentVersions.length > 0) {
		const drafts = [];
		
		for(var [key, version] of Object.entries(contentVersions)) {
			const instance = await site.plugins.nav.apis.contentInstances.promises.findById(version.instance_id);
			if (instance === null) {
				throw new Error("Orphan version");
			}
			
			const myDrafts = await findContent(instance.id);
			if (myDrafts.success === true) {
				drafts.push(...myDrafts.drafts);
			}
		}
		
		return {
			success : true,
			drafts
		}
	}
	
	if (navItemVersions.length > 0) {
		return {
			success : true,
			drafts : navItemVersions
		}
	}
	
	return {
		success : false,
		drafts : [],
		message : `Oprhan civid: ${civid}.`
	}
}

return findNav("5581ec5e7a11d91c38f88476");