Hi,

lets assume, we have the following db table.

people{
first_name text;
...
}

Is it possible to apply the db function during the entity collection fetch? So in that scenario I would like to apply to_upper function on the first_name column. Of course in the real scenario its more complicated situation withe more complicated db_function. I know that I can use the ResultsetFields and project it into the PersonEntity, but i also want to have related prefetch path.

Best Regards, MiloszeS

Hi MiloszeS,

DBFunctionCall, as other expression objects are directly useful in DynamicLists/TypedLists/TypedViews. You cannot use them directly in pure entity fetches, but through projections, as you already pointed out.