hello i want only those contracrot who belongs to electrical.
cur_frm.fields_dict['contractual_work_scope'].grid.get_field('contractor_awarded').get_query = function(doc, cdt, cdn) {
console.log(doc)
return{
filters:{'scope_of_work': "Electrical"}
}
};
it gives error InternalError: (1054, u"Unknown column ‘tabContractors.scope_of_work’ in ‘where clause’") because scope of work present in its child table called contractor_scope