INFO-根据离线开发目录名称获取路径下任务信息

适用模块

离线开发

具体说明

根据离线开发目录名称获取路径下任务信息

使用示例

1、根据目录名称查找下级目录信息，id为目录标识；parentid为父级目录id，-1代表第一层；name为文件夹名称，product项目名称。
select id,parentid,name from pf_az_folder where  name= 'xxx' and product ='ebd_dw';
select id,parentid,name from pf_az_folder where  parentid= 'yyy' and product ='ebd_dw';

1、通过目录id获取任务信息
select
  flow
from
  pf_az_flow
where
  project in (
    select
      project
    from
      pf_az_config
    where
      projectid in (
        select
          azconfigid
        from
          pf_az_projectfolder
        where
          folderid in (
            select
              id
            from
              pf_az_folder
            where
              id = 237
          )
      )
      and account = 'ebd_dw'
  )
group by
  flow;

作者：林帅