Supermap iclient space query join external Table query multi-Table field sample code

Original article. For more information, see the source! Http://blog.csdn.net/songhfu

The following is an example of the code used to query a space table and a joined table field:

/*

* Code indicating successful association test
**/
VaR joinitem = new Supermap. Rest. joinitem ({
Foreigntablename: "v_enableview_land ",
Joinfilter: "bbs_parcel.cadastralno = v_enableview_land.cadastralno ",
Jointype: "innerjoin"
});
VaR queryparam, querybygeometryparameters, queryservice;
Queryparam = new Supermap. Rest. filterparameter ({
Joinitems: [joinitem],
Name: "[email protected] _ sysdb ",
Fields :[
"Bbs_parcel.cadastralno as cadastralno ",
"Bbs_parcel.landuser as landuser ",
"Bbs_parcel.parceladdress as parceladdress ",
"Bbs_parcel.rightstype_cn as rightstype_cn ",
"Bbs_parcel.landpurpose_cn as landpurpose_cn ",
"Bbs_parcel.plotratio as plotratio ",
"Bbs_parcel.postaddress as postaddress ",
"Bbs_parcel.bookarea as bookarea ",
"Bbs_parcel.realarea as realarea ",
"V_enableview_land.fjbm as fjbm"],
Displayfilters: ["v_enableview_land.fjbm = '" + _ discode + "' or v_enableview_land.fjbm is null"]

});

Querybygeometryparameters = new Supermap. Rest. querybygeometryparameters ({
Queryparams: [queryparam],
Geometry: feature. geometry,
Spatialquerymode: Supermap. Rest. spatialquerymode. intersect
});

Supermap iclient space query join external Table query multi-Table field sample code