Sp_Ai_AiGlobalAgentQuestionThread.md 1.26 KB

Edit Raw Blame History Permalink



Sp_Ai_AiGlobalAgentQuestionThread (procedure)


AI_调用下单 插入订单


Type: PROCEDURE

Deterministic: NO

SQL data access: CONTAINS SQL


Parameters


#
Mode
Name
Type


1
IN
sBrId
varchar(100)


2
IN
sSuId
varchar(100)


3
IN
sLoginId
varchar(100)


4
IN
sSqlContent
longtext


5
IN
userInput
longtext


6
IN
sQuestion
longtext


7
IN
sQuestionGroupNo
longtext


8
IN
sSceneId
varchar(100)


9
IN
sMethodId
varchar(100)


10
IN
bRedis
int


11
IN
bGlobal
int


12
IN
cachType
varchar(100)


13
OUT
sReturn
longtext


14
OUT
sCode
int


Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpAi_AiGlobalAgentQuestionThread'._


Narrative

Business context: Operates on ai_global_agent_question_sql — part of the AI-features subsystem, which the wiki excludes from its core ERP scope (see the index).

What it does: Writes/updates ai_global_agent_question_sql with cached SQL for global agent Q&A.

Invocation: Not surveyed; out of scope for this catalog.