<div>
I don't know openbravo, but see the relevant table as stockcurrent.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41539437-1"><span>Select * from stockcurrent where units&lt;&gt;0</span>
</code></pre>
<br />
It might be a little more complicated, if a product can be in several locations.<br />
<br />
Anyway, there is another table stocklevels indicating the shop system has a means of alerting about too low stock with a stock level you define there.<br />
<br />
And finally you make me wonder about negative stock, but that's a topic of it's own.<br />
<br />
I hope I can get you in the right direction, at least.<br />
<br />
Bye, Olaf.
</div>


<div>
Maybe you want to see stock changes? They should be in stockdiary.<br />
<br />
Bye, Olaf.
</div>


<div>
Olaf,<br />
<br />
No only one location (at this moment:)<br />
most of the articles dont have an initial stock and i can only see how many sold to count the negative<br />
<br />
When i do the query i dont get the name of the product <br />
<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5c23cfeb-980f-45a4-991b-bd<wbr />cd80ae00a0<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-2<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bca3e2fb-e049-4e48-b4be-30<wbr />42d6839810<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-2<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;900b5b9f-e184-4601-984d-18<wbr />aef1bd8ef6<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-2<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;38702e71-8ff6-4c4a-99fd-bd<wbr />37a634a2af<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-2<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5980037f-b9ea-41e3-ae61-18<wbr />0533a04be6<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-2<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06f791ec-f1b5-4bb3-82d7-97<wbr />660c21e406<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-1<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;051df13f-8d2f-4ae1-bb48-98<wbr />b97b0686e0<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-1<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d8bdbcee-7e37-41da-a5fe-04<wbr />d6f2070c4d<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-1<br />
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7299be23-cc7f-4e43-aa23-3f<wbr />9c308f2555<wbr /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-1
</div>


<div>
Olaf,<br />
<br />
You dont know openbravo and Just like that you do this <br />
<br />
terrible &nbsp;:))))<br />
Vielen dank <br />
Thanks Danny
</div>


<div>
Well, that just tells it's a good product with a well designed database adhereing some general principles.<br />
<br />
The documentation also tells me the referencing (i.e. the stocklevels table definitions says the sticklevel.product column refers to the products.id). I would just need to guessing about some meanings, but the wiki surely also documents this elsewhere.<br />
<br />
Once you update stock, you will surely not be able to reuse this as seeing sales from it, you only see the current stock. So perhaps also try the query on the stockdiary, which stores data with dates and a reson for the stockchange. A sell might be a stockdiary reason. Reordering and adding stock another, so you could differnetiate. Just a guess on the meaning, though.<br />
<br />
Bye, Olaf.
</div>


<div>
Olaf <br />
<br />
Thanks for the explanation i wil test this and i am sure i have to get deeper in this matter<br />
<br />
Thanks so much <br />
<br />
Danny
</div>


<div>
<div class="content wysiwyg-content">
I am using a POS system based on openbravo <br />
<a href="http://wiki.openbravo.com/wiki/Projects:POS/Administrator_Guide" rel="ugc">http://wiki.openbravo.com/wiki/Projects:POS/Administrator_Guide</a><br />
running on windows 10, mysql 5.6<br />
The database model <a href="http://wiki.openbravo.com/wiki/POS/2.30/Database_Model" rel="ugc">http://wiki.openbravo.com/wiki/POS/2.30/Database_Model</a><br />
Can somebody help me to get a Query to get names from article's If stock is higher or lower than zero and see the stock amounts<br />
example<br />
<br />
cola -10 this i want to see<br />
fanta 10 this i want to see<br />
sprite 0 this i dont want to see<br />
<br />
Thanks for helping Danny
</div>
</div>


I am using a POS system based on openbravo 
http://wiki.openbravo.com/wiki/Projects:POS/Administrator_Guide
running on windows 10, mysql 5.6
The database model http://wiki.openbravo.com/wiki/POS/2.30/Database_Model
Can somebody help me to get a Query to get names from article's If stock is higher or lower than zero and see the stock amounts
example

cola -10 this i want to see
fanta 10 this i want to see
sprite 0 this i dont want to see

Thanks for helping Danny

Query to get name from article and how many items sold on openbravo POS MYSQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.

Miscellaneous

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.