[Skip to main content](#vessel-content) # Serials Dropdown list ## - **[bassi](/forum/user/35141-bassi "View bassi's Profile")** - [![bassi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35141-bassi "View bassi's Profile") Topic Author - [ Offline](/forum/user/35141-bassi) Less More - Posts: 21 - Thank you received: 0 - - 8 years 6 months ago [\#291677](#291677) by [bassi](/forum/user/35141-bassi "View bassi's Profile") *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#291677 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* was created by *[bassi](/forum/user/35141-bassi "View bassi's Profile")* -- url of the page with the problem -- : [ associazioneformatori.it](https://associazioneformatori.it) -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 6 months ago [\#291678](#291678) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#291678 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* Hello, I don't understand your message. Please clarify --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bassi](/forum/user/35141-bassi "View bassi's Profile")** - [![bassi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35141-bassi "View bassi's Profile") Topic Author - [ Offline](/forum/user/35141-bassi) Less More - Posts: 21 - Thank you received: 0 - - 8 years 6 months ago [\#291724](#291724) by [bassi](/forum/user/35141-bassi "View bassi's Profile") Replied by *[bassi](/forum/user/35141-bassi "View bassi's Profile")* on topic *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#291724 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* Hello Jerome, I explain the form sense: Each member fill in a personal report with some info including a serial number. I created the form with all fields with Fabrik, including a dropdown menù where member should see his serials. The dropdown menù is connected with hikaserial_serial table, but it's not filtered by the user login. After login each member goes in his personal page and see his serials, it's fine, but when open the page to fill in the report, all the serials appear in the dropdown menù. Also the best solution should be that the member use the serial just one time. Thanks, Vito Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 6 months ago [\#291727](#291727) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#291727 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* Hello, Your query link the HikaSerial "serial" table with the Joomla user one ; that relation is incorrect since HikaSerial is an HikaShop add-on and is based on HikaShop users (so HikaShop user id). Table which also have a "user_cms_id". Afterwards I don't know how is working Fabrik, so I can't tell you how retrieve the current Joomla user ID ; you should ask them for that. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bassi](/forum/user/35141-bassi "View bassi's Profile")** - [![bassi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35141-bassi "View bassi's Profile") Topic Author - [ Offline](/forum/user/35141-bassi) Less More - Posts: 21 - Thank you received: 0 - - 8 years 6 months ago [\#291747](#291747) by [bassi](/forum/user/35141-bassi "View bassi's Profile") Replied by *[bassi](/forum/user/35141-bassi "View bassi's Profile")* on topic *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#291747 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* Ok I will check it. Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bassi](/forum/user/35141-bassi "View bassi's Profile")** - [![bassi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35141-bassi "View bassi's Profile") Topic Author - [ Offline](/forum/user/35141-bassi) Less More - Posts: 21 - Thank you received: 0 - - 8 years 5 months ago [\#292355](#292355) by [bassi](/forum/user/35141-bassi "View bassi's Profile") Replied by *[bassi](/forum/user/35141-bassi "View bassi's Profile")* on topic *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#292355 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* Hi Jerome, is it possible to view the user's serials in a dropdown list? At moment I can see these list in a table. Thank you, Vito Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 5 months ago [\#292368](#292368) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Serials Dropdown list](/forum/17-serial-how-to/894518-serials-dropdown-list#292368 "-- url of the page with the problem -- : associazioneformatori.it -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1.0 Hello, I should create a dropdown list of the serials for each user in a form. I built the form with Fabrik Joomla Component, but I have a problem to filter the serials by user. I tried by the follow code: WHERE {thistable}.`serial_id` IN (SELECT nu8cw_hikaserial_serial.serial_id FROM nu8cw_hikaserial_serial LEFT JOIN nu8cw_users ON (nu8cw_hikaserial_serial.serial_user_id = nu8cw_users.id)) But I see all serials that users bought in the list. Thank you in advance, Vito")* Hello, There is no "type" or "namebox" in HikaSerial which allow to do that since there is no need of selecting a serial. It requires a custom development. But if you look at the HikaSerial code ; specially the front-end serial listing ; you will have the necessary elements. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzE3LXNlcmlhbC1ob3ctdG8vODk0NTE4LXNlcmlhbHMtZHJvcGRvd24tbGlzdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.219 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)