Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JacobLozano
JacobLozano
Emerging Contributor
since
08-20-2014
06-02-2021
4
Posts created
8
Kudos given
0
Solutions
1
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by JacobLozano
|
POST
|
The queries in my original question are actually correct and were returning the correct results as the MAINT_ACTIVITY field in the base table was actually all NULL records. Since the table was registered as versioned, the records I wanted to query were in the Views folder of SSMS. So the following query returned the results that I have been looking for via a spatial view: SELECT h.OBJECTID, h.FACILITYID, h.SHAPE, r.Hydrant_ID, r.MAINT_ACTIVITY, r.MaintDate, r.GlobalID FROM wHydrant h JOIN wHydrant_Maint_evw r ON h.FACILITYID = r.Hydrant_ID WHERE (r.MaintDate >= '2014' AND r.MaintDate <= '2015') AND r.MAINT_ACTIVITY = 'Flushed' Thank you George & Asrujit for guiding me to the base & view tables in SSMS.
... View more
04-09-2019
08:16 AM
|
1
|
0
|
1540
|
|
POST
|
The data is registered as versioned. When I view the System View table in SQL I can now see my entries, whereas all entries are NULL when I view the base table. I will test querying this table and report back my results.
... View more
04-09-2019
07:55 AM
|
0
|
0
|
1540
|
|
POST
|
The code value and the description are the same for this domain. We did not use numeric codes in this instance. However, I went into SSMS to view the wHydrant_Maint table records and all of the MAINT_ACTIVITY records are NULL. Yet when the table is viewed in Arc I see all the entries. So if SQL doesn't see the entries, how am I supposed to query them in SQL? Also, I noticed that all the fields with domains are NULL when viewed in SSMS, BUT there is also a "NOTES" field, a text field with no domain, that is also all NULL in SQL.
... View more
04-09-2019
07:46 AM
|
0
|
0
|
1540
|
|
POST
|
I'm attempting to create a spatial view between a feature class (wHydrant) and a related table (wHydrant_Maint). I can successfully create views by querying every field in the Hydrant_Maint table, except one (Maint_Activity). The only difference from the other fields is that this Maint_Activity field has a domain. Any attempt to create a view with a WHERE clause on this field will return an empty view with no records returned. When querying other fields, but including this field in the selection, all the results in this field return as null, even though there are in fact entries. Here is my SQL statement that returns all NULL records in the Maint_Activity field: SELECT h.OBJECTID, h.FACILITYID, h.SHAPE, r.Hydrant_ID, r.MAINT_ACTIVITY, r.MaintDate, r.GlobalID FROM wHydrant h JOIN wHydrant_Maint r ON h.FACILITYID = r.Hydrant_ID WHERE r.MaintDate >= '2014' AND r.MaintDate <= '2015' The following returns an empty table view: SELECT h.OBJECTID, h.FACILITYID, h.SHAPE, r.Hydrant_ID, r.MAINT_ACTIVITY, r.MaintDate, r.GlobalID FROM wHydrant h JOIN wHydrant_Maint r ON h.FACILITYID = r.Hydrant_ID WHERE r.MAINT_ACTIVITY = 'Flushed' Do I need to adjust my syntax to account for a domained field? Also, the code and description for the domain match, in case you're thinking I should query the code for 'Flushed'.
... View more
04-08-2019
11:32 AM
|
0
|
5
|
1790
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 04-09-2019 08:16 AM |
Activity Feed
- Got a Kudo for Re: Why is a spatial view returning empty or null records when field has a domain?. 11-11-2020 02:06 AM
- Kudoed Add Multiple Related Records for SteveLane. 04-10-2019 09:57 AM
- Kudoed Add Multiple Related Records for SteveLane. 04-10-2019 08:50 AM
- Kudoed Use Batch Attribute Editor with related tables for AhnaMiller2. 04-10-2019 08:48 AM
- Kudoed Collector on AGOL: Disable editing for geometry but retain addition of related records for DarraghO_Keeffe. 04-10-2019 08:47 AM
- Kudoed Create new related records WITHOUT giving the option to create new features in Collector for ShelbySouthworth. 04-10-2019 08:47 AM
- Posted Re: Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-09-2019 08:16 AM
- Posted Re: Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-09-2019 07:55 AM
- Posted Re: Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-09-2019 07:46 AM
- Posted Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-08-2019 11:32 AM
- Tagged Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-08-2019 11:32 AM
- Tagged Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-08-2019 11:32 AM
- Tagged Why is a spatial view returning empty or null records when field has a domain? on Geodatabase Questions. 04-08-2019 11:32 AM
- Kudoed Symbolize on related table values for SteveDuquette. 04-04-2019 07:08 AM
- Kudoed Allow editing related tables in Collector while the feature service is set to "update attributes only" for simoxu. 04-04-2019 07:07 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
06-02-2021
03:39 PM
|