#Web form builder sql server how to
#Web form builder sql server code

The activity for this shows you how to configure those connection strings. In this example: an initial catalog to production, integrated security is false, this is my User ID and also a password. But here you can see that this requires a data source. I added a connection string and you can see that I greyed out some of these items because some of this is sensitive information. This requires a provider name, so here I entered in ‘Microsoft SQL Server’. I can zoom in a little bit here to show you what that looks like.Įssentially, the workflow then kicks off the server workflow and what this does is it gets the workflow inputs and then, I’m using the ‘Run SQL Query’ activity. I’m passing in the name (this could be anything you want), and I’m passing in the ‘textBox1’ value. This is the URL of my server workflow, which is this workflow here on the right. I added some graphics to the map to select that hydrant, and then this is where I run a server-side workflow to then query that SQL database. You can see that this says ‘textBox1’ and it’s ‘form 1’. I have an initial form here asking the user to enter their facility ID. If I navigate to the info tab, you can see this is a client workflow, so that means that I can add it to Web AppBuilder and I can essential display forms and present information to my end users. You can see I’ve installed the on-premise version of Geocortex Workflow designer. This data here is being pulled from a SQL server and being populated in this form. This inspection information is actually being pulled dynamically from the SQL server, but we also do have an ArcGIS relationship, so if you do want to quickly confirm that we are pulling those three inspections, here they are. If I click submit, then it’s going to pan to that hydrant and now we are actually displaying related inspections. It’s an extremely simple workflow: all it’s asking you to do is to enter the facility ID of one of my hydrants. Here I added a client-side workflow as a widget to my Web AppBuilder instance. Here I am in Web AppBuilder and I’ll just show you the workflow right off the bat, and then we’ll dive in and see how it’s all put together. In this tech tip video, I am going to show you how you can display data from SQL databases when you select features on the map, using Geocortex Workflow. I work on our Technical Marketing team, and in this tech tip video I’m going to show you how you can display SQL server data inside of Geocortex Workflow. “Hi everyone, my name is Patrick Fingler. This streamlined process allows you to get a complete picture of your assets, enabling better informed decisions. In this week’s tech tip video, we show you how can pull data from a SQL server to display in Geocortex Workflow without replicating the data. A key component of this is providing a way to efficiently connect spatial data in a GIS application with non-spatial data stored externally. Return _logEntryServiceSettings.Geocortex Workflow extends what you can do with your Geocortex and Web AppBuilder for ArcGIS applications. Return _logEntryServiceSettings.InfoLogEntryType Return _logEntryServiceSettings.FatalLogEntryType Return _logEntryServiceSettings.ErrorLogEntryType Return _logEntryServiceSettings.DebugLogEntryType Protected virtual string GetNewLine(IEnvironmentService environmentService) _logEntryServiceSettings = logEntryServiceSettings _newLine = GetNewLine(environmentService) Public LogEntryService(IEnvironmentService environmentService, LogEntryServiceSettings logEntryServiceSettings) Private readonly LogEntryServiceSettings _logEntryServiceSettings Public class LogEntryService : ILogEntryService String GenerateLogMessage(LogEntry entry) I created the following interface for service classes that return back strings for the different LogEntry types, and also generate a log message from the data on properties on the LogEntry instance - this is the message that will end up in the database for the LogEntry: Okay, so need we need to know what “type” of LogEntry we are dealing with - is it an error or a warning or what? - before sending to a repository to save in the database. I created the following POCO class to serve that purpose: We first need a class that represents a log entry. Well, I certainly could have but what fun would that have been? You might be asking “Mike, you know you can just use a SQL appender in log4net, right?”

#Web form builder sql server code

Well, that’s what I did, and the code in this post captures how I went about doing that. I immediately thought “I just wrote code for retrieving Forms configuration settings from a SQL Server database table, why not create a new ILogger service class for storing log entries in a custom SQL table?”

One thing that popped out when continuing on this quest was. Not long after I wrote the code for my last post, I continued exploring ways of changing service classes in Sitecore Experience Forms.