Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (245)
  • Dynamics NAV (4,697)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (4,519)
  • ERP general (347)
  • Information management (58)
  • Off-topic (45)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

Populair

  • Why is my system slow? Performance and Dynamics NAV 6.4k views
  • MS Project basishandleiding 6k views
  • Microsoft Dynamics NAV: Copy Table Data from one Company to another Company 5.9k views
  • How to Determine Who Has a Table Locked in Microsoft Dynamics NAV 5.6k views
  • Using REST/Json web services from NAV 5.6k views
  • The metadata object Table 0 was not found error 5.4k views
  • Call external web service using new CU 1290 4.9k views
  • How to print barcodes on a Microsoft Dynamics NAV report 4.7k views
  • Setting default Printer Selections in NAV 4.6k views
  • Microsoft Dynamics NAV How To: Override the ‘5000’ Limit When Exporting Using Microsoft Excel 4.4k views

SQL view – NAV

By admin in Dynamics NAV, Tips & tricks 7 December 2016

I just experienced a case where Client want to see a common list Page in NAV where he can see a data which is basically a combination of multiple Tables. Though it’s achievable in NAV but you need to write a bulky code on the page which eventually turns off the Performance.

Bron : Research – Develop – Share – Repeat
Lees meer…

Share this:

  • Facebook
  • LinkedIn
  • WhatsApp
  • Twitter
  • Email
  • Print

Like this:

Like Loading...

Gerelateerde artikelen:

  1. Check Valid Zip Code
  2. Create SQL Job – Stored Procedure
  3. Disable specific Keyboard Keys – Single Line of Code
  4. Append String – Use DotNet Variable
  5. Custom Page – Dynamics NAV
Tags SQLView
Dynamics NAV Coffee Break: How to Use the Adjust Cost/Price
HelloWorld.al

Related Articles.

Inline Query | SQL like Queries in Business Central

19 Nov, 2020

Read-scale out with Azure SQL and Dynamics 365 Business Central

18 May, 2020

Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler

07 Apr, 2020

Testing Saved Views and Notes in MSDYN365BC 2019 Release 2 Preview

29 Aug, 2019

Integrate MVC Web Applications with Business Central SOAP About MVC (Model View Controller)

26 Jul, 2019

If your work becomes your passion…

Pardaan.com

Microsoft Dynamics NAV, Business Central, ERP general, Projectmanagement, Information management and Visual C#

Cornator

  • 904
  • 1,336
  • 35,412
  • 529,743

Facebook pagina

Facebook pagina
Dennis Pardaan

Start with Why

Stay Hungry, Stay Foolish

RSS Mibuso

  • Upgrade BC Version 13 to Version 17 without C/AL changes
  • Field locked for editing
  • Belgian localisation
  • Where does my Item.Picture hide?
  • How to edit the Find row in Items by location Matrix.
  • Removing Default buttons from a ListPart in NAV2018
  • High CPU load when starting NAV service tiers
  • Nav.Client.exe -consolemode Parameter not working with 140?
  • Transfer Generic Diagrams
  • Nav Serialization Enhancement
  • How can automate the serial number assignation
  • Debug Onprem with AAD Authentication
  • NAV 2013 / Net Tcp Port Sharing / Dedicated service account
  • How to make single Purchase Receipt against multiple Purchase Orders.
  • Printing pdf file on network printer by Job Queue/Task Scheduler
  • Why no Notification data type in navision 2016
  • Transfer field selections type options to another field of the same type but on another page
  • BC App Publish - Digital Sign
  • RDLC report with Item table left join to purchase line
  • Insert Sales Lines AFTER Sales Header complete Or aster MakeOrder complete

RSS Dynamics NAV Team Blog

  • Announcing new Dynamics 365 capabilities at Microsoft Ignite
  • Dynamics 365 and Microsoft Teams: extend collaboration across teams
  • Adapt quickly and fulfill efficiently with Dynamics 365 Intelligent Order Management
  • Manage time off requests with Human Resources app for Microsoft Teams
  • Drive personalized interactions with real-time customer journey orchestration
  • Import historical data to optimize fraud protection
  • Join Dynamics 365 and Power Platform at Microsoft Ignite
  • Connect with finance leaders at Finance Reimagined—a free digital event
  • 4 principles of successful voice of the customer programs
  • Why Simple’s CEO thinks exciting times are ahead in 2021

RSS Power BI

  • Announcing Premium Gen 2 Autoscale Preview
  • Premium Gen2 utilization analysis app now available
  • Announcing VNet Connectivity for PBI Datasets (Public Preview)
  • Announcing Power BI Premium Per User general availability and autoscale preview for Gen2
  • Announcing the new Power BI embedded analytics playground (preview)
  • Announcing public preview of Object-Level Security in Power BI
  • Announcing General Availability (GA) of the Power BI connector for Databricks
  • On-premises data gateway February 2021 update is now available
  • What’s new with ArcGIS for Power BI
  • Power BI February 2021 Feature Summary
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: