138
Hi Members,
I need to arrange the columns in a query which are fetched from multiple tables in Business Central. For instance, consider a scenario where I am using 3-4 tables in Business central and fetching datas in the same way which I had entered in the query page. But when I am doing so, I am not able to get or able to arrange the columns in an orderly way which I actually needed.
Please suggest me a solution to the current issue that I am facing.
Thanks & Regards,
Saravanan M
Hi
Adding info
Regards
Amit Sharma
Dear Yunzhu,
Thank you for your reponse. I would like to inform you that I already went through your blog related to the 'Query Category'. It was very helpful and a great guidance to my learning. But, here the scenario goes like, arranging the columns fetched from various tables in Business Central through Query. For example, consider that I am taking three tables.. i.e Sales Invoice, Sales Invoice Header, Sales Invoice Line. Consider a situation that I am choosing around 10 fields from each table and writing a query. When the Query page is executed, I could find all the fields that I had mentioned in the query retrives with value. Now I wish to change the order or position of the columns(fields) accordingly (For Ex., Sales order number, Sales order document number, Item number, Item Description, Quantity, Price etc.) to establish a pleasing view (between the fields that are related with one another) who runs the query.
Please suggest me an alternative solution to the current scenario.
Thanks and Regards.
Saravanan M
Hi, Generally for Query, you can use the OrderBy Property to sort table fields in the page view in ascending or descending order.
If this does not meet your needs, I suggest you create a page to display the data of this Query, which can do more things. more details: https://yzhums.com/4869/
For examlpe,
query 50100 "ZY Purchase Order Query" { Caption = 'ZY Purchase Order Query'; OrderBy = Descending(Buy_from_Vendor_No_); QueryCategory = 'Vendor List', 'Purchase Order List';
}
Hope this helps.
Thanks.
ZHU
Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.
I will open this up to the community in case they have something to add.
#1
André Arnaud de Cal...
291,602
Super User 2024 Season 2
#2
Martin Dráb
230,340
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
