ChinaDrugTrials Query

ChinaDrugTrials Query

Core Rule

Return one row per registration with these fields:

序号 | 登记号 | 试验状态 | 药物名称 | 适应症 | 试验通俗题目 | 公司 | 首次公示日期 | 链接

Treat 公司 as 申请人名称. Treat 首次公示日期 as 首次公示信息日期 unless the user explicitly asks for another date field. Use official platform list/detail pages as the source whenever possible.

Fast Path

Use this path first for normal keyword queries. It was tested against 氟比洛芬贴剂 and avoids the site's most common slow/failing routes.

If the bundled script is available, prefer running it before writing new automation. Run it from the skill directory, or substitute the script path with the resolved path to this skill's scripts/query_chinadrugtrials.py file:

python .\scripts\query_chinadrugtrials.py "氟比洛芬贴剂" --format markdown

If the script fails because Playwright points to a missing chrome-headless-shell.exe, rerun with --browser-path set to the installed Chromium path from p.chromium.executable_path.

The script expects the Python playwright package and a Playwright-managed or explicit Chromium/Chrome executable. If those are unavailable, use the Browser plugin fallback or write equivalent browser automation from the workflow below.

1. Use a real browser automation session, preferably local Playwright with installed Chromium when available.
2. Set stdout/output encoding to UTF-8 before printing Chinese text.
3. Use a browser-like user agent.
4. Open https://www.chinadrugtrials.org.cn/ and wait only for navigation commit if full load events hang.
5. Wait for input[name="keywords"].
6. Fill the keyword as a Unicode string, not through a shell/code path that can replace Chinese characters with question marks.
7. Click the visible submit button (button[type="submit"] / 搜索). Do not rely on pressing Enter.
8. Wait for URL /clinicaltrials.searchlist.dhtml with wait_until="commit", then wait a short fixed delay such as 3-8 seconds. Do not wait forever for domcontentloaded or networkidle.
9. Verify the result count from the pagination text: 当前第 ... 页，共 ... 条记录.
10. Extract result rows from table tr, reading each row's td text plus the first a[onclick*=getDetail] attributes:
    • id is the opaque detail id.
    • name is the row index / ckm_index.
11. For every row, construct and open the detail URL in the same browser context: https://www.chinadrugtrials.org.cn/clinicaltrials.searchlistdetail.dhtml?id=&ckm_index=
12. Extract 申请人名称 and 首次公示信息日期 from the detail page's visible text.
13. Output a Markdown table unless the user requested another format.

Playwright Template

Use this as the starting point when local Playwright is available. Adjust only the keyword and optional output handling.

from playwright.sync_api import sync_playwright
import json, re, sys

sys.stdout.reconfigure(encoding="utf-8")
keyword = "\u6c1f\u6bd4\u6d1b\u82ac\u8d34\u5242"  # replace safely, or assign a normal UTF-8 Python string
base = "https://www.chinadrugtrials.org.cn"
chrome = None  # or set to a local Chromium/Chrome executable path when Playwright cannot find one
ua = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0 Safari/537.36"

def pick_after_tab(text, label):
    m = re.search(re.escape(label) + r"\t([^\t\n]+)", text)
    if m:
        return m.group(1).strip()
    lines = [line.strip() for line in text.splitlines() if line.strip()]
    for i, line in enumerate(lines):
        if line == label and i + 1 < len(lines):
            return lines[i + 1]
    return ""

with sync_playwright() as p:
    browser = p.chromium.launch(
        headless=True,
        executable_path=chrome or p.chromium.executable_path,
        args=["--disable-blink-features=AutomationControlled"],
    )
    context = browser.new_context(user_agent=ua)
    page = context.new_page()
    page.goto(base + "/", wait_until="commit", timeout=60000)
    page.wait_for_selector('input[name="keywords"]', timeout=30000)
    page.locator('input[name="keywords"]').fill(keyword)
    page.locator('button[type="submit"]').click(timeout=10000)
    page.wait_for_url("**/clinicaltrials.searchlist.dhtml", wait_until="commit", timeout=60000)
    page.wait_for_timeout(5000)

    body = page.locator("body").inner_text(timeout=10000).replace("\u00a0", " ")
    rows = page.evaluate("""() => Array.from(document.querySelectorAll('table tr')).map(tr => {
      const tds = Array.from(tr.querySelectorAll('td')).map(td => td.innerText.trim().replace(/\u00a0/g, ' '));
      const a = tr.querySelector('a[onclick*=getDetail]');
      return tds.length >= 6 ? {
        seq: tds[0], reg: tds[1], status: tds[2], drug: tds[3],
        indication: tds[4], title: tds[5], id: a && a.id, idx: a && a.name
      } : null;
    }).filter(Boolean)""")

    results = []
    for row in rows:
        link = f"{base}/clinicaltrials.searchlistdetail.dhtml?id={row['id']}&ckm_index={row['idx']}"
        detail = context.new_page()
        detail.goto(link, wait_until="commit", timeout=60000)
        detail.wait_for_timeout(2500)
        text = detail.locator("body").inner_text(timeout=10000).replace("\u00a0", " ")
        row["company"] = pick_after_tab(text, "申请人名称")
        row["date"] = pick_after_tab(text, "首次公示信息日期")
        row["link"] = link
        results.append(row)
        detail.close()

    print(json.dumps({"summary": body[-120:], "rows": results}, ensure_ascii=False, indent=2))
    browser.close()

If Playwright raises Executable doesn't exist ... chrome-headless-shell.exe, get the actual browser path with:

python -c "from playwright.sync_api import sync_playwright; p=sync_playwright().start(); print(p.chromium.executable_path); p.stop()"

Then pass that path as executable_path. Do not spend time installing browsers unless the installed path is truly absent.

Official Detail Parsing

The detail page commonly prints the fields in a tab-delimited visible block:

登记号    CTR...    试验状态    ...
申请人联系人    ...    首次公示信息日期    YYYY-MM-DD
申请人名称    ...

Prefer tab-aware extraction:

• 首次公示信息日期\t([^\t\n]+)
• 申请人名称\t([^\t\n]+)

Fallback to a next-line parser only when the tab pattern is absent.

Known Traps

Avoid these time sinks:

• Do not start with Invoke-WebRequest, curl, or plain requests for the actual query. They can return TLS errors, 403, 202, or obfuscated anti-bot JavaScript instead of results.
• Do not treat an HTTP 202 page with FxJzG50F...js as search results.
• Do not rely on the in-app Browser if the page navigation repeatedly times out. Switch to local Playwright with a known Chromium executable path.
• Do not print Chinese query text through a GBK PowerShell pipeline without UTF-8 handling. If the filled input becomes replacement question marks, the site returns the latest global records, not the intended keyword results.
• Do not assume the homepage submit worked. Confirm that the result page body contains the keyword or that every extracted row matches the intended keyword/CTR.
• Do not parse the first table from the unfiltered latest-records page; always verify the pagination count and row content.
• Do not use search-engine fallbacks until the official list/detail path has failed. Fallback pages may be stale and can disagree with current official status.
• Do not click every result manually if the row exposes id and name; construct the detail URL directly and open it in the same browser context.
• Do not wait for domcontentloaded or networkidle if navigation is already committed; this site often has long-running scripts.

Browser Plugin Fallback

If using the Codex in-app Browser:

1. Follow the Browser skill setup.
2. Keep navigation timeouts short and poll URL/title/DOM.
3. If tab.goto() hangs twice or the session times out before a DOM snapshot, stop using it and switch to local Playwright.
4. If the site opens but the search produces latest global records, suspect keyword encoding or submit failure.

Fallback Sources

Use fallback sources only to fill gaps after official browser extraction fails.

Good fallback searches:

• exact 登记号 plus 首次公示信息日期
• exact 登记号 plus 申请人名称
• exact trial title plus 药物临床试验登记与信息公示平台

When using fallback data, state which fields were supplemented from non-official sources.

Output Checklist

Before finalizing:

• Confirm the official result count from the list page.
• Ensure every row has all 9 required fields.
• Preserve official Chinese status text, for example 进行中 尚未招募, 已完成, 主动终止.
• Use absolute Markdown links for official detail pages.
• State the query date when useful.
• If a detail field cannot be verified, write 未核实 and briefly state the gap.