POST
|
Thank you for that tip. I have decided to create an UPDATE query in pgAdmin instead of creating a query table.
... View more
06-14-2021
07:08 AM
|
0
|
0
|
1352
|
POST
|
Is there a way to assign which tab is selected when "Show Related Records" is chosen? I have two related tables, but the one that opens up by default isn't the one I want to open by default. I have attached a screenshot of what I am describing:
... View more
06-14-2021
07:07 AM
|
0
|
0
|
412
|
POST
|
I got it to work. This is what I did in pgAdmin: CREATE OR REPLACE VIEW v_flare_ends_global AS SELECT DISTINCT tbl_flare_ends.globalid, tbl_media_2.media_table, tbl_media_2.media_name, tbl_media_2.media_date_added, tbl_media_2.media_path, tbl_media_2.media_table_id FROM tbl_flare_ends JOIN tbl_media_2 ON tbl_flare_ends.originaloid = tbl_media_2.media_table_id_integer WHERE tbl_media_2.media_table::text = 'tbl_flare_ends'::text; ALTER TABLE v_flare_ends_global OWNER TO sde; GRANT ALL ON TABLE v_flare_ends_global TO sde;
... View more
06-10-2021
03:33 PM
|
0
|
2
|
1377
|
POST
|
Vince, I am guessing a query table might be the best solution? Something like this? SELECT sde.sde.tbl_flare_ends.globalid FROM sde.sde.tbl_flare_ends INNER JOIN sde.sde.tbl_media2 ON sde.sde.tbl_flare_ends.originaloid = sde.sde.tbl_media2.media_table_id_integer WHERE media_table = 'tbl_flare_ends'
... View more
06-10-2021
02:40 PM
|
0
|
0
|
1377
|
POST
|
Vince, Yes, I apologize. I should have stated I want to obtain Globalid's and copy them to another table as GUID's. Both are in a single Enterprise geodatabase. The table I am looking to populate the GUID field with the globalid's has 55,000 rows... I have tried creating a query table, but that failed. I have also tried utilizing joins, but when joining the GlobalID field doesn"t come along...
... View more
06-10-2021
01:39 PM
|
0
|
0
|
1379
|
POST
|
In our old mapping system, all images and attachments were saved to a folder on our web server. The table was populated with the url. Would I be able to accomplish this workflow with Integromat and Survey123?
... View more
06-10-2021
09:38 AM
|
1
|
2
|
627
|
POST
|
I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?
... View more
06-09-2021
09:11 AM
|
0
|
1
|
895
|
POST
|
I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?
... View more
06-09-2021
09:05 AM
|
0
|
6
|
1404
|
POST
|
Thanks Dan. When joining, it does not bring the globalid field with, so I am not able to calculate a new field with those values...
... View more
06-09-2021
07:12 AM
|
0
|
0
|
783
|
POST
|
Dan, Even if the stand-alone table / related table has multiple entries with the same objectid?
... View more
06-08-2021
03:52 PM
|
0
|
2
|
816
|
POST
|
I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table. Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?
... View more
06-08-2021
03:01 PM
|
0
|
4
|
861
|
IDEA
|
Why not just use Collector to move the current point, then click on a link you create to open the survey and then capture that data?
... View more
05-13-2021
01:44 PM
|
0
|
0
|
726
|
POST
|
@ZacharySutherby , It doesn't, but that is because I am dealing with a related table, and its ID is 1. In the form_id column, I have the related table name.
... View more
05-11-2021
02:20 PM
|
0
|
2
|
2604
|
POST
|
I am having the same issue. I get: "The custom feature service submission url is not compatible with this survey (Parent layer id 0 not found for table 'table_name')"
... View more
05-11-2021
08:12 AM
|
0
|
4
|
2610
|
Title | Kudos | Posted |
---|---|---|
1 | 07-29-2021 04:33 PM | |
1 | 03-31-2021 02:14 PM | |
2 | 12-08-2021 09:45 AM | |
1 | 07-30-2021 09:32 AM | |
1 | 04-23-2021 08:10 AM |
Online Status |
Offline
|
Date Last Visited |
07-03-2024
11:58 AM
|