AnsweredAssumed Answered

.Net Integration

Question asked by Adersh Ram on Jul 25, 2012
Latest reply on Jul 27, 2012 by Adersh Ram
Hi,

I am trying to show projects in .Net application using clarity Web Services Descriptive Language (WSDL).

Step 1: I create a NSQL query in Clarity.

SELECT
@SELECT:DIM:USER_DEF:IMPLIED:PRJ:ID:ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:NAME:NAME@
FROM
(
SELECT
ID,
NAME
FROM
INV_INVESTMENTS
WHERE CODE = @where:param:user_def:string:ProjectCode@
)
WHERE @FILTER@


Step 2: Added the Web service in a .Net Project. But i cannot pass the ProjectCode parameter in this service.When i am removing the parameter in NSQL it work good.

ProjectService.ProjectQueryService queryService = new ProjectQueryService ();
ProjectService.Login login;
login = new Login();
login.Password = _Password;
login.Username = _LoginID;
string sessionId = null;
sessionId = queryService.Login(login);

ProjectService.Auth auth;
auth = new Auth();
auth.SessionID = sessionId;
queryService.AuthValue = auth;

ProjectService.ProjectQuery query = new ProjectService.ProjectQuery();
query.Code = "Project_List";
Project_List_IDQueryResult results;
results = queryService.Query(query);
queryService.Logout(sessionId);

How to pass a parameter in this service. Any ideas please share

Outcomes