I have been working on AngularJS application. We have complex pages that require us to use multiple tables in a single query. After retrieving required information, in order to use it in controller, ...

public function scopePopularUsers($query) { return $query->join('popular_users', 'popular_users.user_id', '=', 'users.id') ->where('popular_users.popularity', '>', 20 ...

Quite often, in Power Query, you want to ‘nest’ calculations and transformations – apply them not across the whole table, but repeat the same calculation or transformation across multiple groups of ...

A year ago support for nested data types in Excel was announced on the Excel blog, but the announcement didn’t have much detail about what nested data types are and the docs are quite vague too. I was ...

Your browser does not support the audio element.

After a bit of a delay, here is the latest Microsoft Dynamics NAV design pattern, brought to you by the NAV Design Patterns team. This pattern shows how the new query object type introduced in ...