Skip to main content



No record found.

Microsoft Dynamics SL forum
Suggested answer

SL 2011 Quick Query

Posted on by 595

Can a custom query be created to use the aptran, pjtran and purorddet tables or are the queries limited to a single table?


  • Suggested answer
    Erich Strelow F Profile Picture
    Erich Strelow F 1,642 on at
    RE: SL 2011 Quick Query

    Quick Query are based on SQL views. In theory, any query that can be built as a view can work out. The only restriction I remember is that in order to use the pagination feature, there must be a unique key (can be a combination of fields) through the view.

  • Suggested answer
    John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: SL 2011 Quick Query

    Basically, any query you can write & get working in SQL can be used to create a new custom Quick Query.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans