[Trace]Routing的查询与建立

以件号"620467300A"为例

1.从t_nomen中查询出id_nomen值

select id_nomen from t_nomen where et_refakf_se='620467300A' and et_refakf_comp is null

id_nomen=16945

2.从t_simo中查询routing

select id_simo,et_nomen,et_modeop,et_modeop_pere,simo_no_comp,simo_nbpassok,simo_nsl from t_simo where et_nomen=16945 and simo_fin_validite is null order by id_simo

 

在Lazarus论坛中,使用件号'650119400C'和'636110900C'，

select id_simo,et_nomen,et_modeop,et_modeop_pere from t_simo where et_nomen in(100458,171995) and simo_fin_validite is null order by et_nomen,id_simo