راهول
I have a table like this in mysql. Need to retrieve englishName by passing arabicName through query entity. While passing the arabicName through rule input in query filter the expression is returning no matching data found. I have also tried Query Database smart service through process model but was of no success.
NB: For knowledge ,collation and charset for my table and column is set to charset= utf-8 and collation= utf-8_general_ci.
If anyone have faced the same issue and know how to solve this problem will be a great help.
Thanks.
Discussion posts and replies are publicly visible
Anupam -
I don't have a working knowledge of Arabic, but I'm intrigued. If you're willing - can you provide 2 things:
1) maybe 10 more example rows showing English and Arabic names and 2) Share the syntax for your query
Hi Robert, below is my table structure and query entity to retrieve the English name. But while executing it is returning no matching data found.
a!queryEntity( entity: cons!ARABIC_ENGLISH_LOOKUP, query: a!query( logicalexpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "arabicName", operator: "=", value: "يوحنا" ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true)
This worked fine for me in a an Appian cloud DB
Are you using the Appian cloud DB or a different mySQL instance?
Hi Robert,
I am working on appian on premise and mySQL db is in different server. I am guessing this is server connection collation related issue but not getting the clear idea on how to resolve this.