Filter text box relationship with Grid control

The filter text box is used to filter values for controls, such as a Grid.

To associate a filter text box on a form to a control, such as a Grid, select CustomFilterGroup -> QuickFilter. Then go to the Properties window and in Target Control, select Grid




Bind data source to Grid for a custom form

On your custom form, right click on Data Sources -> New Data Source


Be sure to give your Data source a Table name in the Datasource properties

Then go to the grid in Design Patterns window, and select Grid. Go to the properties window and select the Datasource you just created


Data Entity Categories

There are five distinct categories of data entities.

Entities are categorized based on their functions and the type of data that they serve.

In Visual Studio, right click on the Unified Operations X++ project –> Add –> New item…


Locate and select Data Entity. You will enter the Data Entity Wizard



Categories entities that will contain data to be used in the operation of the business. Such as purchase orders, journals.


Categorises entities that will contain complex reference data such as customers, vendors and projects.


Categories entities that are used to container only one record, where these values are used for settings such as for workflows. This category is for entities that are used for function and behavioural parameters


Categories entities that are used to contain data specific to an industry or business process. It can contain reference data of small quantity, that is required to operate a business process such as dimensions and units.


Categories entities that are used to contain the operational transaction data of the business such as pending invoices.

What is a Data Entity in Dynamics 365 for Finance and Operations?

Simply put, a big table with all columns from all relational tables.

data entity is an abstraction from the physical implementation of database tables.

Table1 and Table2 are physical database tables


Data entity provides conceptual abstraction and encapsulation (de-normalized view) of underlying table schemas to represent key data concepts and functionalities

Data Entity, shown as in above diagram, is a collection of the columns from both tables, forming one unified de-normalized table (view)


Cannot Connect to Database Master at SQL Server at “” . The Database might not exist, or the current user does not have permission to connect to it

Finally, I have started working with SharePoint 2016… in 2017 😉

So as always, I like to setup my development environment. Instead of using VMWare workstation, I decided to try out Hyper-V on Windows 10. And guess what? I love it.

I always begin the very first install of SharePoint manually, piece by piece before I start using the AutoSPInstaller scripts. I like to know whats’ what in the box before I begin using automation for the process. It adds to my understanding and knowledge of how pieces fit together. That’s just me.

Anyways, so I created a Win Server 2012 Hyper-V VM, installed the Active Directory services feature, added service accounts for the install, installed sql, installed SharePoint 2016 binaries. This link is what you should follow when setting up SharePoint 2016


And THEN! I ran the Configuration Wizard. On step 3, creating the configuration database… the error “Cannot Connect to Database Master at SQL Server at ‘xxx’ . The Database might not exist, or the current user does not have permission to connect to it” .

So I begin the quest to find whats wrong. I came across blogs that told me to checked TCP/IP, named pipes, sql server access and the list goes on but nothing matched up with solving the issue.

I came across a blog that mentioned about adding the IP address of your active directory server to your host file. And it WORKED!

On my VM, my Domain is called SP.Com. I added a entry in there to the machine I was building my development environment on.


So in my case, this was the fix.


Hope that helps. Also wish to give credit to the blog that gave me this hint but I forgot which one it was. It was a late night. Sorry





LINQ to SELECT from lists collection

A neat bit of code to write out all lists at the Root Web level that are hidden!

using(SPSite site = new SPSite(http://phillau)


SPWeb web = site.RootWeb

var lists = from list in web.Lists.OfType<SPList>()

where list.Hidden == true

select list;

foreach(var list in lists)






SharePoint Authentication methods overview

Window Authentication

– authentication managed by Windows Server and IIS

Forms Based Authentication

– authentication managed by ASP.NET and an authentication provider

Claims Authentication

– authentication managed by a security token service (STS


SharePoint creates a profile for each user a the site collection level

– User information list used to track identities

–  Identity seen by developers as SPUser


User information list is automatically created at the top level site.

– Tracks security principals using an integer ID


SharePoint may rely on external source for authentication but it controls all authorisation to its resources and entities.