Retali Adding Lookup in view with out ueing lookup method 3 fields exp StoreNumber, StoreNumber, Name

Retali  Adding Lookup  with out ueing lookup method 3  fields  exp   StoreNumber, StoreNumber, Name

 1 Views

1 datasource

2 RetailChannelTable_1

RetailStoreTable_1

2 table

This are tables retalis

 3 Forms

pramod_RetailStore

Lookup method

void lookupStore(FormControl control)

{

    Query                   query = new Query();

    QueryBuildDataSource    queryBuildDataSource;

    SysTableLookup          sysTableLookup;

    ;

    sysTableLookup = SysTableLookup::newParameters(tablenum(pramod_RetailStore), control);

    sysTableLookup.addLookupfield(fieldnum(pramod_RetailStore, StoreNumber), true);

    sysTableLookup.addLookupfield(fieldnum(pramod_RetailStore, StoreNumber), false);

    //

    queryBuildDataSource = query.addDataSource(tablenum(pramod_RetailStore));

    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();

}

 Data source  executeQuery method

public void executeQuery()

{

    QueryBuildDataSource    qbds;

    QueryBuildRange         qbr;

    str         _RetailStore;

    ;

        _RetailStore = ChannelType.valueStr();

        qbds = pramod_RetailStore _ds.query().dataSourceTable(tableNum(pramod_RetailStore));

        qbds.clearRanges();

        //qbr  = qbds.addRange(fieldNum(IDT_RetailStore,RecId)); // for RecID

        qbr  = qbds.addRange(fieldNum(pramod_RetailStore,storeNumber));

        qbr.value(strFmt("%1",_RetailStore));

    super();

}

Add  Group button

Add EitdString method   name  Chnnel Name  label : StoreChannelType

Than  add gird

Fields

Int64Eitd  data type

1 pramod_RetailStore_RecId

Combobox

2 pramod_RetailStore_ChannelType

String eitd

3 pramod_RetailStore_StoreNumber

String  eitd

4 pramod_RetailStore_Name

 4 job

static void RetailStore(Args _args)

{

    RetailStoreTable    storeTable;

    RetailChannelTable  channelTable;

    DirPartyTable       partyTable;

    DirOrganizationBase organizationbase;

    OMInternalOrganization  internalorganization;

    OMOperatingUnit     operatingUnit;

    ;

    while select storeTable join

        channelTable where channelTable.RecId == storeTable.RecId

            join operatingUnit where operatingUnit.RecId == channelTable.OMOperatingUnitID

                join internalorganization where internalorganization.RecId == operatingUnit.RecId

                    join organizationbase where organizationbase.RecId == internalorganization.RecId

                        join partyTable where partyTable.RecId == organizationbase.RecId

    {

        info(strFmt("%1  --- %2 --%3",storeTable.StoreNumber,partyTable.Name,channelTable.ChannelType));

    }

}