Skip to main content

Notifications

Announcements

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?

Cherie

  • 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 . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans