Query

1)Return Top ProductGroup

client static void lookupProductGroup(FormStringControl   ctrl,str productGroup = '' )
{
    //Add by umfish 20100727
    SysTableLookup          sysTableLookup;
    Query                   query;
    QueryBuildDataSource    qbdInventProductGroup;
    QueryBuildDataSource    qbdInventProductGroupBom;
    QueryBuildRange         queryBuildRange,rangChild;
    InventProductGroupBOM      inventProductGroupBom;
    ;
    sysTableLookup = SysTableLookup::newParameters(tablenum(InventProductGroup), ctrl);

    sysTableLookup.addLookupfield(fieldnum(InventProductGroup, ProductGroupId));
    sysTableLookup.addLookupfield(fieldnum(InventProductGroup, Name));

    query = new Query();
    qbdInventProductGroup = query.addDataSource(tablenum(InventProductGroup));
    qbdInventProductGroupBom = qbdInventProductGroup.addDataSource(tablenum(InventProductGroupBOM));
    qbdInventProductGroupBom.joinMode(JoinMode::NoExistsJoin);
    qbdInventProductGroupBom.addLink(fieldnum(InventProductGroup,ProductGroupId), fieldnum(InventProductGroupBOM, ChildProductGroupId));

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

2) Return Child ProductGroup

client static void lookupChildProductGroup(FormStringControl   ctrl,str ParentProductGroup = '' )
{
    //Add by umfish  20100728
    SysTableLookup          sysTableLookup;
    Query                   query;
    QueryBuildDataSource    qbdInventProductGroup;
    QueryBuildDataSource    qbdInventProductGroupBom;
    QueryBuildRange         queryBuildRange;
    ;
    sysTableLookup = SysTableLookup::newParameters(tablenum(InventProductGroup), ctrl);

    sysTableLookup.addLookupfield(fieldnum(InventProductGroup, ProductGroupId));
    sysTableLookup.addLookupfield(fieldnum(InventProductGroup, Name));

    query = new Query();
    qbdInventProductGroup = query.addDataSource(tablenum(InventProductGroup));
    qbdInventProductGroupBom = qbdInventProductGroup.addDataSource(tablenum(InventProductGroupBOM));
    queryBuildRange = qbdInventProductGroupBom.addRange(fieldnum(InventProductGroupBOM,ParentProductGroupId));
    queryBuildRange.value(ParentProductGroup );
    qbdInventProductGroupBom.joinMode(JoinMode::ExistsJoin);
    qbdInventProductGroupBom.addLink(fieldnum(InventProductGroup,ProductGroupId), fieldnum(InventProductGroupBOM, ChildProductGroupId));


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