Create Saved Search For Getting the Child Record Value From the Parent Record In SCA

We created a function for getting the child custom record value from the parent custom record.The CUSTRECORD_JJ_MADITRAINGCOURSE is the parent record and custrecord_jj_city is the child record field id.

The function is added below

 getCourse: function(courseID) {
            var obj = {};
            var coursesSearch = nlapiSearchRecord("customrecord_ra4madi_madi_courses", null,
                [
                    ["internalidnumber", "equalto", courseID]
                ],
                [
                    new nlobjSearchColumn("name"),
                    new nlobjSearchColumn("internalid"),
                    new nlobjSearchColumn("custrecord_madi_course_badge"),
                    new nlobjSearchColumn("custrecord_madi_course_image"),
                    new nlobjSearchColumn("custrecord_madi_course_breakdown"),
                    new nlobjSearchColumn("custrecord_madi_course_description"),
                    new nlobjSearchColumn("custrecord_madi_course_duration"),
                    new nlobjSearchColumn("custrecord_madi_course_price"),
                    new nlobjSearchColumn("custrecord_madi_course_modules"),
                    new nlobjSearchColumn("custrecord_madi_course_schedule"),
                    new nlobjSearchColumn("custrecord_madi_course_timing"),
                    new nlobjSearchColumn("custrecord_jj_city","CUSTRECORD_JJ_MADITRAINGCOURSE",null),
                    new nlobjSearchColumn("custrecord_jj_date","CUSTRECORD_JJ_MADITRAINGCOURSE",null),
                    new nlobjSearchColumn("custrecord_jj_day","CUSTRECORD_JJ_MADITRAINGCOURSE",null),
                    new nlobjSearchColumn("custrecord_jj_educator","CUSTRECORD_JJ_MADITRAINGCOURSE", null),
                    new nlobjSearchColumn("custrecord_jj_program","CUSTRECORD_JJ_MADITRAINGCOURSE", null),
                    new nlobjSearchColumn("custrecord_course_prices_person_price", "CUSTRECORD_MADI_TRAINING_COURSE", null),
                    new nlobjSearchColumn("custrecord_course_prices_person", "CUSTRECORD_MADI_TRAINING_COURSE", null),
                    new nlobjSearchColumn("formulatext").setFormula("CASE WHEN {custrecord_madi_course_image} IS NOT NULL THEN 'https://5102772-sb1.app.netsuite.com/'||{custrecord_madi_course_image} END")
                ]
            );

            if (coursesSearch && coursesSearch.length > 0) {
                obj = {
                    name: coursesSearch[0].getValue("name"),
                    id: coursesSearch[0].getValue("internalid"),
                    badge: coursesSearch[0].getValue("custrecord_madi_course_badge"),
                    courseBreakdown: coursesSearch[0].getValue("custrecord_madi_course_breakdown"),
                    courseDescription: coursesSearch[0].getValue("custrecord_madi_course_description"),
                    courseDuration: coursesSearch[0].getValue("custrecord_madi_course_duration"),
                    coursePrice: coursesSearch[0].getValue("custrecord_madi_course_price"),
                    courseModules: coursesSearch[0].getValue("custrecord_madi_course_modules"),
                    courseSchedule: this.getDateOptions(coursesSearch[0].getValue("custrecord_madi_course_schedule")),
                    timing: coursesSearch[0].getValue("custrecord_madi_course_timing"),
                    images: coursesSearch[0].getValue("formulatext"),
                    Booking:[],
                    CoursePrices: []
                };
                for (var i in coursesSearch) {
                    obj.Booking.push({ "Date": coursesSearch[i].getValue("custrecord_jj_date", "CUSTRECORD_JJ_MADITRAINGCOURSE", null),
                    'City':coursesSearch[i].getValue("custrecord_jj_city", "CUSTRECORD_JJ_MADITRAINGCOURSE", null),
                    'Day':coursesSearch[i].getValue("custrecord_jj_day", "CUSTRECORD_JJ_MADITRAINGCOURSE", null),
                    'Educator':coursesSearch[i].getValue("custrecord_jj_educator", "CUSTRECORD_JJ_MADITRAINGCOURSE", null),
                    'Program':coursesSearch[i].getValue("custrecord_jj_program", "CUSTRECORD_JJ_MADITRAINGCOURSE", null)});
                    obj.CoursePrices.push({"Price": coursesSearch[i].getValue("custrecord_course_prices_person_price","CUSTRECORD_MADI_TRAINING_COURSE", null),
                    'Person':coursesSearch[i].getValue("custrecord_course_prices_person", "CUSTRECORD_MADI_TRAINING_COURSE", null),})
                }
                return obj;
            }
            return false;
        },