Skip to Content
0
Former Member
Jul 24, 2006 at 08:58 PM

Retrieving data from Qualified table using Java Api

35 Views

Retrieving data from Qualified table using Java Api

I can not seem to retrieve data from a qualified table correctly. Does anyone have any suggestions what I may be doing wrong?

Here the scenario. I need to retrieve all fields from a Partner Function qualifies lookup table for a given Customer Number.

Main Table: Customers

Search Field Customer Number within Customers table

Qualified Tablename: Partner Functions

Required retrieval fields (these fields are all part of the "Partner Functions" table.

1. Sales Organization non- qualified field

2. Distribution Channel non-qualified field

3. Division non-qualified field

4. Partner Function qualified field

5. Partner number qualified field

6. Partner Description qualified field

Below is the Java code

Search search = new Search("Customers");

FreeFormTableParameter freeFormTableParameter = new FreeFormTableParameter("Customers");

search.Add(freeFormTableParameter);

FreeFormParameterField fld = freeFormTableParameter.GetFields().New("Customer Number");

fld.GetFreeForm().NewString("0002101412", FreeFormParameter.EqualToSearchType);

freeFormTableParameter.Add(fld);

search.Add(freeFormTableParameter);

ResultSetDefinition rsd = new ResultSetDefinition(“Partner Functions");

rsd.AddField("Sales Organization");

rsd.AddField("Division");

rsd.AddField("Distribution Channel");

rsd.AddField("Partner Description");

rsd.AddField("Partner Function");

rsd.AddField("Partner Number");

rs = cat.GetResultSet(search, rsd, null, true, 0);

System.out.println("No. of records:" + rs.GetRecordCount());

for(int i=0;i<rs.GetRecordCount();i++)

{

try

{

Value v = rs.GetValueAt(i,"Sales Organization");

System.out.println(i+" v Sales Org " + v.TranslateToString());

v = rs.GetValueAt(i,"Division");

System.out.println(i+" v Div " + v.TranslateToString());

v = rs.GetValueAt(i,"Distribution Channel");

System.out.println(i+" v Distribution Channel " + v.TranslateToString()+"\n");

v = rs.GetValueAt(i,"Partner Function");

System.out.println(i+" v Partner Function " + v.TranslateToString());

}

....