Quick Find for Lookup Columns that are Virtual Entities Not Producing Correct SQL

[mikefactorial]

This is a known issue ATM. If you have a lookup to a SQL Virtual Entity you won't be able to add that column as a Quick Find Searchable Column

[rubens-pereira]

Dear Mike, congratulations for the Sql Virtual Entity DataProvider.
I've installed it and came around a problem concerning a lookup field based on a Virtual Entity. It is giving only 25 of the total records ( I guess 25 is the page size which is specified on the form). The pagination also not working. So not at all able to see records other than first 'n' number of records .

Could you help to solve this problem?

BR,

Rubens Pereira

[mikefactorial]

Hi Rubens,
You are correct about the behavior of subgrids when using Virtual Entities. It will only show the number of records specified in the row count of the subgrid. I'll look into the paging issue and get back to you.

[rubens-pereira]

Hi Mike.
Thx for you reply.
I've attached two screens to help you understand the behaviour.
First screen - the SIGTAP VE - the virtual entity - data with the load more option showed
Second screen - A model-driven form with one lookup field based on SIGTAP VE and the 25 records only.

Please let me know if you need additional information about this topic.

[rubens-pereira]

Hi Mike! Happy New Year.
Did you look into the paging issue?