Business data connectivity model issue . Variable substitution in PostgresSQL does not work
I have a business data connectivity model for oracle which is working fine. We are changing oracle to Postgres SQL and would like to make necessary changes in the model . One of the issue I am facing is how to pass the variable into the SQL statement. For eg. the current model has <Method Name="Getcountry"> <Properties> <Property Name="RdbCommandText" Type="System.String">select * from country where country name like :countryname</Property>...</Method> <Parameters> <Parameter Direction="In" Name=":countryname"> <TypeDescriptor TypeName="System.String" IdentifierName="countryname" AssociatedFilter="countryname" Name="countryname"> <DefaultValues> <DefaultValue MethodInstanceName="Getcountry" Type="System.String">%</DefaultValue> </DefaultValues> </TypeDescriptor> </Parameter> This works in Oracle but Does not work in PostgresSQL . What I am trying is to do is to pass the value from a UI to the model . The model is deployed in Sharepoint 2016 onprem