31.01.2013, 14:26 | #1 |
Junior AX Developer
|
Could not filter on Fact Box by form datasource
Hey Guys,
at first i want to explain what the request of the customer is: On AX2012 R2 Environment the customer wants a factbox on the products to show sales agreements where the selected itemId is contained in the lines (and a range on the state of the sales agreement and on the expirationDate, but that works). So i created objects alike the PurchaseOrder form "additional information" fact box. My Steps: Created a Query like "SalesAgreementListPage" and added [AgreeementLine] and [InventTable] to the DataSources with Relations and InnerJoin. Created a menu item with following porperties: Query: my created query Form: SalesAgreementListPage Then a modified the standard Query of the form (SalesAgreementListPage) to having the InventTable and the AgreementLine also. (otherwise the call would cause an error) Created a preview Part. Created a Cue setting the new menu item in properties and the preview part. Created a CueGroup and added a Reference to my new Cue. On the Form "EcoResProductPerCompanyListPage" i added a part reference to the cue group and set the DataSource in the properties to "InventTable". My Problem: Evereything works fine except the filter on ItemId field. The other two Ranges are working and the fact box displays all well. But it totally ignores the ItemId from the InventTable in the form. What i've tried: - playing around with join modes and fetch modes - checked all properties on menu items, cues, querys, datasources etc - created a dynamic link between InventTable and AgreementLine in the relations on InventTable - turned around the structure of the DataSources in my Query ==> caused error while opening the form because it couldn't find the Datasources on the form then (i think it compares the names and the order). Can anyone please give me a hint what i am doing wrong?? I attached some screenshots of the objects and its properties. axforum1.png: Part Reference on the form axforum2.png: MenuItem properties axforum3.png: My Query axforum4.png: properties of the cue
__________________
Kind Regards Robin |
|
|
|