I am trying to filter a table on a single column parameter.  I have tried the {joodb ifis|FIELDNAME = '123'} and have not found the correct format for the qualifier.  My database returns all rows in the order they have been entered.  In addition, I would like to sort the database on a second column and have not found the proper command to order. 

Which view would I use to place a simple query on the page?

Select *

from TABLE

where FIELDNAME = '123'

group by 'FIELDNAME2'