Copy filtered Custom View Data to another Database
currently we are looking for a solution for the following problem:
We connect 2 databases to the project.
1. We created a custom view on the MSSQL Database
2. Accessing the List page of the view we filter the data for special field view.
3. We want to select the filtered data and create a button for inserting the selected data into another table of the project in the second database (MYSQL).
The Problem is, that we cannot select the filtered data in the custom view nor we are able to create a button to import the selected data (or even the filtered data) to the other table.
We tried to access the array data and pass it to the other table by custom coding but did't get it working.
Is there an way to get this working without custom coding.
I didn't find the right solution from the Internet.