Page 1 of 1

lookup checkbox is not working

Posted: Sun Jan 14, 2024 9:30 pm
by mpol_ch

Hi,

I am using a lookup check with the following setting (v2024.6.0), which is not working.

Lookup: Select
Link field: Status (Tiny INT)
Display fields #1: Beschreibung (Varchar)

Result is "1" and not "New" ..

mpol_ch


Re: lookup checkbox is not working

Posted: Sun Jan 14, 2024 10:42 pm
by arbei

Avoid using TINYINT(1) with CHECKBOX as lookup, it might be considered as a boolean field. You may use INT instead.


Re: lookup checkbox is not working

Posted: Mon Jan 15, 2024 12:57 am
by mpol_ch

Hi,
I just changed the type from TinyInt into Int(3).
I did the change on both tables.
But the result is the same.

mpol_ch


Re: lookup checkbox is not working

Posted: Mon Jan 15, 2024 9:15 am
by arbei

You may post your table schema of the main table and the lookup table, and the Edit Tag and Lookup Table settings for other uses to reproduce.


Re: lookup checkbox is not working

Posted: Tue Jan 16, 2024 10:19 pm
by Webmaster

Try v2024.7.0. If it does not work, and you are a registered users of v2024, you should send your files and required info to support.


Re: lookup checkbox is not working

Posted: Tue Jan 23, 2024 7:12 pm
by mpol_ch

Hi,
thank you.
It works now with the new release.

mpol_ch