Skip to content
Primary Menu
  • Home
  • About
  • Blog
  • Tools
  • Twitter
  • LinkedIn
  • GitHub
Mark Carrington

Data, D365, Diabetes, Lego, …

TDS Endpoint Revisited

I've been doing some more work recently with the Dataverse TDS Endpoint, and there's been a few updates to the

Read More

SQL 4 CDS v10 Released

The latest version of the SQL 4 CDS tool is here with a raft of improvements and a few key

Read More

SQL 4 CDS v9.6 released

Lots of new possibilities for working with your Dataverse data with this latest update! (more…)

Read More
Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 2.0.0 released!

Posted On 17th April 202028th September 2020 By Mark Carrington4 Comments

I’m very pleased to release version 2.0.0 of my SQL 4 CDS tool today! If you haven’t come across it before, SQL 4 CDS is an XrmToolBox tool to query and manipulate your CDS data using regular SQL queries, making it accessible to a much wider range of users. You Continue Reading

Category: FetchXML/MSDyn365

Inside FetchXML pt 10 – link-entity (again)

Posted On 5th April 202028th September 2020 By Mark Carrington1 Comment

A follow-up on my previous post on link-entity, prompted by this tweet from Daryl LaBar: Was unaware of the new join operators. @jordimontana @XrmWizard have either of you used these, or know what they are supposed to do? The documentation is rather lacking…https://t.co/Nr4AyZMzb2 — Daryl LaBar (@ddlabar) April 2, 2020

Category: FetchXML/MSDyn365

Inside FetchXML pt 9 – distinct

Posted On 3rd April 202028th September 2020 By Mark Carrington12 Comments

You can ensure your query only produces each row once using the distinct attribute. For example, if you have multiple entries for the same company name you can get the list of unique names using:

Category: FetchXML/MSDyn365

Inside FetchXML pt 8 – page, count & top

Posted On 1st April 202028th September 2020 By Mark Carrington4 Comments

By default you’ll get up to 5,000 records that match your query. The top-level <fetch> element supports a few options to help you control this:

Category: FetchXML/MSDyn365

Inside FetchXML pt 7 – rowaggregate

Posted On 29th March 202028th September 2020 By Mark Carringtoncomment

If you’re using any hierarchies in your data, you’ve probably noticed the icon in your main grid views that you can click on to show the hierarchy view when records have a parent or children. It’s simple to work out if a record has a parent – just check if Continue Reading

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 1.0.9 Released!

Posted On 3rd February 202028th September 2020 By Mark Carrington2 Comments

I’ve just released SQL 4 CDS 1.0.9. Please update it when XrmToolBox prompts you to take advantage of these latest features:

Category: FetchXML/MSDyn365

FetchXML Multiple Links

Posted On 13th January 202028th September 2020 By Mark Carringtoncomment

One common pattern of queries I see about FetchXML is how to write queries to ask two different questions about the same related entity. For example: Invoices that include product A AND product B? Contacts that have pending emails AND no sent emails? Visits that have a page view of Continue Reading

Category: MSDyn365/SQL 4 CDS

SQL 4 CDS 1.0.6 Released!

Posted On 10th January 202028th September 2020 By Mark Carrington23 Comments

I’m very pleased to announce the release of SQL 4 CDS version 1.0.6! Please update your existing versions in XrmToolBox to get some great new features…

Category: FetchXML/MSDyn365

Inside FetchXML pt 6 – datetime grouping

Posted On 6th January 202028th September 2020 By Mark Carrington12 Comments

Last time I looked at aggregates, but unforgivably I missed out how to apply grouping to date/time attributes:

Category: FetchXML/MSDyn365

Inside FetchXML pt 5 – aggregate

Posted On 17th December 201928th September 2020 By Mark Carrington16 Comments

One feature of FetchXML that sets it apart from other CDS query options is aggregates. This is the option to get summary data (number of records, sum of opportunity value etc.) rather than the individual values from each record. If your only concept of how many records you have is Continue Reading

Posts pagination

Previous 1 … 11 12 13 14 Next
  • gelora188
  • https://www.tybeeislandonline.com/
  • Jogjatoto
  • Jogjatoto
  • Jogjatoto
  • Jogjatoto
  • Jogjatoto
  • Jogjatoto
  • Jogjatoto
  • Jogjatoto
  • writingiscake.com
  • Mantraslot
  • Mantraslot
  • kadinpalopokota.org
  • kadinsumselprov.org
  • kadinkalselprov.org
  • kadinokukab.org
  • kadinkaltimprov.org
  • https://www.fitkitonline.com/
  • https://www.noelleswangilbert.com/
  • https://www.agenciaphoenix.com/
  • https://drumstore.org/
  • https://baoforging.id/
  • https://gerbangdigital.id/
  • https://rantour.id/
  • kadinsamarinda.org
  • thetimedirectory.co.uk
  • abraxasblog.co.uk
  • chaceleyvillage.co.uk
  • devonfamily.co.uk
  • dracupuk.co.uk
  • drawingmanager.co.uk
  • droitwichdigital.co.uk
  • drrode.co.uk
  • dspequineservices.co.uk
  • eandevideos.co.uk
  • electricenglish.co.uk
  • englishsoftware.co.uk
  • exerciseangels.co.uk
  • facingtheworld.co.uk
  • fasaonline.co.uk
  • fireflymedical.co.uk
  • firstlineelectronics.co.uk
  • firsttimebuyerhelp.co.uk
  • flawlessimage.co.uk
  • flyfishingvenues.co.uk
  • gargantuangarland.co.uk
  • greenapplestudio.co.uk
  • grilljam.co.uk
  • gurnay.co.uk
  • hampstonian.co.uk
  • harleystearoom.co.Inggris
  • hazelhurstschool.co.uk
  • heagewindmillers.co.uk
  • heritagelodges.co.uk
  • ijstart.co.uk
  • ijstartconnect.co.uk
  • inkcreations.co.uk
  • internetprincess.co.uk
  • intertechvr.co.uk
  • invictadivers.co.uk
  • ioniansystems.co.uk
  • jemmatools.co.uk
  • jessicasteel.co.uk
  • joannerattiganltd.co.uk
  • johnnytherazor.co.uk
  • juuka.co.uk
  • kayeschemist.co.uk
  • keepyourfeetup.co.uk
  • keigs.co.uk
  • keithmartinphotography.co.uk
  • kennedystreetcic.co.uk
  • keylightimage.co.uk
  • krakar.co.uk
  • usatodaycrossword.co.uk
  • ultimateunlocker.co.uk
  • ladyislafashion.co.uk
  • lansonmedical.co.uk
  • learnflycasting.co.uk
  • libelreform.co.uk
  • louisemaryon.co.uk
  • loveatfirstbitecakes.co.uk
  • ltmusem.co.uk
  • ludlowtango.co.uk
  • luminasa.co.uk
  • magicmushroomsonline.co.uk
  • magicspool.co.uk
  • manmart.co.uk
  • markhealey.co.uk
  • marlboroughroadacademy.co.uk
  • threlkeldquarry.co.uk
  • tigerred.co.uk
  • tipplesandtreats.co.uk
  • trafalgarmotorcycles.co.uk
  • turintexels.co.uk
  • turkishcatsociety.co.uk
  • ukafricangrey.co.uk
  • vinylrecordslive.co.uk
  • waldendiver.co.uk
  • waldonwhitejones.co.uk
  • wastevegoil.co.uk
  • westlancsboxers.co.uk
  • whitbridgehouse.co.uk
  • whoschanging.co.uk
  • winforcer.co.uk
  • winsgroup.co.uk
  • wordsearchposter.co.uk
  • wordsonwalls.co.uk
  • worldreview.co.inggris
  • wymbridge.co.uk
  • yorkshiresports.co.uk
  • zooce.co.uk
  • ftpstorage.co.uk
  • foxlea.co.uk
  • fusioni.co.uk
  • https://temiyang.desa.id/
  • https://jcq.icap.edu.pl/
  • pohon169
  • pohon169
  • slot toto
  • hakata136
  • slot gacor
  • slot deposit 1000
  • slot gacor
  • hakata136
  • hakata136
  • toto hk
  • togel hongkong
  • toto hk
  • pg77
  • situs pg77
  • login pg77
  • slot toto
  • Slot Gacor
  • Slot Gacor
  • WEBSITE INI777
  • INI777
  • LOGIN INI777
  • LOGIN POHON169
  • paluapi123
  • tembus777
  • Slot Gacor
  • https://blkbanyuwangi.kemnaker.go.id/
  • Slot Gacor
  • GGPLAY88
  • GGPLAY88
  • GGPLAY88
  • GGPLAY88
  • GGPLAY88
  • slot maxwin
  • slot gacor
  • slot gacor hari ini
  • bantentoto
  • situs toto
  • taipan78
  • liga788
  • TIKET33
  • TIKET33
  • TIKET33
  • VICTORY88
  • VICTORY88
  • VICTORY88
  • INI777
  • NENEK188
  • MASTERTOGEL
  • MASTERTOGEL
  • MANTRASLOT
  • MANTRASLOT
  • jabartoto
  • papuatoto
  • wisdomtoto
  • slot gacor
  • slot taruhan 200
  • sakautoto
  • jogjatoto
  • slot gacor
  • slot gacor
  • slot gacor
  • toto slot
  • slot gacor
  • Slot Gacor
  • slot gacor
  • situs toto
  • posototo
  • jejuslot
  • posototo
  • posototo
  • slot gacor
  • situs toto
  • posototo
  • slot deposit 1000
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Anaboytoto
  • Anaboytoto
  • slot toto
  • toto slot
  • gerhanatoto
  • tarungtoto
  • tarungtoto
  • tarungtoto
  • sakautoto
  • sakautoto
  • sakautoto
  • sakautoto
  • anoboytoto
  • anoboytoto
  • Slot Gacor
  • pohon169
  • Slot Gacor
  • slot gacor
  • anoboytoto
  • anoboytoto
  • anoboytoto
  • desabet
  • gerhanatoto
  • kupangtoto
  • kupangtoto
  • kupangtoto
  • jogjatoto
  • jogjatoto
  • papuatoto
  • posuslot
  • slot gacor
  • situs toto
  • toto slot
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • Slot Gacor
  • jujur4d
  • jesoslot
  • slot gacor
  • slot gacor
  • toto slot
  • toto slot
  • bandungtoto
  • toto slot
  • judi bola
  • toto slot
  • slot thailand
  • slot gacor
  • situs toto
  • sohib4d
  • pohon169
  • biganslot
  • tasenslot
  • slot gacor
  • jogjatoto
  • Copyright © All rights reserved Theme: Infinity Blog by Themeinwp