[Skip to main content](#vessel-content) # Order listing search custom fields ## - **[designbuilder](/forum/user/36129-designbuilder "View designbuilder's Profile")** - [![designbuilder's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36129-designbuilder "View designbuilder's Profile") Topic Author - [ Offline](/forum/user/36129-designbuilder) Less More - Posts: 9 - Thank you received: 0 - - 10 years 4 months ago [\#243204](#243204) by [designbuilder](/forum/user/36129-designbuilder "View designbuilder's Profile") *[Order listing search custom fields](/forum/23-market-how-to/885112-order-listing-search-custom-fields#243204 "-- HikaShop version -- : 2.6.3 -- HikaMarket version -- : 1.7.0 -- Joomla version -- : 3.5.1 Hi, We are using In Hikamarket Frontend and need to be able to search for values in custom fields of the type item i.e. from the _hikashop_order_product table. Can you advise how this might be achieved. Thanks,")* was created by *[designbuilder](/forum/user/36129-designbuilder "View designbuilder's Profile")* -- HikaShop version -- : 2.6.3 -- HikaMarket version -- : 1.7.0 -- Joomla version -- : 3.5.1 Hi, We are using In Hikamarket Frontend and need to be able to search for values in custom fields of the type item i.e. from the _hikashop_order_product table. Can you advise how this might be achieved. Thanks, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIzLW1hcmtldC1ob3ctdG8vODg1MTEyLW9yZGVyLWxpc3Rpbmctc2VhcmNoLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) 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) - 10 years 4 months ago [\#243207](#243207) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Order listing search custom fields](/forum/23-market-how-to/885112-order-listing-search-custom-fields#243207 "-- HikaShop version -- : 2.6.3 -- HikaMarket version -- : 1.7.0 -- Joomla version -- : 3.5.1 Hi, We are using In Hikamarket Frontend and need to be able to search for values in custom fields of the type item i.e. from the _hikashop_order_product table. Can you advise how this might be achieved. Thanks,")* Hi, There is a very similar request in that thread : [ www.hikashop.com/forum/23-market-how-to/...o-vendor-orders.html](https://www.hikashop.com/forum/23-market-how-to/884846-adding-a-new-filter-to-vendor-orders.html) The HikaMarket order listing just use the table "hikashop order" and "hikashop user". In order to include extra tables (for filters or search) requires for the moment the usage of a plugin. Perform a link with the table "order product" would be complicated because the SQL will return one line per order product. So if an order have 3 products, you would have 3 rows in the SQL result. Because of the aggregation on the "order_id", you will right have one row but you can't know which one it would be. To summarize, including the "order products" in the query is possible and could work for a search feature. But it won't be the right usage if you want to display these order product information in the order listing afterwards. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIzLW1hcmtldC1ob3ctdG8vODg1MTEyLW9yZGVyLWxpc3Rpbmctc2VhcmNoLWN1c3RvbS1maWVsZHM/dG1wbD1tYXJrZG93bg==) 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.108 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)