[Skip to main content](#vessel-content)

#   Custom Status Filtering In Reports

##

- **[kevin@solasus.com](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile")**
- [![kevin@solasus.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile") Topic Author
- [ Offline](/forum/user/3454-kevin-solasus-com)

Less More

- Posts: 26
- Thank you received: 0
-
-

13 years 2 months ago [\#120093](#120093) by [kevin@solasus.com](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile")  *[Custom Status Filtering In Reports](/forum/36-reports-statistics/861344-custom-status-filtering-in-reports#120093 "Hi I'm trying to create an order report that filters out some of the default order status (e.g. confirmed) ... however none of my custom order statuses are available in the Filter &gt;&gt; Order status multi-select field. Any ideas...?  Thank you! -kevin  -- HikaShop version -- : 2.2.0 -- Joomla version -- : 2.5.14 -- PHP version -- : 5.3.3")* was created by *[kevin@solasus.com](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile")*

Hi
I'm trying to create an order report that filters out some of the default order status (e.g. confirmed) ... however none of my custom order statuses are available in the Filter &gt;&gt; Order status multi-select field.
Any ideas...?

Thank you!
-kevin

-- HikaShop version -- : 2.2.0
-- Joomla version -- : 2.5.14
-- PHP version -- : 5.3.3

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjEzNDQtY3VzdG9tLXN0YXR1cy1maWx0ZXJpbmctaW4tcmVwb3J0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86358
- Thank you received: 14293
-
-

13 years 2 months ago [\#120112](#120112) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Custom Status Filtering In Reports](/forum/36-reports-statistics/861344-custom-status-filtering-in-reports#120112 "Hi I'm trying to create an order report that filters out some of the default order status (e.g. confirmed) ... however none of my custom order statuses are available in the Filter &gt;&gt; Order status multi-select field. Any ideas...?  Thank you! -kevin  -- HikaShop version -- : 2.2.0 -- Joomla version -- : 2.5.14 -- PHP version -- : 5.3.3")*

Hi,

Change all the lines:
$orderStatuses = $db-&gt;loadResultArray();

to:
$orderStatuses = $db-&gt;loadColumn();

in the file plugins/system/hikashopmassaction/hikashopmassaction.php and that should help.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjEzNDQtY3VzdG9tLXN0YXR1cy1maWx0ZXJpbmctaW4tcmVwb3J0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[kevin@solasus.com](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile")**
- [![kevin@solasus.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile") Topic Author
- [ Offline](/forum/user/3454-kevin-solasus-com)

Less More

- Posts: 26
- Thank you received: 0
-
-

13 years 2 months ago [\#120120](#120120) by [kevin@solasus.com](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile")  Replied by *[kevin@solasus.com](/forum/user/3454-kevin-solasus-com "View kevin@solasus.com's Profile")* on topic *[SOLVED: Custom Status Filtering In Reports](/forum/36-reports-statistics/861344-custom-status-filtering-in-reports#120120 "Hi I'm trying to create an order report that filters out some of the default order status (e.g. confirmed) ... however none of my custom order statuses are available in the Filter &gt;&gt; Order status multi-select field. Any ideas...?  Thank you! -kevin  -- HikaShop version -- : 2.2.0 -- Joomla version -- : 2.5.14 -- PHP version -- : 5.3.3")*

Hi Nicolas

Worked like a charm. Many thanks!!! ![B)](/media/kunena/emoticons/9.png "B)")

-Kevin

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjEzNDQtY3VzdG9tLXN0YXR1cy1maWx0ZXJpbmctaW4tcmVwb3J0cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.043 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
