About VALUEIN() in ER for filtering lists

#er

Dynamics 365 ERP - Development

VALUEIN() formula returns a boolean indicating if a certain value is in a list.
FILTER() can be used to filter records efficiently by transforming the formula into a SQL query.
Using FILTER() with a lot of ORs may create a SQL statement longer than the max length allowed.
VALUEINLARGE() only accepts INT and INT64 fields for large value checks.
An EXIST JOIN or similar SQL statement will be created if the second parameter of VALUEIN() is a non-filtered list.
If the second parameter of VALUEIN() is a filtered list with 0 records, it will return all records of the table being filtered.
Alternatives to using VALUEIN() include creating a boolean field in the table or filtering the final table inside the first.
Efficiency implications must be considered when choosing between the alternatives, based on the size evolution of the tables.

Registered users can view the full text for FREE!