require(["N/query"], function (query) {

const myquery = query.create({

type: "customrecord_name_of_record",

});

const otherRecordJoin = myquery.join({

fieldId: "custrecord_field_id",

target: "customrecord_custom_record",

});

myquery.columns = [

myquery.createColumn({

fieldId: "custrecord_order",

alias: "order",

}),

otherRecordJoin.createColumn({

fieldId: "custrecord_invoiced",

alias: "invoiced",

}),

];

myquery.condition = myquery.createCondition({

fieldId:  _// what should i enter here to get the invoiced field?_

operator: <http://query.Operator.IS|query.Operator.IS>,

values: false,

});

myquery.sort = [

myquery.createSort({

column: myquery.columns[0],

}),

];

const resultSet = myquery.run();

if (resultSet) console.log(resultSet.asMappedResults());

});

You don't need to explicitly create the join. Just add

customrecord_custom_record.custrecord_field_id

as your fieldId to your columns and use that same string in the condition.

thank you

You didn't do otherRecordJoin.create(), right? Do myquery.createColumn() with the joined id in there

let me show you so we can be on the same page

I personally would just use SuiteQL syntax instead of the verbose query.create() and query.columns if you are starting from scratch

require(["N/query"], function (query) {

const towerWorkOrderDetailsQuery = query.create({

type: "customrecord_sci_tower_work_order_detail",

});

const towerWorkOrderJoin = towerWorkOrderDetailsQuery.join({

fieldId: "custrecord_sci_towerworkorderiddetl",

target: "customrecord_sci_tower_work_order",

});

towerWorkOrderDetailsQuery.columns = [

towerWorkOrderDetailsQuery.createColumn({

fieldId: "custrecord_sci_towerworkorderiddetl", _//weight_

alias: "WorkOrder",

}),

towerWorkOrderJoin.createColumn({

fieldId: "custrecord_sci_towerworkorder_sitename", _//site name_

alias: "SiteName",

}),

towerWorkOrderJoin.createColumn({

fieldId: "custrecord_sci_towerworkorder_location", _//warehouse_

alias: "Warehouse",

}),

towerWorkOrderJoin.createColumn({

fieldId: "custrecord_sci_towerworkorder_ponumber", _//po number_

alias: "PoNumber",

}),

towerWorkOrderJoin.createColumn({

fieldId: "custrecord_sci_towerworkorder_cust", _//customer_

alias: "Customer",

}),

towerWorkOrderDetailsQuery.createColumn({

fieldId: "custrecord_sci_towerworkorder_d_item", _//item_

alias: "Item",

}),

towerWorkOrderDetailsQuery.createColumn({

fieldId: "custrecord_sci_towerworkorder_d_desc", _//description_

alias: "Description",

}),

towerWorkOrderDetailsQuery.createColumn({

fieldId: "custrecord_sci_towerworkorderd_qty", _//quantity_

alias: "Quantity",

}),

towerWorkOrderDetailsQuery.createColumn({

fieldId: "custrecord_sci_towerworkorderd_weight", _//weight_

alias: "Weight",

}),

];

towerWorkOrderDetailsQuery.condition = towerWorkOrderDetailsQuery.createCondition({

fieldId: "customrecord_sci_tower_work_order.custrecord_sci_towerworkorder_invoiced", _//invoiced_

operator: <http://query.Operator.IS|query.Operator.IS>,

values: false,

});

towerWorkOrderDetailsQuery.sort = [

towerWorkOrderDetailsQuery.createSort({

column: towerWorkOrderDetailsQuery.columns[0],

}),

];

const resultSet = towerWorkOrderDetailsQuery.run();

if (resultSet) console.log(resultSet.asMappedResults());

});

likely should be this

custrecord_sci_towerworkorderiddetl.custrecord_sci_towerworkorder_invoiced

thanks