Latest Contributions by PhilLarkin1

Have you tested if 2.4 resolves this problem? ... View more

If you have other layers in the app, does the same issue occur? I'm curious if the schema of the layer you are concerned about has been changed recently. d.tagname looks like it might be missing.  ... View more

Do you have an update to share on this project? ... View more

Can we get an update on this? ... View more

I've circled back to this problem to find there isn't much of an improvement in how AGOL displays ISO metadata. Attribute information is still obscured if your style is set to anything other than FGDC.   ... View more

Hi, thanks for your reply.  Looks like my problem is the oid_fields parameter should be set in this case.  ... View more

I don't think there is a parallel in MSSQL. Results are passed to clients without generating a schema in the database. I couldn't pass a query and find some log parameter that would show a schema name for my connection. ... View more

The fully qualified name is the name given in the database. This would include the schema owner rather than the connected user schema. Given the scenario I've discussed at length this is what I would expect: baseName: If I've aliased a table in the FROM clause it should return the alias, if I haven't and there is one table in the FROM clause it should return the full name [Database].[OwnerSchema].[Object], and if for some stupid reason im selecting a cartesian product there should be well documented logic to what name is going to be returned. Regardless, the name should include the owner schema.  name: Returns the name I've given the Query Layer in the out_layer_name parameter. I'd submit an Idea if I thought it would get enough votes to make a difference. At this point I'm assuming it won't get traction.  ... View more

I was expecting that arcpy.Describe would return the fully qualified name of the Query Layer. This would show the true schema owner, as opposed to the user that is connected. In the several examples i've shown my desired return from Describe().baseName: ASSRSDE.dboExample.Vertical_Units what I get is: assrsde.userA.vertical_units <- User connected (Input_database parameter) At the very least, if I am aliasing a table in the FROM clause it would be nice if that was honored as the baseName.  ... View more

HI Joshua - The connection is SQL Server with Database Authentication. ... View more

I can't even alias my way out of this problem (example 1). Describe still returns the connected user as the schema owner. It even seems arbitrary which table name is returned (example 2). 1) input = "...\\userA_Staging_ASSRSDE.sde" query = """SELECT pid_num as parcel FROM ASSRSDE. dboExample .vertical_units "ASSRSDE. dboExample .vertical_units" """ parcel = arcpy.MakeQueryLayer_management(input_database=input,out_layer_name="memory\\VU",query=query) print( arcpy.Describe(parcel).baseName) # returns: 'ASSRSDE. userA .%vertical_units' 2)  input = "...\\userA_Staging_ASSRSDE.sde" query = "SELECT ta.pid_num as parcel FROM ASSRSDE. dboExample .tableA ta, ASSRSDE. dboExample .vertical_units" parcel = arcpy.MakeQueryLayer_management(input_database=input,out_layer_name="memory\\VU",query=query) print( arcpy.Describe(parcel).baseName) # returns: 'ASSRSDE. userA .%vertical_unis' ... View more

Thanks for your reply. That makes some sense.  I guess I'll need to alias the table. Connecting as the schema owner just to get the correct name from a simple query is overkill.  ... View more