Hi,
Is there any workaround to link EpiBinding with the DataTable in coding.
I mean I will filter record by placing different option in dashboard, will pass those to SP and return the table value into DataTable.
Then these dt i want to link to EpiBinding so that dashboard when refresh will display the DataTable record.
Then I can use default feature of Dashboard like publish, filter etc etc.
Hope there is a way to achieve this.
Thanks.
You can create an EpiDataView and then bind the field.
EpiDataView edvSP = new EpiDataView();
edvSP.dataView = dtSP.DefaultView;
EpiTextBoxC1.EpiBinding = edvSP.MyField;
Hi Jason,
I tried using datasource, record is pulling from DataTable. But actually, dashboard is updatable dashboard. If I manually create DataTable and link to gridview, all row will show in dashboard but Update is not working.
Is there anyway we can achieve this. Like publish , updatable all should work even though dashboard gridview is bind with external source ( like datatable)
Fruitful advice would be appreciable.
Hanky
Taking on trust that what you want to achieve is actually sensible, since there are a lot of ways you could wreak havoc doing this kind of thing …
An approach that does work is to move your custom external data access into a uBAQ. Depending on how external the data is and how it’s accessed, you can use “Advanced BPM” and override the base processing for both GetList and Update to handle what you need to when the dashboard gets the data and the user saves.
If you then base your dashboard on that BAQ, the standard Epicor functionality will all be there for any parts of it which do relate to the Epicor system without needing to do anything further.
Another thought; you could use a sql View instead of a sp to access/return the data you’re requiring. The view could be accessed by an external BAQ, which you could then bring in the data into epicor natively via dashboard or programatically.