Tag: Sitecore
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
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
12 September 2020
Using jQuery without breaking Sitecore 9 Forms validation
If the front-end code of you Sitecore 9 site is using jQuery, you might have run into some issues on pages with Sitecore Forms. This is because vanilla Sitecore Forms uses an unobtrusive form validation library that’s dependent on jQuery, but might not use the same version of jQuery that you wanna use in your front-end. jQuery has a .noConflict() method to deal with this, but how do you actually properly use it?
tags: Sitecore - Javascript - Front-end
26 May 2020
Introducing nifty Sitecore userscript and filtering MutationObserver events
Like I’m sure many developers, when I use the same tool a lot I start see possibilities for improvement to suite my workflow. So too with the Sitecore client. So to automate everything I find myself doing twice, to the Tampermobile!
tags: Sitecore - Front-end - Javascript
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