Print Page | Close Window

RESOLVED - Webservice Span not return any data

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1187
Printed Date: 23-Apr-2025 at 10:23pm


Topic: RESOLVED - Webservice Span not return any data
Posted By: orcities
Subject: RESOLVED - Webservice Span not return any data
Date Posted: 02-Apr-2009 at 3:15pm
I am trying to run a query with a webservice
 
I add the span:

QuerySpan mOrgOrgGroupSpan = new QuerySpan();

mOrgOrgGroupSpan.Relations = new string[] { "Organization_OrganizationGroup"};

aQuery.Spans = new QuerySpan[] {mOrgOrgGroupSpan};

The initial object is returned but none of the associated information is returned it is null.
Am I missing something?
 
 


Replies:
Posted By: kimj
Date Posted: 02-Apr-2009 at 8:11pm
Two other things to check, both in Object Mapper:
  • the "web visible" setting for the related class needs to be marked as either "As web method" or "As span object"
  • the "web visible" setting for the specific relation property must be checked
 There's a readme doc with the "Web Service Publishing" learning unit which may help explain this.

Posted By: orcities
Date Posted: 03-Apr-2009 at 7:09am
The stuctures is as such
 
Organization -> OrganizationGroup (ParentOf) -> Organization
 
I have Organization "As web method"
I have OrganizationGroup "As span object"
 
Organization -> OrganizationGroup is "Web Visible" Relation Name Organization_OrganizationGroup
OrganizationGroup -> Organization is "Web Visible" Relation Name Organization_OrganizationGroup_1
 
The property ParentOf is available but the result is null.
 
 

Query aQuery = new Query();

QueryClause aClause = new QueryClause();

aClause.ColumnName = "Name";

aClause.ColumnValue = "Oregon Cities";

aClause.Operator = QueryOp.EQ;

 

QuerySpan mOrgOrgGroupSpan = new QuerySpan();

mOrgOrgGroupSpan.Relations = new string[] { "Organization_OrganizationGroup"};

 

aQuery.Spans = new QuerySpan[] {mOrgOrgGroupSpan};

 

aQuery.Expressions = new QueryExpression[] { aClause };

 

Organization[] mOrgs = mWebService.GetOrganizations(aQuery, String.Empty);

Posted By: orcities
Date Posted: 03-Apr-2009 at 7:55am
I also have a [WebServiceVisable] method that should return an EntityList<> but is returning a string that says "Collection". Whats up with that?

Posted By: orcities
Date Posted: 03-Apr-2009 at 8:43am
And because of this issue I am trying to do a work around by running multiple queries. Hopefully this does not become necessary.
 
In doing so I ran into an issue with using the QueryOp.In type of query. I have tried to use an string, object[], string[], Int64[], arraylist and list but they all return an error. String returns it has to be a collection and any collection returns:
The type xxx may not be used in this context.

Posted By: kimj
Date Posted: 03-Apr-2009 at 9:37am
1.  If you have a relational property called Organization.ParentOf then that property needs to be marked WebVisible too.
 
2. An EntityList<T> can't be returned from a web method, since the service should be consumable by any application.  The generated web methods by default return either an array or a Dataset, and non-scalar relational properties will return an array.
 
3.  I'm not sure what the resulting query looks like, but that may be a bug.

Posted By: orcities
Date Posted: 03-Apr-2009 at 9:43am
What about the span issue?

Posted By: orcities
Date Posted: 03-Apr-2009 at 9:51am

I will make the return type = Organization[]. (This is still just  a work around I need the span to work.)

What I am trying to return with my original span is I want to get an Organization.OrganizationGroup.Organization.
 
Organization is attached to OrganizationGroup where it defines Parent and Child.
I want to get all Children for Organization X. Meaning I have to Span Organzation to OrganizationGroup to Organization.
 
Span is not returning any values for one leve let alone 2.
 
The Relation Name I am setting to span is the Name provided in the Object Mapper Relation Name for that entity.

Posted By: orcities
Date Posted: 03-Apr-2009 at 10:06am
changing that property to return to return an Array still returns a string.

Posted By: orcities
Date Posted: 03-Apr-2009 at 10:13am
ParentOf is the Organization_OrganzationGroup Relation Name
 
When doing the span do I do the Property Name or the Relation Name?

Posted By: orcities
Date Posted: 03-Apr-2009 at 10:15am
Resolved..
 
Need Property Name not relation Name.


Print Page | Close Window