Topic: Is there a flag in a table to mark a component or an assembly is hidden/obsolete please?
By: Guest
Posted on: Feb 22 2025 at 12:02:15 PM
Is there a flag in a table to mark a component or an assembly is hidden/obsolete please? If so which table?
Thank you!
By: Guest
Posted on: Feb 24 2025 at 02:31:20 PM
When you say "in a table" do you mean that you're editing directly into the database file?
To see it in MiniMRP open the "All Components" grid. Near the top of the grid is the little 'bruger' menu button (the buton with 3 horizontal lines) click that to see options to view obsolete/hidden components.
If you want to set a lot of items to obsolete then go to the burger menu and select the "Row Select" option. A column appears to the left of each row. click that column to highlight a row. Hold down the shift key and scroll down the list selecting more rows. Then click with the RIGHT mouse button into the selected rows and set them or unset them
By: Guest
Posted on: Feb 25 2025 at 05:52:35 PM
Appreciate your reply. Thank you.
"When you say "in a table" do you mean that you're editing directly into the database file?"
No. We'd like to extract Components/Assembly from the database using a query/SQL for customised report but not for Obsolete or Hidden items.
There is a field called Type in tblstockitems that indicates Part/ASSY but not items marked as Obsolete or Hidden.
Any ideas?
By: Guest
Posted on: Feb 26 2025 at 09:16:17 PM
Dear miniMRP team,
"Is there a flag in a table to mark a component or an assembly is hidden/obsolete please? If so which table?"
Would appreciate any input please?
Cheers
By: Support
Posted on: Feb 27 2025 at 12:59:21 PM
We have followed this thread but didn't reply because, we thought, the reply you got from another user was accurate and needed no further information.
But because you want to do extract the data from the database yourself using an SQL Query then you need to be looking in a different table.
// We store the Hide or Obsolete flag in tblitemlocation.LocHidden
FLAG_NORMAL = 0;
FLAG_HIDDEN = 1;
OBSOLETE = 2;
Every item in tblstockitems has an ItemID
tblstockitems.ItemID = tblitemlocation.LocStockID
The reason that it's in tblitemlocation and not in tblstockitems is because the 'Pro' version of MiniMRP allows the same item to be stored in different sites (ie different waerhouses in different towns/countries). A part number, description etc exists in tblstockitems but each site can have differet OnHand quantities of the item and can show or hide the part independently of other sites.
In MiniMRP a site can hide an item and it remains visible in other sites. But if an item is made obsolete then it's made obsolete in all locations.
By: Support
Posted on: Feb 27 2025 at 01:28:19 PM
. . . and in case you do have multiple locations/sites then you also need to be looking at the LocID column which relates to tblhome so you can get the hidden flag for each location.
I do want to stress to anyone else reading this page - you do not need to know this stuff. It's only of interest to the OP or anyone else creating their own SQL Queries. You can do pretty much everything you want using the MiniMRP program - you don;t need to go poking about in the data file.
By: Guest
Posted on: Mar 4 2025 at 11:22:29 PM
Thank you! Exactly what I'm after. Cheers.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
