Latest Contributions by MichaelVolz

‎09-17-2012

To All SDE Python Users: Is there a way in python code to determine if an SDE connection is available or not? I would like a scheduled task to check if SDE is available before attempting to extract data from SDE to a file geodatabase.

‎09-14-2012

Use the ListFields method to get a list of fields. Then loop through these fields and add a if-then statement if the field name is equal to any of the 3 fields you want to keep. If not then delete the field.

‎09-13-2012

I have an Oracle based SDE feature class with a relate built from a query layer using SQL Server database tables. I would like to be able to open up a pdf file stored in the Blob field of a related record that I can access from the related results tab of the Enhanced Search Widget, in similar fashion to a hyperlink or opening a file. Is this functionality possible with the latest version of the Enhanced Search Widget?

‎09-11-2012

Robert: Wouldn't the > sign also cause an error as it would make the xml parser think that that is the end of an element and the next element would not have the correct syntax?

‎09-11-2012

Robert: I am still getting the same error message. Also, why does the > sign work but not the < sign?

‎09-11-2012

In the Enhanced Search Widget, I have the following configuration where I am trying to query against a numeric field if the value is less than the user input value. <value prompt="Example: Lower Range Assessed Value (AV) AV < 100000 - Just enter value" isvaluerequired="false">(PROP_ASSESS) < ([value])</value> This is the error message I receive: A problem occurred while parsing the configuration file widgets/eSearch/eSearchWidget_1.xml Error #1095 If I have the following config value: <value prompt="Example: Lower Range Assessed Value (AV) AV > 100000 - Just enter value" isvaluerequired="false">(PROP_ASSESS) > ([value])</value> everything works fine. Any idea what the problem could be?

‎09-06-2012

I could see that ability useful to many people who use coded domains as its the coded domain value that gets passed. Novice end-users would have no idea what the coded domain values are, but they would be familiar with the text value that is associated with the coded domain value. I just joined my feature class to another feature class that has this value and populated a new field with the text value instead of using the field with the coded domain value. Since the data changes on a weekly basis, I will need to create a python script to update this process so new records get this field correctly populated.

‎09-06-2012

Can you manipulate strings in the values area of the expression in the xml file? I want to convert something like 1-Manhattan in the userlist and change the value to just capture the number 1 before the -Manhattan.

‎09-06-2012

I need the relate as I have condos and trailer parks that have 1-many relationships.

‎09-06-2012

You are definitely not out of touch, as I never had the business need to perform this operation in ArcMap, just in a FlexViewer web application. Now that I know it can not be done I will find an alternate method. Thanks for the information, though

‎09-06-2012

So would need to somehow get the field that is in the related record added to the primary feature class. There would be duplication of data, but that would be the only way to accomplish this task.

‎09-06-2012

Here is a query that I would like to perform against a mapservice representing parcels: <expression alias="Parcels - Owner" textsearchlabel="Search Parcels by Owner..."> <values> <value prompt="Example: Smith John" isvaluerequired="true">upper(OWN1) LIKE upper('%[value]%')</value> </values> </expression> The OWN1 field is not part of the feature class, but is found in the related table. I want to be able to perform the query for the OWN1 field with this syntax but I get the following error message: [RPC Fault faultString="Unable to complete operation." faultCode="400" faultDetail="Unable to complete Query operation."]

‎09-06-2012

Can the expression for the query be linked to the related records? It seems like all the samples are linked to the primary feature class or standalone table for each mapservice. If this can be done, what would the proper syntax be?

‎09-06-2012

I was getting mixed up with the indices that should be used. The REST service gave the relate an index of 2 so I put that in for the relate ID and no related records were returned. When I changed the relate ID to 0, I was able to get related records.

‎09-06-2012

I am creating a FlexViewer application using the Enhanced Search Widget and I cannot get the related records to appear in the application or the REST service. How would I get access to these records?

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by MichaelVolz

Determine if SDE Connection is Available

Re: DeleteField_management (delete all except 3 fields)

Accessing a Pdf File Stored in a Blob Field Using the Enhanced Search Widget

Re: Problem with Query Expression in Enhanced Search Widget

Re: Problem with Query Expression in Enhanced Search Widget

Problem with Query Expression in Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Re: Accessing Related Records with the Enhanced Search Widget

Accessing Related Records with the Enhanced Search Widget

Re: Print Widget Timeout

Re: Address Locator - Manually Locates But Won't G...

Re: Count of records in sde views fails

Re: ArcGIS Pro and using Teams for File Storage

Re: Using Append in Python is suddenly requiring a...