Author Topic: ItemServiceQuery  (Read 1904 times)

Ferrell

  • Member
  • *
  • Posts: 7
ItemServiceQuery
« on: December 06, 2010, 10:05:55 PM »
Due to the absence of detail in the documentation and it not being quite clear in the OSR I am having a challenging pulling additional Item Service fields.

I have tried the following per another similar post but it does not produce a proper value, instead I get "0" in the field.
SetField [ Main::gResult; PCQB_RqNew ( "ItemQuery" ; "" ) ]

If [0 = PCQB_RqExecute]
SetField [Main::gResult;PCQB_RsOpenFirstRecord]
Loop
Exit Loop If [Main::gResult = "End" pr Main::gResult = "!!Error!!"]
New Record/Request
SetField [ Items::ListID; PCQB_RsGetFirstFieldValue("ListID")]
SetField [ Items::Name; PCQB_RsGetFirstFieldValue("FullName")]
SetField [ Items::Description; PCQB_RqAddFieldWithValue ( "NameFilter::MatchCriterion" ; "Contains" ) ]
SetField [ Items::Description; PCQB_RqAddFieldWithValue ( "NameFilter::Name" ; Description ) ]
SetField [ Main::gResult; PCQB_RsOpenNextRecord]
End Loop
End If

Result in Description ends up being "0"


I Have also tried:

If [0 = PCQB_RqExecute]
SetField [Main::gResult;PCQB_RsOpenFirstRecord]
Loop
Exit Loop If [Main::gResult = "End" pr Main::gResult = "!!Error!!"]
New Record/Request
SetField [ Items::ListID; PCQB_RsGetFirstFieldValue("ListID")]
SetField [ Items::Name; PCQB_RsGetFirstFieldValue("FullName")]
SetField [ Items::Description; PCQB_RqAddFieldWithValue("NameFilter::Description")]
SetField [ Main::gResult; PCQB_RsOpenNextRecord]
End Loop
End If


Result ends up being Blank in the description field


I Have also tried:


If [0 = PCQB_RqExecute]
SetField [Main::gResult;PCQB_RsOpenFirstRecord]
Loop
Exit Loop If [Main::gResult = "End" pr Main::gResult = "!!Error!!"]
New Record/Request
SetField [ Items::ListID; PCQB_RsGetFirstFieldValue("ListID")]
SetField [ Items::Name; PCQB_RsGetFirstFieldValue("FullName")]
SetField [ Items::Description; PCQB_RsGetFirstFieldValue("NameFilter::Description")]
SetField [ Main::gResult; PCQB_RsOpenNextRecord]
End Loop
End If



I need to pull 5 fields:
1. Name
2. Description
3. Type
4. Account
5. Item Number

So any help is appreciated because I am now in trial and error mode.