I have a dynamic list of strings that I want to compare with a value of a column in main_table. I want to make sure all the parts from this list match my column.
let name_parts_table = print names = dynamic(["a.b", "a"])
| mvexpand name
| project parts = split(name, "."), Placeholder = 1;
main_table
| extend Placeholder = 1
| join kind=inner name_parts_table on Placeholder
| where components has_all (parts)
Error:
has_all(): failed to cast argument 2 to scalar constant
I checked the documentation of has_all which also accepts a dynamic list of values for comparision.