25.10.2007, 16:52 | #1 |
Участник
|
Filter By Field
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 код:
X++: 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(); } thank you in advance. |
|