如何通过后端函数查询供应商档案的的是否启用的状态

~陆建伟~

如题,我通过查询实体的方式可以获取部分供应商的信息，但找不到启用状态

const sql="select * from aa.vendor.Vendor where id="+id
var res = ObjectStore.queryByYonQL(sql,"productcenter");

yonyouhmm

1. select vendorextends.stopstatus from aa.vendor.Vendor

复制代码

确认下是否是这个字段

~陆建伟~

老师那么写报错，我* 查出来是如下信息
{
    "country": "0040be98-735b-44c0-afe5-54d11a96037b",
    "relationTenantId": "dabx8ans",
    "ycnCode": "YC00000000007",
    "bcoordination": 0,
    "freezestatus": false,
    "code": "应商分类000002",
    "syncErpFlag": false,
    "entProfileFilePath": "82ce3b30-d836-11ec-88b6-b329a6b27398",
    "language": "d3a95d36-0ce4-11ea-817e-7cd30abea0c0",
    "internalunit": false,
    "relationEnterpriseId": 8,
    "extSystemCode": 0,
    "orgId": "666666",
    "licenseType": "businessLicense",
    "investigationFilePath": "82e17510-d836-11ec-88b6-b329a6b27398",
    "taxPayingCategories": 0,
    "supplyType": 0,
    "id": 2782798317965568,
    "pubts": "2022-07-01 10:23:31",
    "tenant": 2770872350756896,
    "accessstatus": "1",
    "mgtType": 0,
    "org": "666666",
    "timeZone": "cc4ee641-7d33-4133-8857-30468220cde8",
    "tenantErrorMsg": "",
    "retailInvestors": false,
    "correspondingcust": 2782220025762048,
    "vendorclass": 2782796291576064,
    "correspondingorg": "2779834282234368",
    "datasource": "2",
    "busPerformanceFilePath": "82d8e990-d836-11ec-88b6-b329a6b27398",
    "name": "slsunly01",
    "entRelationshipId": 1
}

yonyouhmm

你的yonql里把select后的*改为vendorextends.stopstatus  会报错吗，我这里试过了能查出来的。中间是.不是，

~陆建伟~

已经可以了，谢谢老师！