You’re offline. This is a read only version of the page.
Hi Community!
I'm looking for inspiration for following case:
I think that I should use virtual tables connected with prepared SQL view but virtual tables have search limitations.
So, going to the end, do you know a way where I can search all SQL view in Dynamics Sales to filter product list?
I will appreciate any ideas how it can be solved...
Virtual tables can maximum read 1000 records, though this sounds like a limitation, but 1000 isn't small, it's not easy to fit 1000 records on a single screen, so you can have a paged view or records where every page you read up to 1000 records and pass a page parameter to your SQL to it returns only next 1000 records.
Share
Report
All responses (
Answers (
946
