Crm Newshubb
Advertisement
  • Home
  • News
  • CRM Software & Tools
  • Contact us
No Result
View All Result
  • Home
  • News
  • CRM Software & Tools
  • Contact us
No Result
View All Result
Crm Newshubb
No Result
View All Result
Home CRM Software & Tools

D365 Business Central : Using Query to Get Distinct Values

admin by admin
July 31, 2022
in CRM Software & Tools


Posted By Teddy on 1 Aug 2022 in Dyn365BC, Dyn365CE

When working with table data, there will be times when we need to retrieve a unique record value (also called SELECT DISTINCT) from the table. D365 Business Central does not provide this logic out of the box so we will need to find a way to do this ourselves.

We can use combination of looping and temporary table to find distinct values. However, I found that using Query is the easiest…

Continue Reading thatnavguy’s Article on their blog

D365 Business Central : Using Query to Get Distinct Values – That NAV Guy

When working with table data, there will be times when we need to retrieve a unique record value (also called SELECT DISTINCT) from the table. D365 Business Central does not provide this logic out of the box so we will need to find a way to do this ourselves.

Blog Syndicated with thatnavguy’s Permission

More About This Author

Teddy
Experienced NZ-based NAV Developer and Consultant with 10+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central.
I have led multiple Dynamics NAV and Business Central projects for businesses in Asia, such as Japan, Singapore, and Indonesia, and currently in both Australia and New Zealand.
I am passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs. I believe in adding value to people’s lives and try to leave people better than when I first met them.

Author: Teddy

Experienced NZ-based NAV Developer and Consultant with 10+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central.
I have led multiple Dynamics NAV and Business Central projects for businesses in Asia, such as Japan, Singapore, and Indonesia, and currently in both Australia and New Zealand.
I am passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs. I believe in adding value to people’s lives and try to leave people better than when I first met them.



Source link

Previous Post

export users assigned roles from one environment into another

Next Post

How We Use DocumentsCorePack at P2 Automation

Next Post

How We Use DocumentsCorePack at P2 Automation

Recommended

Xrm.Navigation.openAlertDialog popup not visible completly

July 28, 2022

Hillel Fuld on The Oops Factor

August 5, 2022

Dynamics 365 On Premise Monitoring Service Settings

August 7, 2022

ToolUp Days #13 – YouTube

August 7, 2022

Don't miss it

CRM Software & Tools

Liz Pham on The Oops Factor

August 12, 2022
News

How to Leverage AI to Increase Customer Retention

August 12, 2022
News

Vtiger CRM Blog » Six Benefits of e-Learning for Organizations

August 12, 2022
News

Power Platform – Dynamics 365: Technical Update Briefing: August 25

August 12, 2022
CRM Software & Tools

6 CRM Field Service Trends

August 11, 2022
CRM Software & Tools

The Role of CRM in an Omni-Channel Strategy

August 11, 2022

crm-white

© 2022 CRM News Hubb All rights reserved.

Use of these names, logos, and brands does not imply endorsement unless specified. By using this site, you agree to the Privacy Policy.

Navigate Site

  • Home
  • News
  • CRM Software & Tools
  • Contact us

Newsletter Sign Up

No Result
View All Result
  • Home
  • News
  • CRM Software & Tools
  • Contact us

© 2022 CRM News Hubb All rights reserved.