How to make multiple reference selector and use filter by expression?
0
Hello Community, I'm currently developing an app managing budgets. As a newbie to this field, I find myself encountering challenges with each new step I take. Consequently, I'm turning to this forum in the hope of finding some much-needed guidance. I have two primary issues that I need help with: 1.Trouble with Cluster_Title Attribute MappingMy domain model is structured as follows: I have successfully imported data into the 'cluster' and 'cost center' using Excel Importer and MXModel Reflection. When I navigate to the respective pages for 'cluster' and 'cost center,' the data appears correctly. However, the problem arises on my 'forecast' page, where I intended to map data from both 'cluster' and 'cost center.' The first column, which should display the 'Cluster-Title,' is not showing any data. Additionally, although I am able to select options from a dropdown list on the edit page, I am unsure if I am expected to manually select from hundreds of these entries. The data source for all columns is the 'forecast' entity, and the 'Cluster Title' is supposed to be linked through the association 'Forecast_cluster:Title attribute.' How can I correctly map the 'Cluster Title' to display in the first column of my 'forecast' page? 2. Issues with Multiple Reference SelectorFor filtering purposes, I implemented a Filter NPE for the dropdown selection. The first criterion filters by 'cost center,' which seems to work as intended (OCH save changes-No auto sync), and the second should filter by 'fiscal year' based on the 'cost center' selection. However, the dropdown menus are abundant and fail to filter the data by year.I tried to modify the microflow (MF) using a list operation filter, but not sure if my approach is correct. Despite having read through numerous similar queries and their explanations, I find that the details provided are enough for me to follow. Could anyone provide me with some insight or step-by-step guidance on how to address these problems? Thank you very much in advance.