Finance | Project Operations, Human Resources, ...

Parameter need to pass on data entity in d365fo

(1) Share

Report

Posted on by @rp@n

5,903

Hi team,

I have a button in form. When we clicked this button it will be connected to an entity UCL_CustCustomerV3Entity and download the data project.

My requirement is before downloading the data project we like to do some filer on data.

For example - when user clicked on the button,then we should pass the refrence of active record from the form to the button and that reference also need to filter with the table on the data entity, so that when we will EXPORT the customer master we should get specific data only not all the data in Excel.

For example -

Suppose in form we have five customers.

CU001,CU002,CU003,CU004,CU005

Suppose user select the customer CU004 in the form and clicked on the button then it should export the specific customer only not all customers.

How we can achieve this in d365fo.

Kindly let me know the approach pls.

Thanks!

Categories:

Dynamics 365 Finance

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 230,351 Most Valuable Professional on at

Like (0)

Report

Parameter need to pass on data entity in d365fo

If you use DMFEntityExporter.exportToFile() to export the data, the query can be set in queryData parameter.
@rp@n 5,903 on at

Like (0)

Report

Parameter need to pass on data entity in d365fo

In which method I need to write the query in data entity and how will I pass the active record on data entity to filter the data accordingly.

Kindly provide me an example pls
@rp@n 5,903 on at

Like (0)

Report

Parameter need to pass on data entity in d365fo

Thanks Mohamed.

Kindly give me some reference pls. So, based on your reference, I will follow to replicate the same.

Thanks in advance.
Suggested answer

Mohamed Amine Mahmoudi 9,710 Super User 2024 Season 2 on at

Like (0)

Report

Parameter need to pass on data entity in d365fo

Hi @@rp@n,

I think you must add query to filter the data in your data entity.

Bst regards,

Mohamed Amine MAHMOUDI