Hide Current company
In Lookup Hide Current company
Form level filed look up
[DataField]
class BuildingUnitId
{
public void lookup(FormControl _formControl, str _filterStr)
{
FlxBuildingUnitRelations::lookupBuildUnitId(_formControl,FlxBuildingUnitRelations.BuildingId,UnitRelation_Floor.text(),FlxBuildingUnitRelations.FlxBuildingUnit);
}
}
table method
public static void lookupInvoicingCompanyId(FormStringControl _formStringControl)
{
SysTableLookup tableLookup;
Query query = new Query();
tableLookup = SysTableLookup::newParameters(tableNum(DataArea), _formStringControl);
tableLookup.addLookupfield(fieldNum(DataArea,id),true);
tableLookup.addLookupfield(fieldNum(DataArea,Name),true);
QueryBuildDataSource qbds = query.addDataSource(tableNum(DataArea));
qbds.addRange(fieldNum(DataArea,id)).value(SysQuery::valueNot(curExt()));
tableLookup.parmQuery(query);
tableLookup.performFormLookup();
}