has_cs
Indicate whether a string contains a whole term (case-sensitive).
A term is a run of alphanumeric characters, so _, -, and . are delimiters, matching Microsoft Kusto term boundaries. On a dynamic value, body has_cs "x" matches only a string; body.* has_cs "x" searches every string inside an object or array, at any depth, but not its keys.
Syntax
text has_cs lookupNegated form:
text !has_cs lookupFunction call syntax:
has_cs(text, lookup)Parameters
Prop
Type
Given a dynamic field
This parameter is string-only. In permissive mode, which every query runs in, almost every field arrives as a dynamic, so passing one works because Berserk injects asstring: extract-or-null, the value when it really is a string and null otherwise, so the call yields null (a predicate yields false). A property bag or array is therefore not matched, and tostring() is never applied implicitly — use it explicitly to match a bag's JSON text, keys included. To search the strings inside an object or array, write body.* contains "x" (also has, hasprefix and hassuffix). See String coercion and the asXXX family.
Returns: bool
Examples
Example 1
print "Harald Fairhair united Norway" has_cs "Fairhair"| print_0 (bool) |
|---|
| true |