SQLExpression Arcpy Parameter Dependency

JakkapanJiranthorn — Sun, 12 Dec 2021 16:20:49 GMT

Hi guys,

I have a problem on creating an ArcPythonToolbox containing SQL Expression parameter dependency with a TableView parameter (multivalues). I want the SQL Expression parameter able to retrieve the table names and fields of the input TableView like the Make Query Table tool (a built-in ArcToolbox) but it only retrieve the field names.
Expectation format: MyTable.OBJECTID, MyTable2.NAME
Using ArcGISPro

My ArcPythonToolbox

Make Query Table (Expectation)

This is how I bind them.

def getParameterInfo(self):
 """Define parameter definitions"""
 inputData = arcpy.Parameter(
 displayName="Input Data",
 name="in_features",
 datatype="GPTableView",
 direction="Input",
 parameterType="Required",
 multiValue=True)

 sqlExpression = arcpy.Parameter(
 displayName="Expression",
 name="in_expression",
 datatype="GPSQLExpression",
 parameterType="Optional",
 direction="Input")
 sqlExpression.parameterDependencies = [inputData.name]

topic SQLExpression Arcpy Parameter Dependency in Python Questions

SQLExpression Arcpy Parameter Dependency