Can I create an INACTIVE record?
If you need to create an inactive record in a system, unfortunately you cannot do so in one shot. It requires two database transactions: one to create an active record and another to deactivate it. This is due to the fact that the StateCode attribute metadata shows the isValidforCreate as No, so it cannot be set in the create transaction. Additionally, if you attempt to set the StatusCode only, you will receive an error message because statecode=0 is set as default by the system, which invalidates the pair if you pass statuscode=2 in the create payload.
This blog post offers a solution to this issue.
It is important to note that this post originated from a Stack Overflow question.
Published on:
Learn more
Related posts
Upgrade for the latest Microsoft Fluent Design System visual styling on Microsoft SharePoint
Microsoft SharePoint is getting an upgrade to the latest Fluent visual styling system. This may result in minor changes such as differences in...
Working with System & Public Views in Dataverse
If you're new to Dataverse and Dynamics 365 CRM, this article provides a comprehensive overview of the different types of views available in t...
Update to the Minimum iOS System Requirements for Outlook for iOS
If you're an Outlook for iOS user, it's essential to know that the app is only supported on the two most recent versions of iOS. When a new ve...
Announcing Public preview – System preferred multi-factor authentication method
Microsoft has come up with a new solution to the challenge of users selecting different authentication methods for varying levels of security....
Eduardo Maltez: Full-system testing using Selenium - Episode 224
In this episode, Eduardo Maltez, a Software Engineer at Clear Measure, discusses full-system testing using Selenium. With extensive experience...
What is it that I can edit but can’t see as a system administrator?
Have you ever wondered what you can edit as a system administrator in a particular environment but can't see? It turns out that there's an ans...
Azure SQL Database: Non-blocking transactions | Azure Friday
This video highlights the importance of efficient management of concurrent access to a resource in Azure SQL database, especially when multipl...
Power Apps Ticketing System With Sentiment Analysis
In this video tutorial, you'll learn how to build a ticketing system using Power Apps and Microsoft Cognitive Services. The system is equipped...
Time of Flight Camera – System Overview
The Azure Depth Platform program has recently featured guest blog authors Paul O’Sullivan and Nicolas Le Dortz introducing the Analog Devices ...