Is there a way to filter the schema objects using the SQL connector in a data provider?
While I am only using one table I see reference to all the tables in the import scenario XML
Answer
Import Scenario From SQL. Filter Schema Objects SQL Data Provider
Best answer by cmoreland
When you create the data provider, manually type in the table (or view) name of the object field (and do NOT click FILL SCHEMA OBJECTS) then you will only see the table you want to use. Then you can click FILL SCHEMA FIELDS to load the fields from the table.
No way to filter it afterwards? I see the you can edit the command under the » menu. I just really dont want to recreate it if I don’t need to
When you create the data provider, manually type in the table (or view) name of the object field (and do NOT click FILL SCHEMA OBJECTS) then you will only see the table you want to use. Then you can click FILL SCHEMA FIELDS to load the fields from the table.
When you create the data provider, manually type in the table (or view) name of the object field (and do NOT click FILL SCHEMA OBJECTS) then you will only see the table you want to use. Then you can click FILL SCHEMA FIELDS to load the fields from the table.
No way to filter it afterwards? I see the you can edit the command under the » menu. I just really dont want to recreate it if I don’t need to
+19Hi
Hope this helps!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.