Show filtered data on database

Show filtered data on database

jrsalungajrsalunga Posts: 1Questions: 1Answers: 0
edited September 2014 in Free community support

im having this data on database

  • ITEM ---------- ONSTOCK
  • Pencil ---------- 1
  • Paper ---------- 0

what would i configure to the datatables on page so show only the 'pencil' on the page not including the paper?

what configuration on the helper class SPP should I do?

something like 'SELECT item ON products WHERE ONSTOCK = 1'

thanks

This discussion has been closed.