ole - Clearquest Api C# Sort Order -
i having trouble sorting result set field using clearquest api in c#. trying follow this tutorial seems methods not same in c# clearquest api. if post example of how sort data set ascending field name great!
edit: here's code example have tried:
session cqsession = new session(); cqsession.userlogon("exampleuser", "examplepassword", "exampledb", 2, "ex_db_set"); oadquerydef querydef = (cqsession.buildquery("defect")) oadquerydef; // build fields of result set querydef.buildfield("id"); querydef.buildfield("state"); querydef.buildfield("headline"); querydef.buildfield("total_est_hrs"); // create filter operators ioadqueryfilternode filter1 = querydef.buildfilteroperator(and); ioadqueryfilternode filter2 = filter1.buildfilteroperator(and); ioadqueryfilternode filter3 = filter2.buildfilteroperator(and); // build filters filter1.buildfilter("state", equal, "opened"); filter2.buildfilter("id", greater_than, "scr00032251"); filter2.buildfilter("id", less_than, "scr00139300"); filter3.buildfilter("total_est_hrs", greater_than, "0"); // here having tough time sorting id field. // want id field sorted in order ascending least greatest ioadqueryfielddef queryfielddef = querydef.queryfielddefs("id"); queryfielddef.setsorttype(ad_sort_asc); oadresultset rs = (cqsession.buildresultset(querydef)) oadresultset; rs.executeandcountrecords();
Comments
Post a Comment