Forum


List Manager Support

List Manager support
Forums
Public write access is disabled. Please login

List option in LM4.1.14 28.03.2022 20:36

Hi MSTeam,
I applied SQL query in the multiple values for Fields/Columns as bellow
SELECT filed_id FROM `table_name ` WHERE 1
when add new record or edit inline in front page , the list open and can show a selected menu but nothing to show there its just blank menu
I tested the query in Sql server its working fine and can show the data already stored in that filed.
is there anyway to fix this please ?

I also wonder if I can have an entire build in search/orderable in the option list can, it can show on top when click to choose value from the option list.
I think this is really needed especially if the list value to choose is long, it will help the user to select the value quickly


Regards


Ali

Re: List option in LM4.1.14 29.03.2022 10:19

Hi,
please note you will need to select 2 fields from your table in order to recover both the 'value' and the 'text' for the combobox option. If you want to show and store the same value, you can use the same field from your source table, this way:

select column as id, column as value from table_name

If you only select one column, the options will be filled, with different option values, but with an 'empty' text for each one, maybe this is the result you're getting at your field.

Regarding filter, you can freely create any number of filters for your list, with different types to choose from. You need to create the filter at Display->filters configuration, adding your field, and selecting the filter type 'select'. Then you can add your filter to the main list display in order to publish it at the front end.

Hope this helps, regards
Moonsoft Team
www.moonsoft.es

Re: List option in LM4.1.14 29.03.2022 10:40

An yet another option to search text within your fields, you can mark your field as 'broad' search (instead of 'exact'). That way users don't need to type the entire text at the search field in order to find results.

Regards
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback