Forum
List Manager Support
List Manager supportForums
Public write access is disabled. Please login
Re: List look up? 10.12.2013 09:22
Hi,
the link to the other list is the page url where you have published the second list, like a normal link to other page. You can publish this menu item for a while to get the url on your navigator, and maybe hide the entry afterwards moving it to a hidden menu.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
the link to the other list is the page url where you have published the second list, like a normal link to other page. You can publish this menu item for a while to get the url on your navigator, and maybe hide the entry afterwards moving it to a hidden menu.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
Re: List look up? 10.12.2013 16:11
Hi,
the 'link to other list' type is not intended to recover options from other list to add new data, it creates a html link to navigate to the other list, with a filter applied, it's not what you need to get options available.
In order to create a combobox filled with values comming from other table, you should use the type 'option list', but configuring the options as 'sql actions', where you can write the query used to recover values.
For ex, if you write SELECT id, username FROM #__users
the option list will show all users from your db to choose from.
If you want to select values from another listmanager table you will need another query, you should get the field Id from the second table, and recover all values stored:
select value,value from #__listmanager_values where idfield=X
(replacing X for the ID number of the field containing values)
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
the 'link to other list' type is not intended to recover options from other list to add new data, it creates a html link to navigate to the other list, with a filter applied, it's not what you need to get options available.
In order to create a combobox filled with values comming from other table, you should use the type 'option list', but configuring the options as 'sql actions', where you can write the query used to recover values.
For ex, if you write SELECT id, username FROM #__users
the option list will show all users from your db to choose from.
If you want to select values from another listmanager table you will need another query, you should get the field Id from the second table, and recover all values stored:
select value,value from #__listmanager_values where idfield=X
(replacing X for the ID number of the field containing values)
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
Re: List look up? 11.12.2013 12:23
Thank you.
I've set up the field as per your instructions. (Note: the window for adding the SQL query is right at the top of my screen and I can't see what I'm entering so I'm cutting and pasting and assuming it's there)
I've uploaded a table called builders and added the SQL query
SELECT cb_builderName FROM ove83_builders
When I try to add a record from the front end the "Builder" field is a drop down but the list isn't appearing
If I proceed anyway and try to add a record I get the following:
string(1) "7"
instead of the new record.
I've set up the field as per your instructions. (Note: the window for adding the SQL query is right at the top of my screen and I can't see what I'm entering so I'm cutting and pasting and assuming it's there)
I've uploaded a table called builders and added the SQL query
SELECT cb_builderName FROM ove83_builders
When I try to add a record from the front end the "Builder" field is a drop down but the list isn't appearing
If I proceed anyway and try to add a record I get the following:
string(1) "7"
instead of the new record.
Re: List look up? 11.12.2013 16:04
Hi,
you should see the sql window centered, maybe you have something conflicting with default jquery, like another template for the backend or any plugin adding js content?
You also have a button to test the result of the query at that window, we suggest to check it, it will show you the results obtained that will be shown on the option list. And finally, add a second field to your query, even if its the same
select cb_builderName, cb_builderName from.....
because the option list needs a couple of values, the 'label', and the real 'value' of each option.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
you should see the sql window centered, maybe you have something conflicting with default jquery, like another template for the backend or any plugin adding js content?
You also have a button to test the result of the query at that window, we suggest to check it, it will show you the results obtained that will be shown on the option list. And finally, add a second field to your query, even if its the same
select cb_builderName, cb_builderName from.....
because the option list needs a couple of values, the 'label', and the real 'value' of each option.
Hope this helps, regards
Moonsoft Team
www.moonsoft.es
Re: List look up? 12.12.2013 09:52
Hi,
without checking the page, we can't be sure if the values are really there and they are printed with white labels. If its really a css issue, that property must be set at your template css, because listmanager doesn't apply white style to the comboboxes, all properties are inherited. If you share your url we can confirm if there is any style affecting.
Regards
Moonsoft Team
www.moonsoft.es
without checking the page, we can't be sure if the values are really there and they are printed with white labels. If its really a css issue, that property must be set at your template css, because listmanager doesn't apply white style to the comboboxes, all properties are inherited. If you share your url we can confirm if there is any style affecting.
Regards
Moonsoft Team
www.moonsoft.es
Re: List look up? 13.12.2013 18:01
I created a test list with two fields: User and Builder
User type is User
Builder type is Option List
I can add data to the list using Manage Data and the two fields behave correctly. When I try to display the same list on the front end nothing appears. This is the same behaviour I'm seeing with the Boat list that I'm trying to create.
I created a few screen captures to show what is going on. I'll send them by separate email.
At this point I don't think it's the tables that are causing the problem as the test I created only has three records and it behaves in the same way as the larger list.
g
User type is User
Builder type is Option List
I can add data to the list using Manage Data and the two fields behave correctly. When I try to display the same list on the front end nothing appears. This is the same behaviour I'm seeing with the Boat list that I'm trying to create.
I created a few screen captures to show what is going on. I'll send them by separate email.
At this point I don't think it's the tables that are causing the problem as the test I created only has three records and it behaves in the same way as the larger list.
g
Re: List look up? 16.12.2013 18:00
Hi,
use your customer access and enter helpdesk system, same way you used to place the ticket. Enter your ticket number there to access the thread where we have placed our comments.
Thanks, regards
Moonsoft Team
www.moonsoft.es
use your customer access and enter helpdesk system, same way you used to place the ticket. Enter your ticket number there to access the thread where we have placed our comments.
Thanks, regards
Moonsoft Team
www.moonsoft.es