lib/toolhound-ruby/inventory.rb in toolhound-ruby-1.0.6 vs lib/toolhound-ruby/inventory.rb in toolhound-ruby-1.0.7

@@ -16,12 +16,13 @@
       selects = {
         inventory: ["intInventoryID", "intCategoryID", "intSubCategoryID", "intManufacturerID", "intVendorID", "dteCreatedDate", "dteModifiedDate"],
         inventory_text: ["varPartNo", "varDescription", "txtNotes", {varUserField1: "varGlRevenue"}, {varUserField2: "varGlCOGSCode"}, {varUserField3: "varPhaseCode"}],
         unit_of_measure_text: ["varUnitOfMeasure"],
         category: ["varCategory"],
-        sub_category: ["varCategory"]
+        sub_category: [{varCategory: "varSubcategory"}]
       }
     end
+    
     def default_joins
       arr = []
       arr << "INNER JOIN tblInventoryType ON tblInventory.intInventoryTypeID = tblInventoryType.intInventoryTypeID"
       arr << "INNER JOIN tblInventoryText ON (tblInventoryText.intInventoryID = tblInventory.intInventoryID AND tblInventoryText.varLocaleID = '#{locale}')"
       arr << "LEFT OUTER JOIN tblUnitOfMeasureText ON (tblUnitOfMeasureText.intUofMID = tblInventory.intUofMID )"