public string GetFilter(string fieldName, string fieldValue)
{
fieldValue = new FieldValueEscaper().Escape(fieldValue, false);
fieldName = new FieldNameEscaper().Escape(fieldName, fieldValue);
return fieldName + " LIKE '%" + fieldValue + "'";
}
public string GetFilter(string fieldName, string fieldValue)
{
fieldValue = new FieldValueEscaper().Escape(fieldValue, false);
fieldName = new FieldNameEscaper().Escape(fieldName, fieldValue);
string[] parts = fieldValue.Split(',', ';', '-', '.', ':', '_');
fieldValue = "";
foreach (string part in parts)
{
if (!string.IsNullOrEmpty(part)) fieldValue += "'" + part + "',";
}
fieldValue = fieldValue.TrimEnd(',');
return fieldName + " NOT IN (" + fieldValue + ")";
}
public string GetFilter(string fieldName, string fieldValue)
{
fieldValue = new FieldValueEscaper().Escape(fieldValue);
fieldName = new FieldNameEscaper().Escape(fieldName, fieldValue);
return fieldName + " <> " + fieldValue;
}