Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

请问大佬,一张表有两个下拉框一个Select多选和checkbox,修改的时候checkbox要显示新增Select多选的数据,怎么查询Select多选的数据 #356

Open
99tian opened this issue Jul 19, 2024 · 2 comments

Comments

@99tian
Copy link

99tian commented Jul 19, 2024

微信图片编辑_20240719172933
我的数据字典

WITH SplitValues AS (

SELECT 
    ProductionKanbanID,
    value
FROM 
    Ware_ProductionKanban
CROSS APPLY STRING_SPLIT(ProcessLine_Id, ',')

)
SELECT
SV.ProductionKanbanID,
Base_ProcessLine.ProcessLine_Id,
Base_ProcessLine.ProcessLineName
FROM
SplitValues AS SV
INNER JOIN
Base_ProcessLine ON CAST(Base_ProcessLine.ProcessLine_Id AS NVARCHAR(MAX)) = SV.value;

@xiazhaozhao
Copy link

xiazhaozhao commented Jul 19, 2024 via email

@cq-panda
Copy link
Owner

cq-panda commented Jul 19, 2024 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants