How can I query a request number with the sc_req_item table?

[PaKe]

Hello,

I need to show the requested items with a certain request-number. Therefore I query the sc_req_item table. Here is my code, but I don't know what is the right name for the field with the request-number:

var gr = GlideRecord('sc_req_item');
gr.addOuery('Request', current.request.number);
gr.query();
while(gr.next()){
	template.print(gr.number);
	template.print(gr.cat_item.name);
	template.print(gr.cat_item.price);
} 

Hopefully somebody can help me. Thanks in advanced!

[PaKe]

Unfortunately I get all requested items

[Chuck Tomasi]

How many rows did it say it was returning?

Let's add one more line to see what the query being used is... I'd like to know what the output of that >>>DEBUG line is.

if (current.request) {
  var gr = GlideRecord('sc_req_item');
  gr.addQuery('request', current.request.number);
  gr.query();
  template.print(gr.getRowCount() + ' items found');
  template.print('>>>DEBUG: query=' + gr.getEncodedQuery());

  while(gr.next()){
    template.print(gr.number);
    template.print(gr.cat_item.name);
    template.print(gr.cat_item.price);
  }
} else {
  template.print('No parent request found.');
}