Tag: Back-end
9 May 2022Revisited: Sitecore path in SQL Query
A little over 2 years ago, when we all thought the pandemic might just be a 2-3 month ordeal, I wrote the first article of this blog about how to get Sitecore item paths when directly querying the (master) database. A lot has happened since then, let’s talk about it.
tags: Sitecore - T-sql - Back-end
15 December 2021
Group by folder in Sitecore Forms
Recently I was made aware of Mohammad Abujaffal’s excellent article on how to View Sitecore Forms in Groups or Categories in Forms Dashboard and while implementing it I found some optimizations.
15 August 2021
Sorting Sitecore Forms exports
If you’ve ever exported form submissions as CSV file from Sitecore 9+ Forms, you might’ve noticed the order in which the columns are exported seems completely random. We can fix this by implementing our own IExportDataProvider.
tags: C# - Back-end - Sitecore
27 July 2021
Deconstruct ALL THE THINGS!
Quickly getting the matches and captured groups from a regex with a more eligant syntax? Deconstruct them!
28 December 2020
Admin-panel to whitelist IP's for identity server
One of our clients wanted to be sure that only white-listed IP’s can log into Sitecore to manage their site. We solved this by utilizing IIS’s IP Address and Domain Restrictions feature on the Sitecore Identity Server. That way adding or removing an IP only restarts the app-pool for the Identity Server, not the Sitecore instance. Annoyingly this has meant that every so often I have to log into the production server just to add an IP address to IIS, until I made this admin-page that let’s anyone with the developer role in Sitecore do this without all the hassle.
tags: Sitecore - C# - Back-end
2 April 2020
A better way to do dynamic OrderBy() in C#
A common feature in various applications is to sort some collection by one of it’s properties, dependent on some input like the column clicked by the user. An implementation might take a string or enum for the column plus a bool or enum for ascending vs. descending.
22 March 2020
Sitecore path in SQL Query
When trouble-shooting Sitecore issues, sometimes you wanna dive directly into the SQL Database and query around in dbo.Items. But you might want to query an item’s Sitecore-path, like in the where clause. This recursive common table expression makes that very easy:
tags: Sitecore - T-sql - Back-end