Forums

How can I use only certain fields in the Database Read Action?

New Field = id | Field Alias = idddd
New Field = stamp | Field Alias = stampppp

It's ok, but on debug page:

SELECT `data`.`id` AS `data.iddd`, `data`.`stamp` AS `data.stamppp`,..., `data`.`name` AS `data.name`,...

name is not set on query fields

ok, why do you need to choose fields ? let it read all fields, that is the default behavior

I have tables with 30 fields. Some of them text with 2500 - 5000 characters. In lists I only need 5 fields, in the detail pages about 20. Some fields should not be used in the list or in the detail page.

Being able to SELECT specific columns is better than only able to SELECT all.

https://weblogs.asp.net/jongalloway/the-real-reason-select-queries-are-bad-index-coverage