topic Edit Widget - True/False attributes from none-SDE SQL database in ArcGIS Web AppBuilder Questions

Edit Widget - True/False attributes from none-SDE SQL database

GertConradie — Thu, 05 Jan 2017 15:53:06 GMT

Hi,

When publishing a Feature Service that enable editing of True/False (bit) attributes on SQL Server records in a SDE database, one can configure Coded Value Domain that can be used as a dropdown for selection (i.e. yes/no, instead of a checkbox).

What to do if I have a none-SDE SQL database? (Text boxes for numbers is being displayed by default for the bit type, that is converted to a Short Integer by the ArcGIS Service/MXD)

I'm at a point where I'm considering creating a custom version of the Edit Widget that I can configure, but hopefully there is a different option.

Using WAB Developer edition.

Any ideas will be much appreciated!

Re: Edit Widget - True/False attributes from none-SDE SQL database

RobertScheitlin__GISP — Thu, 05 Jan 2017 15:59:38 GMT

Gert,

Hmm. if you are using a FeatureServer service then isn't a versioned geodatabase required?

Re: Edit Widget - True/False attributes from none-SDE SQL database

GertConradie — Fri, 06 Jan 2017 14:06:12 GMT

Hi Robert

No, I'm pretty sure it is not required - in fact we use it to update entities in a none SDE database already. It don't think there is a license problem as well, because one of the ESRI workflows is:

"You want to publish a feature service to ArcGIS Server using data from a single on-premises database or enterprise geodatabase."

Re: Edit Widget - True/False attributes from none-SDE SQL database

GertConradie — Fri, 06 Jan 2017 14:12:10 GMT

What I can add based on past experience - when using SQL server and you have a strict relationships for lookup tables, then the identity insert must be (0,1) on the lookup tables, not the default (1,1). This is a pain to manage - especially if your lookup is also transactional records that can be deleted (The very first transaction record with ID 0 can then be deleted, then your feature service inserts start to fail) In a previous project we only 'read' the feature service and then saved back via a custom WebAPI service, not the default 'ApplyEdits' on the feature service. (using custom widgets, not the default edit widget)

Re: Edit Widget - True/False attributes from none-SDE SQL database

RobertScheitlin__GISP — Fri, 06 Jan 2017 14:44:04 GMT

Gert,

I primarily use geodatabases so I don't know what to tell you.