Filter By Field

[ist]

Hi,
Fist I'm apologize for my English.
I have a following situation:

I must change ItemId lookup into InventJournalTransfer form, becouse I must display ExtCodeValue from ExtCodeValueTable (if any) for the items.
I have created new form in AOT form node.In datasource node (on the form), I have added two tables: InventTable and ExtCodeValueTable. JoinSource on the ExtCodeValueTable is InventTable and JoinMode is OuterJoun becouse some items may has not external code.InventTable and ExtCodeValueTable has link - InventTable.RecId = ExtCodeValueTable.ExtCodeRelationRecId.The form have a grid control with some fields from standart lookup (InventTable), and one field from ExtCodeValueTable (ExtCodeValue which is external code).
The problem is:
I have to filter by ExtCodeValue.When I click "FilterBySelection" on contectMenu in field column, it's executed filter method on the fieldControl.In this method I do this:

PHP код:

public void filter(str _filterStr)
{
    Query query = InventTable_Q;
    ;
    if(query.dataSourceTable(tableNum(ExtCodeValueTable)).joinMode() == JoinMode::OuterJoin)
    {
        query.dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::InnerJoin);
        InventTable_ds.executeQuery();
    }
    super(_filterStr);
} 


the filter is removed from removeFilter method on the InventTable datasource that I have overrided.

public void removeFilter()
{
    Query query = InventTable_Q;
    ;
    if(query.dataSourceTable(tableNum(ExtCodeValueTable)).joinMode() == JoinMode::InnerJoin)
    {
        query.dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::OuterJoin);
        InventTable_ds.executeQuery();
    }
    super();
}

To this all is ok , but when i filtering with "Find by Field" from context menu on the ExtCodeValue column, I want to change also JoinMode to InnerJoin.The problem is that I dont know which method is invoked for this comand. The Dasource(InventTable) method findValue() is not invoked although that in the help write exact this.

thank you in advance.

[EVGL]

.executeQuery() is called.

[ist]

Цитата:

Сообщение от EVGL

.executeQuery() is called.

Ok but how I can distinctwish executeQuery() with and without filtering?
When "filter by field" is enabled i have to change JoinMode from OuterJoin to InnerJoin.

[EVGL]

Цитата:

Сообщение от ist

Ok but how I can distinctwish executeQuery() with and without filtering?
When "filter by field" is enabled i have to change JoinMode from OuterJoin to InnerJoin.

Maybe you cannot.
Try to look if a range exists on your field.

[ist]

Цитата:

Сообщение от EVGL

Maybe you cannot.
Try to look if a range exists on your field.

When it is filtering with "Filter By Field" strange why executeQuery did not invoke.

public void executeQuery()
{
    QueryBuildRange qbr;
    Query query = this.query();
    ;
    qbr = this.query().dataSourceTable(tableNum(ExtCodeValueTable)).findRange(fieldNum(ExtCodeValueTable, ExtCodeValue));
    if(qbr)
    {
        query.dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::InnerJoin);
    }
    super();
}

The debuger does not stop on the breakpoint

[ist]

Цитата:

Сообщение от EVGL

Maybe you cannot.
Try to look if a range exists on your field.

When it is filtering with "Filter By Field" strange why executeQuery did not invoke.

public void executeQuery()
{
    QueryBuildRange qbr;
    Query query = this.query();
    ;
    qbr = this.query().dataSourceTable(tableNum(ExtCodeValueTable)).findRange(fieldNum(ExtCodeValueTable, ExtCodeValue));
    if(qbr)
    {
        query.dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::InnerJoin);
    }
    super();
}

The debuger does not stop on the breakpoint

[Russland]

1. Override filter() method on ExtCodeValue field (ExtCodeValueTable data source) like this:

public void filter(str _filterStr, NoYes _clearPrev)
{
    if(!_filterStr)
        _filterStr = InventTable::findRecId(ExtCodeValueTable.ExtCodeRelationRecId).ItemId;

    InventTable_ds.query().dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::InnerJoin);
    InventTable_ds.executeQuery();

    super(_filterStr, _clearPrev);
}

2. Override removeFilter() method on InventTable data source:

public void removeFilter()
{
    InventTable_ds.query().dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::OuterJoin);
    InventTable_ds.executeQuery();

    super();
}

Hope it will solve your problem

[ist]

Цитата:

Сообщение от Russland

1. Override filter() method on ExtCodeValue field (ExtCodeValueTable data source) like this:

public void filter(str _filterStr, NoYes _clearPrev)
{
    if(!_filterStr)
        _filterStr = InventTable::findRecId(ExtCodeValueTable.ExtCodeRelationRecId).ItemId;
 
    InventTable_ds.query().dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::InnerJoin);
    InventTable_ds.executeQuery();
 
    super(_filterStr, _clearPrev);
}

2. Override removeFilter() method on InventTable data source:

public void removeFilter()
{
    InventTable_ds.query().dataSourceTable(tableNum(ExtCodeValueTable)).joinMode(JoinMode::OuterJoin);
    InventTable_ds.executeQuery();
 
    super();
}

Hope it will solve your problem

All is OK.Thank'a a LOT.