Re: [ic] Showing only Onhand Items

[Mike Heins <suppressed>]

Quoting Peter (suppressed):
> On 09/18/2007 11:12 PM, Armaghan Saqib wrote:
> > Hi,
> > 
> > I want to make a minor change to the tree menu to show items with onhand >= 1
> > 
> > So after search docs, I have tried to change the link from:
> > scan/co=yes/fi=products/sf=prod_group/se=Hand
> > Tools/op=eq/tf=category,description
> > 
> > to:
> > scan/co=yes/fi=products/sf=prod_group/se=Hand
> > Tools/op=eq/tf=category,description/nu=0/fi=inventory/sf=qty/se=1/op=>=/nu=1
> > 
> > But I get the error: Sorry, no matches for Hand Tools | 1.
> 
> You can't search across two files like that, use the [query] tag instead:
> <http://www.interchange.rtfm.info/icdocs/tags/query.html>

Actually, you can:

	[area search="
			co=yes

			sf=prod_group
			se=Hand Tools
			op=eq
			nu=no
			
			sf=inventory:quantity
			se=1
			op=>=
			nu=yes

		"]

That will be fairly efficient, since the op=eq and a database search
will limit the matches to Hand Tools. But beware that using this for a
very large data set without a qualifier could get quite slow, as you
need to pull the quantity field by a separate query.

You can, of course, use [query ...] and that may indeed be the
right thing to do, especially if there is lots of data.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <suppressed>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users