选项视图无法获取 （sql模式）视图里的数据

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：785980994
【联系电话】:    13531748447
【问题描述】：

当我的视图模式为sql的时候，且是跨数据库查询视图获取出来的数据；


然后在表单里面增加个视图选择框工具，并调用该视图的时候，无法将选中的数据赋值到文本框。设计模式就可以

你好，可以看下sql里面的脚本吗

var where="";
var cInvCode = getItemValueAsString("cInvCode");
var cInvName = getItemValueAsString("cInvName");
var cInvCName = getItemValueAsString("cInvCName");
var cInvCCode = getItemValueAsString("cInvCCode");

if(cInvCode!="") {
    where = " and item_cInvCode like '"+cInvCode+"%'";
}
if(cInvName!="") {
    where = " and item_cInvName like '%"+cInvName+"%'";
}
if(cInvCName!="") {
    where = " and item_cInvCName like '%"+cInvCName+"%'";
}
if(cInvCCode!="") {
    where = " and item_cInvCCode like '%"+cInvCCode+"%'";
}
var sql="select  '"+getDomainid()+"' as DOMAINID,'" + getApplication() + "' AS APPLICATIONID,* from view_material where item_cInvCCode like '07%' "+where;
sql;

view_material   视图是
USE [CYKJ_GCBZ]
GO

/****** Object:  View [dbo].[view_material]    Script Date: 2021-09-28 14:13:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create view [dbo].[view_material] as
SELECT cInvCode as item_cInvCode,cInvName as item_cInvName,cInvStd as item_cInvStd,cInvCCode as item_cInvCCode,cInvCName as item_cInvCName,cComunitCode as item_cComunitCode,cComUnitName as item_cComUnitName,iInvNCost as item_iInvNCost,cInvDefine1 as item_cInvDefine1,cInvDefine2 as item_cInvDefine2,cInvDefine3 as item_cInvDefine3
      ,cInvDefine4 as item_cInvDefine4,cInvDefine6 as item_cInvDefine6,cInvDefine7 as item_cInvDefine7,cInvDefine13 as item_cInvDefine13,cInvDefine14 as item_cInvDefine14,dEndDate as item_dEndDate,bInvBatch as item_bInvBatch,cinvccodeleft as item_cinvccodeleft  FROM u8sync.dbo.V_Inventory
GO

我这边试了一下是可以映射到的

我的写法有错吗？

看脚本好像没啥问题，你视图选择框绑定的视图的数据源是通过sql查询出来的，在前台打开视图选择框是可以显示数据的，但是点击映射就没反应对吧？还是说前台打开视图就已经无法显示数据了？
我这边测试一下，有问题反馈给你。

点击映射没反应，数据是有的

有没有提示报错

奇怪的就是没有提示 也没报错  就是映射不了  是不是版本问题？