Thursday, 29 March 2012

lookup filter on table level on form

make new field on table and drag on form design
Write code on table methods:
//Created by Loveleen on 29/3/2012
public static void lookupNumberSequenceGroup(FormControl _formControl)
{
    SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tablenum(NumberSequenceGroup), _formControl);
    Query                   query = new Query();
    QueryBuildDataSource    queryBuildDataSource;
    QueryBuildRange         queryBuildRange;
    ;

    queryBuildDataSource    = query.addDataSource(tablenum(NumberSequenceGroup));
    queryBuildRange         = queryBuildDataSource.addRange(fieldnum(NumberSequenceGroup, Active));
    queryBuildRange.value(queryValue(NoYes::Yes));

    sysTableLookup.addLookupfield(fieldnum(NumberSequenceGroup, numberSequenceGroupId));
    sysTableLookup.addLookupfield(fieldnum(NumberSequenceGroup, description));

    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();
}
//

Call on form datasource field (related)where you want lookup
//Created by Loveleen on 29/3/2012
public void lookup(FormControl _formControl, str _filterStr)
{
    super(_formControl, _filterStr);
    NumberSequenceGroup::lookupNumberSequenceGroup(_formControl);
}

No comments:

Post a Comment