Re: ACFinder 140106test exeのみ

このトピックの投稿一覧へ

なし Re: ACFinder 140106test exeのみ

msg# 1.3.1.1.1.1.1.2.1.1.1.1.1
depth:
12
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2014.01.07 16:00
OhYeah!  管理人   投稿数: 983 オンライン
薬剤タブで、RAC 関係がうまく検索できないことがあります。kihon ビューを下記のように変更し、薬剤候補の検索を単純化したところ、意図通りに検索できるようになりました。

kihon view
CREATE TEMP VIEW kihon AS SELECT
  bango, shurui, meisho, tsusho, ryakusho, ippanmei, a.seibun AS seibun, nodo, kongo, zaikei, yoto,
  CONCAT('・',
    (select koka from koka where koka.kokaid = b.kokaid & 3),
    (select koka from koka where koka.kokaid = b.kokaid & 4),
    (select koka from koka where koka.kokaid = b.kokaid & 8),
    (select koka from koka where koka.kokaid = b.kokaid & 16),
    (select koka from koka where koka.kokaid = b.kokaid & 32),
    (select koka from koka where koka.kokaid = b.kokaid & 64),
    (select koka from koka where koka.kokaid = b.kokaid & 128),
    (select koka from koka where koka.kokaid = b.kokaid & 256),
    (select koka from koka where koka.kokaid = b.kokaid & 512),
    (select koka from koka where koka.kokaid = b.kokaid & 1024),
    (select koka from koka where koka.kokaid = b.kokaid & 2048),
    (select koka from koka where koka.kokaid = b.kokaid & 4096),
    (select koka from koka where koka.kokaid = b.kokaid & 8192),
    (select koka from koka where koka.kokaid = b.kokaid & 16384),
    (select koka from koka where koka.kokaid = b.kokaid & 32768)
  ) AS koka,
  iso, b.keito as keito, c.keito as RAC系統, mid, sayoten, sayokiko, fgroup, risk
FROM seibun AS a
LEFT JOIN m_kihon USING(bango)
LEFT JOIN iso USING(ippanmei)
LEFT JOIN bunrui AS b ON a.ippanmei = b.seibun
LEFT JOIN rac AS c USING(ippanmei);


薬剤候補検索
SELECT DISTINCT tsusho FROM kihon
WHERE concat('$',tsusho,shurui,keito,koka,iso,RAC系統,mid,sayoten, sayokiko) MATCH '%...%'
ORDER BY tsusho
SELECT DISTINCT bango,meisho FROM kihon
WHERE concat(' ',tsusho,shurui,keito,koka,iso,RAC系統,mid,sayoten, sayokiko) MATCH '%...%'
ORDER BY bango

投票数:2 平均点:5.00

投稿ツリー

  条件検索へ