Hi I am trying to create a list with tables I created on Mysql db. But list doesn't show. I tried with joomla native content table and it worked well. So is the seblod list search designed to work only with joomla native tables?
Thank you Jon, - I have created a device table were first column name was device_id - Created a seblod form (device) for imput and data view base on the device table - Created a seblod list & search table based on device form - At the first load, the list & search table was empty. I went in my sql device table and changed the first column name from device_id to id. After this change, I was able to list items in my search list. Next think I wanted to do was to link each search item to its content. So a click on any search item will show the content. To accomplish this, I went to list, option 2 (Link + Typography) and selected Content View under link for each item I wanted to use as link to the content. But link hasn’t been generated. Here is what it shows when I inspect the search item under chrome. When I inspect a working search list created based on joomla content table. Result shows the link under each item like this.
When I inspect a working search list created based on joomla content table.
Result shows the link under each item like this.
I don't understand why you create #__device and then use a seblod form to populate it. You are going to end up with a new table from Seblod anyway (as far as I can tell) - probably because of the reasons stated by Klas: searching-a-non-joomla-table
Anyway, what does your sql query look like? That will tell you what you need to resolve (debug option in template config).
Are you using Search Query and/or Search Join fields etc
1- I am using a 3th party table. When I create a field in my form I use a free storage and select the table I have already created then I add a new column.
I don't know how to create table using seblod. My table is listed in #_cck_core
Note: Search function works well on my search form. I am only having problem link each search item to the content.
Here is what I am doing.
1- Under search Form Tab, I use the CCK field and select the device form as live value save
2- Under list tab I select all fields I want to view on my form them on each field I select Option 2 (live value) on the right then I click on None under the "Link" column and I select view under Content.
Result I am expecting from this is to view the full content when I click on each item in the list.But I am getting no link at all on the items when I Use a free storage. But same think work perfectly when I use any native joomla table.
What I am trying to do is to create an application with many table not beeing joomla tables.
I haven't writen any query. I am using only seblod functions.
Thank you for you determination to help. I just spend the whole day searching on it. I don't know if it is event possible with seblod. please let me know if you find any answer for this. By the way is there any other option to view the content details on seblod without using the list search?
Apparently the link feature of Seblod doesn't work with free storage. This link seams to provide the solution but there is not enough explanation or I am not understanding well what to do. Take a look and see if you can get it to work.
I have a result, but probably not near the result you are looking for...
I pulled results from a table that is NOT linked to the
#__cck_core table but where the menu items have the same alias as the articles
Thank you again. I am definetely getting on the way but still stroggling a bit.
Now I know SEBLOD content view works only with joomla native tables. So, to show my item list content I need to create 2 List & Search form. 1 to pull up my list and the second to show the appropriate content when a user clicks on any item in the list. Right?
I have my list view ready named List view1. I have created a second list type named view1 data to show
List view1 items details. I have also created a menu that points to
view1 Now I am stuck on how to use the menu in List view1 and past the article id
for each item in my list to show item details in view1
Thank you Bucklash. I am finally able to get dynamic link from my serach list "list view1" well pointed at appropriate detail on the view1 search. I have used on search view1 > List & Search Option under option 2 (Link), Click on the + and under Serach Type (List)* I have selected view1; under menu Item, I selected the menu I creatd earlier that points to view1; under field, I selected Custom and entered the field name id
on the view2 under Live value (2) I selected Variable for the CCK_id field, went to configure and selected the same options as on construction 1 you did.
NOW I have another isue. content details contains uploaded files. these files are not showing at all on view1. Did uploaded files shows only in the form content or I need another setting?
I were able to sort out the file issue view. Now the issue is that when I click on the file name, instate of downloading the file, it takes me to the home page. some time it says the file doesn't exist. I already vitrified that the file exist and that it is it the right folder with 755 right.