Lookup Fields: huge no. of entries, filter and detail view

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
JEngels
Posts: 17
Joined: 2014-03-10 14:16
Location: Germany

Lookup Fields: huge no. of entries, filter and detail view

Post by JEngels » 2014-09-16 10:15

Some lookups have a endless growing no. of entries (e.g. "orders"), so that it becomes more and more difficult to find and select an entry.
A partly solution: Lookup fields can be filtered and reordered by "Advanced..." - SQL-Code, e.g. "orders" filtered by a status <> "delivered".
The problem: in detail view of "old" entries the status of all delivered orders isn't be shown, because the status allows the order not beeing selected in the dropdown-list.
In table view it's okay, means: the entry in order table is correct. It's just a problem of displaying it.
How to solve that?
Is there a way to change a lookup field / dropdown list to beeing displayed as a text field when filter conditions have changed (e.g. when order status = "delivered")?
Or maybe a way to display an "old" not selectable "free" entry within a lookup?

Thanks in advance!
Koepi

udayvatturi
AppGini Super Hero
AppGini Super Hero
Posts: 85
Joined: 2014-06-14 03:08
Location: India
Contact:

Re: Lookup Fields: huge no. of entries, filter and detail vi

Post by udayvatturi » 2014-09-22 13:33

Hello,
Can you please provide some screenshots of the issue. I am trying to help but i couldn't able to pinpoint your issue.

JEngels
Posts: 17
Joined: 2014-03-10 14:16
Location: Germany

Re: Lookup Fields: huge no. of entries, filter and detail vi

Post by JEngels » 2014-09-29 16:49

Hi Uday,
thanks for thinking about the issue.
Here some more details.

Let's say we've a growing number of orders .
These orders can be checked as "archieved" when they became "old", because of not want to have an endless list of order entries you've actual to deal with.
lookup01.png
lookup01.png (62.83 KiB) Viewed 4597 times
Now you can create tasks (Aufgaben) depending on an order.
In that table there's a lookup to choose the corresponding order.
These lookup is filtered by archieve fields which are not checked:
lookup03.png
lookup03.png (70.05 KiB) Viewed 4597 times
Now we check the field "archiviert" in the first screenshot above.
In the table view of the tasks the "old" order is displayed fine.
lookup02.png
lookup02.png (55.56 KiB) Viewed 4597 times
BUT not in the dv!
Because the order isn't in the lookup list anymore it isn't displayed.
Instead lookup is emty.
lookup04.png
lookup04.png (53.94 KiB) Viewed 4597 times
How to solve that?
Lookups should accept every value, not only that in the lookup list?

Thanks in advance!
Koepi

dwmilli
Posts: 2
Joined: 2015-01-10 03:46

Re: Lookup Fields: huge no. of entries, filter and detail vi

Post by dwmilli » 2015-02-24 17:51

Very similar or same problem here....used advanced lookup and updated column with data, the data shows in the record list at the top with the updated lookup info, but when I click on the record and look at the detail view below the lookup column is now empty (lost previous updated info). IF someone were to update another column in this record, the previous lookup data would be lost unless they noticed it wasn't being carried forward. For the previous lookup to remain, they would have to re-update the column using the pull-down again.

Advanced lookup fields updated by using pull-down once updated and saved should not have to be re-done upon selecting the record again. the detail view should still show the updated data just like it shows at the top in the record list.

marcelo
Posts: 10
Joined: 2020-07-29 15:26

Re: Lookup Fields: huge no. of entries, filter and detail view

Post by marcelo » 2022-06-07 15:00

Hello friends, how are you?

This question raised is what has been bothering me. I create many views by sql and that are not shown in the lookup fields. Does anybody know how to solve this?

Post Reply