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());
}
....