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();
    }

Popular posts from this blog