Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Using two dataitems on the same level

Posted on by 382

Hello everyone, just wanted to ask that how can we use two dataitems on same level in a query. Below image will elaborate more. Kindly help.

pastedimage1673264120555v1.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: Using two dataitems on the same level

    Hi, If the two DataItems are completely unrelated, you can create two Query and combine them on the page (Temporary table). This doesn't affect performance much.

    A simple example:

    https://yzhums.com/4869/

    Hope this helps

    Thanks.
    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Using two dataitems on the same level

    Hi

    you should actually explain the purpose of your request

    what is your main dataitem?

    DAniele

  • RE: Using two dataitems on the same level

    I want to ask that will it make a difference? if put it as a nested data item or we have to change the sqljointype when we put it as a nested data item. Or we have to create another query if we want it seperate?

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Using two dataitems on the same level

    Hi Anas,

    It is not possible to have two dataitem at same level in Query. 

    You can share for what purpose you need it for then I can try to suggest.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans