Hi all,
I'm trying to filter some city data by city name
The following line will not match because it's not case-insensitive :
esqFilter = esq.CreateFilterWithParameters(FilterComparisonType.Equal, "City", "PARIS");
Is there a way to ignore case so it works for the "Paris" value ?
Like
1 comments
18:35 Aug 03, 2020
Dear Jerome,
ESQ EQUAL comparison is not case sensitive so you are not getting a result either because you have other filters or there are no records with City column equals to Paris.
As an alternative you can try using Select class:
https://academy.creatio.com/documents/technic-sdk/7-16/retrieving-data-database
Best regards,
Dennis
Show all comments