1"use strict";(self.webpackChunktemp=self.webpackChunktemp||[]).push([[5526],{493:(e,n,c)=>{c.d(n,{A:()=>l});const l=c.p+"assets/files/qal-validation-363e314c3d658c865ad76b925a0ebe60.yaml"},4261:(e,n,c)=>{c.r(n),c.d(n,{assets:()=>o,contentTitle:()=>r,default:()=>x,frontMatter:()=>s,metadata:()=>l,toc:()=>h});const l=JSON.parse('{"id":"developer-manual/for-ai/for-ai-index","title":"AI \u5411\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3","description":"QA ZERO API \u306b\u5bfe\u3057\u3066 QAL \u30af\u30a8\u30ea\u3092\u7d44\u307f\u7acb\u3066\u308b AI \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5411\u3051\u306e\u6700\u5c0f\u30eb\u30fc\u30eb\u96c6\u3068\u6a5f\u68b0\u53ef\u8aad\u4ed5\u69d8","source":"@site/i18n/ja/docusaurus-plugin-content-docs/current/developer-manual/for-ai/index.md","sourceDirName":"developer-manual/for-ai","slug":"/developer-manual/for-ai","permalink":"/ja/docs/developer-manual/for-ai","draft":false,"unlisted":false,"tags":[],"version":"current","sidebarPosition":7,"frontMatter":{"id":"for-ai-index","slug":"/developer-manual/for-ai","title":"AI \u5411\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3","sidebar_label":"For AI (Instructions & Spec)","sidebar_position":7,"description":"QA ZERO API \u306b\u5bfe\u3057\u3066 QAL \u30af\u30a8\u30ea\u3092\u7d44\u307f\u7acb\u3066\u308b AI \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5411\u3051\u306e\u6700\u5c0f\u30eb\u30fc\u30eb\u96c6\u3068\u6a5f\u68b0\u53ef\u8aad\u4ed5\u69d8","audience":"ai"},"sidebar":"developerManualSidebar","previous":{"title":"API \u4e92\u63db\u6027","permalink":"/ja/docs/developer-manual/api/api-compatibility"},"next":{"title":"\u9023\u643a","permalink":"/ja/docs/developer-manual/integrations"}}');var i=c(4848),d=c(8453);const s={id:"for-ai-index",slug:"/developer-manual/for-ai",title:"AI \u5411\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3",sidebar_label:"For AI (Instructions & Spec)",sidebar_position:7,description:"QA ZERO API \u306b\u5bfe\u3057\u3066 QAL \u30af\u30a8\u30ea\u3092\u7d44\u307f\u7acb\u3066\u308b AI \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5411\u3051\u306e\u6700\u5c0f\u30eb\u30fc\u30eb\u96c6\u3068\u6a5f\u68b0\u53ef\u8aad\u4ed5\u69d8",audience:"ai"},r="AI \u5411\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3 \u2014 QA ZERO API / QAL",o={},h=[{value:"1. \u3053\u306e API \u306f\u4f55\u304b",id:"1-\u3053\u306e-api-\u306f\u4f55\u304b",level:2},{value:"2. \u4f7f\u3046\u3053\u3068\u306b\u306a\u308b2\u3064\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8",id:"2-\u4f7f\u3046\u3053\u3068\u306b\u306a\u308b2\u3064\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8",level:2},{value:"3. Version \u3068 update",id:"3-version-\u3068-update",level:2},{value:"4. QAL \u306e\u5f62 (\u6700\u5c0f\u6709\u52b9\u30af\u30a8\u30ea)",id:"4-qal-\u306e\u5f62-\u6700\u5c0f\u6709\u52b9\u30af\u30a8\u30ea",level:2},{value:"4.1 \u6700\u5c0f\u306e\u52d5\u4f5c\u4f8b",id:"41-\u6700\u5c0f\u306e\u52d5\u4f5c\u4f8b",level:3},{value:"4.2 \u3088\u304f\u3042\u308b\u9593\u9055\u3044",id:"42-\u3088\u304f\u3042\u308b\u9593\u9055\u3044",level:3},{value:"5. \u5b88\u308b\u3079\u304d\u30eb\u30fc\u30eb",id:"5-\u5b88\u308b\u3079\u304d\u30eb\u30fc\u30eb",level:2},{value:"6. \u30de\u30c6\u30ea\u30a2\u30eb\u306e\u9078\u3073\u65b9",id:"6-\u30de\u30c6\u30ea\u30a2\u30eb\u306e\u9078\u3073\u65b9",level:2},{value:"7. JOIN \u30eb\u30fc\u30eb",id:"7-join-\u30eb\u30fc\u30eb",level:2},{value:"8. Filter, calc, sort \u2014 \u5b89\u5168\u306a\u8868\u9762",id:"8-filter-calc-sort--\u5b89\u5168\u306a\u8868\u9762",level:2},{value:"8.1 <code>calc</code> \u3068\u5217\u5ba3\u8a00\uff082026-05-11 \u304b\u3089\uff09",id:"81-calc-\u3068\u5217\u5ba3\u8a002026-05-11-\u304b\u3089",level:3},{value:"8.2 <code>join.on.left</code> / <code>join.on.right</code> \u30eb\u30fc\u30eb\uff082026-05-11 \u304b\u3089\uff09",id:"82-joinonleft--joinonright-\u30eb\u30fc\u30eb2026-05-11-\u304b\u3089",level:3},{value:"9. \u3084\u3063\u3066 <strong>\u3044\u3051\u306a\u3044</strong> \u3053\u3068",id:"9-\u3084\u3063\u3066-\u3044\u3051\u306a\u3044-\u3053\u3068",level:2},{value:"10. \u8ff7\u3063\u305f\u3089",id:"10-\u8ff7\u3063\u305f\u3089",level:2}];function j(e){const n={a:"a",admonition:"admonition",code:"code",h1:"h1",h2:"h2",h3:"h3",header:"header",hr:"hr",li:"li",ol:"ol",p:"p",pre:"pre",strong:"strong",ul:"ul",...(0,d.R)(),...e.components};return(0,i.jsxs)(i.Fragment,{children:[(0,i.jsx)(n.header,{children:(0,i.jsx)(n.h1,{id:"ai-\u5411\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3--qa-zero-api--qal",children:"AI \u54
111\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3 \u2014 QA ZERO API / QAL"})}),"\n",(0,i.jsxs)(n.admonition,{title:"\u6a5f\u68b0\u53ef\u8aad\u4ed5\u69d8",type:"note",children:[(0,i.jsxs)(n.p,{children:["\u3053\u306e\u30da\u30fc\u30b8\u306f\u30d0\u30fc\u30b8\u30e7\u30f3\u975e\u4f9d\u5b58\u306e AI \u5411\u3051\u30a4\u30f3\u30b9\u30c8\u30e9\u30af\u30b7\u30e7\u30f3\u3067\u3059\u3002\u6b63\u672c\u306e\n\u6a5f\u68b0\u53ef\u8aad\u4ed5\u69d8\u306f\u3053\u306e\u96a3\u3067\u914d\u5e03\u3055\u308c\u3001",(0,i.jsx)(n.code,{children:"/guide"})," \u304c AI / MCP \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306b\n\u914d\u4fe1\u3059\u308b\u3082\u306e\u3067\u3059:"]}),(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:(0,i.jsx)(n.a,{target:"_blank","data-noBrokenLinkCheck":!0,href:c(9915).A+"",children:(0,i.jsx)(n.code,{children:"materials.yaml"})})})," \u2014 ",(0,i.jsx)(n.code,{children:"since:"})," \u30bf\u30b0\u3064\u304d\u306e\n\u30de\u30c6\u30ea\u30a2\u30eb / \u30ab\u30e9\u30e0\u5168\u30ab\u30bf\u30ed\u30b0\uff08\u30d0\u30fc\u30b8\u30e7\u30f3\u975e\u4f9d\u5b58\u30fb\u30ea\u30d3\u30f3\u30b0\uff09\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:(0,i.jsx)(n.code,{children:"qal-validation.yaml"})})," \u2014 \u6a5f\u80fd\u30d5\u30e9\u30b0\u3068\u30d0\u30ea\u30c7\u30fc\u30bf\u4ed5\u69d8\u3067\u3001\n",(0,i.jsx)(n.strong,{children:"\u30d0\u30fc\u30b8\u30e7\u30f3\u56fa\u5b9a"})," \u3067\u3059\u3002\u5bfe\u8c61\u3068\u3059\u308b\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u914d\u4e0b\u306e\u30b3\u30d4\u30fc\u3092\n\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002\u4f8b:\n",(0,i.jsx)(n.a,{target:"_blank","data-noBrokenLinkCheck":!0,href:c(493).A+"",children:(0,i.jsx)(n.code,{children:"2026-05-11/qal-validation.yaml"})}),"\u3002"]}),"\n"]})]}),"\n",(0,i.jsxs)(n.p,{children:["\u3042\u306a\u305f\u304c\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u8aad\u3093\u3067\u3044\u308b\u306e\u306f\u3001\u3042\u306a\u305f\u304c AI \u30a2\u30b7\u30b9\u30bf\u30f3\u30c8 (LLM, MCP \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u7b49) \u3067\u3001",(0,i.jsx)(n.strong,{children:"QA ZERO API"})," \u7528\u306e\u30af\u30a8\u30ea\u3092\u7d44\u307f\u7acb\u3066\u3066\u3044\u308b\u304b\u3089\u3067\u3059\u3002\u30af\u30a8\u30ea\u3092\u66f8\u304f\u524d\u306b\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u5168\u90e8\u8aad\u3093\u3067\u304f\u3060\u3055\u3044\u3002\u4e26\u3093\u3067\u3044\u308b2\u672c\u306e YAML \u30d5\u30a1\u30a4\u30eb (",(0,i.jsx)(n.code,{children:"materials.yaml"}),", ",(0,i.jsx)(n.code,{children:"qal-validation.yaml"}),") \u304c ",(0,i.jsx)(n.strong,{children:"\u6b63\u672c\u306e\u4ed5\u69d8\u66f8"})," \u3067\u3059\u3002\u3053\u306eREADME\u3068 YAML \u304c\u98df\u3044\u9055\u3046\u5834\u5408\u306f\u5e38\u306b YAML \u3092\u4fe1\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002"]}),"\n",(0,i.jsxs)(n.p,{children:["\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u610f\u56f3\u7684\u306b\u77ed\u304f\u4fdd\u305f\u308c\u3066\u3044\u307e\u3059\u3002",(0,i.jsx)(n.strong,{children:"\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002"})," \u5b88\u308b\u3079\u304d\u30eb\u30fc\u30eb\u3068\u5f62\u306e\u96c6\u5408\u3067\u3059\u3002"]}),"\n",(0,i.jsx)(n.hr,{}),"\n",(0,i.jsx)(n.h2,{id:"1-\u3053\u306e-api-\u306f\u4f55\u304b",children:"1. \u3053\u306e API \u306f\u4f55\u304b"}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:["\u8aad\u307f\u53d6\u308a\u5c02\u7528\u306e\u5206\u6790 API \u3067\u3059\u3002",(0,i.jsx)(n.strong,{children:"QAL \u30af\u30a8\u30ea"})," (\u69cb\u9020\u5316 JSON) \u3092\u9001\u4fe1\u3059\u308b\u3068\u3001\u8868\u5f62\u5f0f\u306e\u7d50\u679c\u304c\u8fd4\u308a\u307e\u3059\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:["QAL \u306f ",(0,i.jsx)(n.strong,{children:"SQL \u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002"})," \u610f\u56f3\u7684\u306b\u5c0f\u3055\u3044\u5ba3\u8a00\u578b\u8a00\u8a9e\u3067\u3001AI \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u30ea\u30c8\u30e9\u30a4\u3092\u5fc5\u8981\u3068\u305b\u305a\u3001\u304b\u3064\u88cf\u306e\u30b9\u30c8\u30a2\u3092\u50b7\u3064\u3051\u308b\u3088\u3046\u306a\u30af\u30a8\u30ea\u3092\u6c7a\u3057\u3066\u7d44\u307f\u7acb\u3066\u3089\u308c\u306a\u3044\u3088\u3046\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002"]}),"\n",(0,i.jsx)(n.li,{children:"\u5bfe\u8c61\u306e\u30c7\u30d7\u30ed\u30a4\u5148\u306f\u5b89\u4fa1\u306a\u30b7\u30a7\u30a2\u30fc\u30c9\u30db\u30b9\u30c6\u30a3\u30f3\u30b0\u3067\u3059 \u2014 \u3053\u306e API \u306f\u3001\u30af\u30e9\u30a6\u30c9 DWH \u3067\u306f\u306a\u304f\u3001\u5b89\u4fa1\u306a\u30a4\u30f3\u30d5\u30e9\u4e0a\u3067\u7d20\u65e9\u304f\u7d50\u679c\u3092\u8fd4\u3059\u3088\u3046\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002"}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"2-\u4f7f\u3046\u3053\u3068\u306b\u306a\u308b2\u3064\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8",children:"2. \u4f7f\u3046\u3053\u3068\u306b\u306a\u308b2\u3064\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8"}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"GET /wp-json/qa-platform/guide"})," \u2014 \u3053\u306e\u30d5\u30a1\u30a4\u30eb\u30012\u672c\u306e YAML \u4ed5\u69d8\u66f8\u3001\u4f7f\u3048\u308b tracking_id\u3001\u6a5f\u80fd\u30d5\u30e9\u30b0\u3092\u8fd4\u3059\u3002\u4f55\u304c\u73fe\u5728\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u77e5\u308b\u305f\u3081\u306b ",(0,i.jsx)(n.strong,{children:"\u6700\u521d\u306b"})," \u547c\u3073\u307e\u3059\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"POST /wp-json/qa-platform/query"}
1)," \u2014 JSON \u30dc\u30c7\u30a3\u3067 QAL \u30af\u30a8\u30ea\u3092\u53d7\u3051\u53d6\u308a\u3001\u884c\u3092\u8fd4\u3059\u3002"]}),"\n"]}),"\n",(0,i.jsx)(n.p,{children:"\u4ed6\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306f AI \u7528\u9014\u306e\u5bfe\u8c61\u5916\u3067\u3059\u3002"}),"\n",(0,i.jsx)(n.h2,{id:"3-version-\u3068-update",children:"3. Version \u3068 update"}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:(0,i.jsx)(n.code,{children:"version"})})," (",(0,i.jsx)(n.code,{children:"YYYY-MM-DD"}),") \u2014 \u7834\u58ca\u7684\u5909\u66f4\u6642\u3060\u3051\u5909\u308f\u308b\u3002URL \u306b pin \u3059\u308b: ",(0,i.jsx)(n.code,{children:"?version=2026-05-11"}),"\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:(0,i.jsx)(n.code,{children:"update"})})," (",(0,i.jsx)(n.code,{children:"YYYY-MM-DD"}),") \u2014 \u540c\u4e00\u30d0\u30fc\u30b8\u30e7\u30f3\u5185\u306e\u975e\u7834\u58ca\u8ffd\u52a0\u3067 bump\u3002",(0,i.jsx)(n.code,{children:"/guide"})," \u30ec\u30b9\u30dd\u30f3\u30b9\u306b ",(0,i.jsx)(n.code,{children:"api_update"})," \u3068\u3057\u3066\u8fd4\u3055\u308c\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:["\u5404\u6a5f\u80fd\u30fb\u5404\u30d5\u30a3\u30fc\u30eb\u30c9\u306f ",(0,i.jsx)(n.code,{children:"since: YYYY-MM-DD"})," \u30bf\u30b0\u3092\u6301\u3066\u307e\u3059\u3002",(0,i.jsx)(n.code,{children:"since > client.known_update"})," \u306a\u3089\u3001\u30b5\u30fc\u30d0\u30fc\u3067\u305d\u306e\u6a5f\u80fd\u304c\u307e\u3060\u5b58\u5728\u3057\u306a\u3044\u53ef\u80fd\u6027\u304c\u3042\u308b\u306e\u3067 ",(0,i.jsx)(n.strong,{children:"\u30d5\u30a9\u30fc\u30eb\u30d0\u30c3\u30af"})," \u3059\u308b\u3053\u3068\u3002\u30a8\u30e9\u30fc\u306b\u3057\u306a\u3044\u3002"]}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"4-qal-\u306e\u5f62-\u6700\u5c0f\u6709\u52b9\u30af\u30a8\u30ea",children:"4. QAL \u306e\u5f62 (\u6700\u5c0f\u6709\u52b9\u30af\u30a8\u30ea)"}),"\n",(0,i.jsx)(n.p,{children:"\u6709\u52b9\u306a QAL \u30af\u30a8\u30ea\u306f\u5e38\u306b\u4ee5\u4e0b\u306e\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u30ad\u30fc\u3092\u6301\u3061\u307e\u3059\u3002"}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"tracking_id"})," \u2014 ",(0,i.jsx)(n.code,{children:"/guide"})," \u304c\u8fd4\u3059\u30b5\u30a4\u30c8\u8b58\u5225\u5b50\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"materials"})," \u2014 \u3053\u306e\u30af\u30a8\u30ea\u304c\u8aad\u3080\u30de\u30c6\u30ea\u30a2\u30eb\u4e00\u89a7\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"time"})," \u2014 ",(0,i.jsx)(n.code,{children:"{ start, end, tz }"}),"\u3002",(0,i.jsx)(n.code,{children:"start"}),"/",(0,i.jsx)(n.code,{children:"end"})," \u306f ISO-8601\u3001",(0,i.jsx)(n.code,{children:"tz"})," \u306f IANA \u30bf\u30a4\u30e0\u30be\u30fc\u30f3 (\u4f8b: ",(0,i.jsx)(n.code,{children:"Asia/Tokyo"}),")\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"make"})," \u2014 \u540d\u524d\u4ed8\u304d\u30d3\u30e5\u30fc\u306e\u30de\u30c3\u30d7\u3002\u5404\u30d3\u30e5\u30fc\u306f ",(0,i.jsx)(n.code,{children:"from"})," (\u30de\u30c6\u30ea\u30a2\u30eb) \u3068 ",(0,i.jsx)(n.code,{children:"keep"})," (\u9078\u3076\u30ab\u30e9\u30e0) \u3092\u6301\u3064\u3002\u30aa\u30d7\u30b7\u30e7\u30f3: ",(0,i.jsx)(n.code,{children:"filter"}),", ",(0,i.jsx)(n.code,{children:"join"}),", ",(0,i.jsx)(n.code,{children:"add"}),"/",(0,i.jsx)(n.code,{children:"calc"}),", ",(0,i.jsx)(n.code,{children:"sort"}),"\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"result"})," \u2014 \u3069\u306e\u30d3\u30e5\u30fc\u3092\u3069\u3046\u8fd4\u3059\u304b\u3002",(0,i.jsx)(n.code,{children:"use"}),", ",(0,i.jsx)(n.code,{children:"limit"}),", ",(0,i.jsx)(n.code,{children:"count_only"})," \u3092\u30b5\u30dd\u30fc\u30c8\u3002"]}),"\n"]}),"\n",(0,i.jsx)(n.p,{children:"\u4ed6\u306e\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u30ad\u30fc\u306f\u30df\u30b9\u3067\u3059\u3002\u30d0\u30ea\u30c7\u30fc\u30bf\u304c\u62d2\u5426\u3057\u307e\u3059\u3002"}),"\n",(0,i.jsx)(n.h3,{id:"41-\u6700\u5c0f\u306e\u52d5\u4f5c\u4f8b",children:"4.1 \u6700\u5c0f\u306e\u52d5\u4f5c\u4f8b"}),"\n",(0,i.jsxs)(n.p,{children:["\u307e\u305a\u3053\u306e\u5f62\u3092\u30b3\u30d4\u30fc\u3057\u3066\u3001\u305d\u3053\u304b\u3089\u8abf\u6574\u3057\u3066\u304f\u3060\u3055\u3044\u3002QAL \u30af\u30a8\u30ea\u5168\u4f53\u306f\n",(0,i.jsx)(n.code,{children:"/query"})," \u306b POST \u3059\u308b\u969b\u3001\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u306e ",(0,i.jsx)(n.code,{children:"qal"})," \u30ad\u30fc\u3067\u30e9\u30c3\u30d7\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002"]}),"\n",(0,i.jsx)(n.pre,{children:(0,i.jsx)(n.code,{className:"language-json",children:'{\n "qal": {\n "tracking_id": "<guide \u304c\u8fd4\u3059 id>",\n "materials": [{"name": "allpv"}],\n "time": {\n "start": "2026-04-01T00:00:00",\n "end": "2026-04-14T00:00:00",\n "tz": "Asia/Tokyo"\n },\n "make": {\n "top": {\n "from": ["allpv"],\n "keep": ["allpv.url"],\n "calc": {"views": "COUNT(allpv.pv_id)"},\n "sort": {"by": "views", "order": "desc", "top": 5}\n }\n },\n "result": {"use": "top"}\n }\n}\n'})}),"\n",(0,i.jsxs)(n.p,{children:["\u3053\u308c\u306f\u6307\u5b9a\u671f\u9593\u306e\u30da\u30fc\u30b8\u30d3\u30e5\u30fc\u6570\u4e0a\u4f4d5\u4ef6\u306e URL \u3092\u8fd4\u3057\u307e\u3059\u3002\u4ed6\u306e\u30af\u30a8\u30ea\u306e\u5f62\u306f\n\u5168\u3066\u3053\u306e\u9aa8\u7d44\u307f\u306e\u30d0\u30ea\u30a8\u30fc\u30b7\u30e7\u30f3\u3067\u3059 \u2014 \u30de\u30c6\u30ea\u30a2\u30eb\u3001",(0,i.jsx)(n.code,{children:"keep"})," \u306e\u30ab\u30e9\u30e0\u3001",(0,i.jsx)(n.code,{children:"calc"})," \u306e\n\u96c6\u8a08\u95a2\u6570\u3092\u5909\u3048\u308b\u3060\u3051\u3002"]}
1),"\n",(0,i.jsx)(n.p,{children:"\u30ec\u30b9\u30dd\u30f3\u30b9\u306e\u5f62\u306f\u4ee5\u4e0b:"}),"\n",(0,i.jsx)(n.pre,{children:(0,i.jsx)(n.code,{className:"language-json",children:'{\n "data": [ /* \u884c\u306e\u914d\u5217 */ ],\n "meta": { "total_count": 0, "returned_count": 0, "limit": 1000 }\n}\n'})}),"\n",(0,i.jsxs)(n.p,{children:["\u5404\u53e5\u306e\u6b63\u5f0f\u306a\u5f62\u306f ",(0,i.jsx)(n.code,{children:"qal-validation.yaml"})," \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044 \u2014 \u3053\u306e\u4f8b\u306f\n\u89aa\u3057\u307f\u3084\u3059\u3044\u5165\u308a\u53e3\u3067\u3042\u3063\u3066\u3001\u4ed5\u69d8\u66f8\u305d\u306e\u3082\u306e\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002"]}),"\n",(0,i.jsx)(n.h3,{id:"42-\u3088\u304f\u3042\u308b\u9593\u9055\u3044",children:"4.2 \u3088\u304f\u3042\u308b\u9593\u9055\u3044"}),"\n",(0,i.jsx)(n.p,{children:"\u4ee5\u4e0b\u306e5\u3064\u3067\u521d\u56de\u5931\u6557\u306e\u307b\u307c\u5168\u3066\u3092\u8aac\u660e\u3067\u304d\u307e\u3059\u3002\u30af\u30a8\u30ea\u304c\u5f3e\u304b\u308c\u305f\u3089\u3001\u307e\u305a\u3053\u3053\u3092\n\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002"}),"\n",(0,i.jsxs)(n.ol,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:["POST \u30dc\u30c7\u30a3\u306f\u30af\u30a8\u30ea\u3092 ",(0,i.jsx)(n.code,{children:'{"qal": ...}'})," \u3067\u30e9\u30c3\u30d7\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002"]}),"\n",(0,i.jsx)(n.code,{children:"/query"})," \u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306f\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u306e ",(0,i.jsx)(n.code,{children:"qal"})," \u30d5\u30a3\u30fc\u30eb\u30c9\u304b\u3089\u30af\u30a8\u30ea\u3092\u8aad\u3080\u3002\n\u30e9\u30c3\u30d7\u305b\u305a\u306b QAL \u672c\u4f53\u3092\u76f4\u63a5\u30eb\u30fc\u30c8\u306b\u7f6e\u304f\u3068\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u304c\u5931\u6557\u3059\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"from"})," \u306f\u914d\u5217\u3067\u3001\u6587\u5b57\u5217\u3067\u306f\u306a\u3044\u3002"]})," ",(0,i.jsx)(n.code,{children:'"from": ["allpv"]'})," \u3068\u66f8\u304f\u3002\n",(0,i.jsx)(n.code,{children:'"from": "allpv"'})," \u3067\u306f\u306a\u3044\u3002\u30bd\u30fc\u30b9\u304c1\u3064\u3067\u3082 ",(0,i.jsx)(n.code,{children:"[...]"})," \u3067\u30e9\u30c3\u30d7\u3059\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"keep"})," \u306e\u30a8\u30f3\u30c8\u30ea\u306f ",(0,i.jsx)(n.code,{children:"<material>.<column>"})," \u306e\u5f62\u3067\u4fee\u98fe\u3059\u308b\u3002"]}),"\n",(0,i.jsx)(n.code,{children:'"keep": ["allpv.url"]'})," \u3068\u66f8\u304f\u3002",(0,i.jsx)(n.code,{children:'"keep": ["url"]'})," \u3067\u306f\u306a\u3044\u3002\n\u30ab\u30e9\u30e0\u540d\u3092\u88f8\u3067\u66f8\u304f\u3068 ",(0,i.jsx)(n.code,{children:"E_UNKNOWN_COLUMN"})," \u3067\u62d2\u5426\u3055\u308c\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"calc"})," \u306e\u5024\u306f ",(0,i.jsx)(n.code,{children:"FUNC(material.column)"})," \u5f62\u5f0f\u306e\u6587\u5b57\u5217\u5f0f\u3002"]}),"\n",(0,i.jsx)(n.code,{children:'"calc": {"views": "COUNT(allpv.pv_id)"}'})," \u3068\u66f8\u304f\u3002\n",(0,i.jsx)(n.code,{children:'"calc": {"views": "COUNT(*)"}'})," \u3082\n",(0,i.jsx)(n.code,{children:'"calc": {"views": {"count": "*"}}'})," \u3082\u7121\u52b9\u3002",(0,i.jsx)(n.code,{children:"*"})," \u306f\u3053\u3053\u3067\u306f\u6709\u52b9\u306a\n\u30ab\u30e9\u30e0\u53c2\u7167\u3067\u306f\u306a\u304f\u3001\u5b9f\u5728\u306e\u30ab\u30e9\u30e0\u540d\u3092\u6307\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002\u8a31\u53ef\u3055\u308c\u305f\u95a2\u6570\u306f\n",(0,i.jsx)(n.code,{children:"qal-validation.yaml"})," \u306b\u5217\u6319\u3055\u308c\u3066\u3044\u308b (\u73fe\u5728\u306f ",(0,i.jsx)(n.code,{children:"COUNT"}),", ",(0,i.jsx)(n.code,{children:"COUNTUNIQUE"}),",\n",(0,i.jsx)(n.code,{children:"SUM"}),", ",(0,i.jsx)(n.code,{children:"AVERAGE"}),", ",(0,i.jsx)(n.code,{children:"MIN"}),", ",(0,i.jsx)(n.code,{children:"MAX"}),")\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"sort"})," \u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3001\u914d\u5217\u3067\u306f\u306a\u3044\u3002"]}),"\n",(0,i.jsx)(n.code,{children:'"sort": {"by": "views", "order": "desc", "top": 5}'})," \u3068\u66f8\u304f\u3002\n",(0,i.jsx)(n.code,{children:'"sort": [{"column": "views", "direction": "desc"}]'})," \u3067\u306f\u306a\u3044\u3002\n\u30ad\u30fc\u306f ",(0,i.jsx)(n.code,{children:"by"})," (\u5fc5\u9808\u3001\u6587\u5b57\u5217)\u3001",(0,i.jsx)(n.code,{children:"order"})," (",(0,i.jsx)(n.code,{children:'"asc"'})," \u304b ",(0,i.jsx)(n.code,{children:'"desc"'}),"\u3001\u5fc5\u9808)\u3001\n",(0,i.jsx)(n.code,{children:"top"})," (\u30aa\u30d7\u30b7\u30e7\u30f3\u3001\u6b63\u306e\u6574\u6570 \u2014 top-N \u30af\u30a8\u30ea\u3067\u884c\u6570\u3092\u5236\u9650\u3059\u308b\u306b\u306f\n",(0,i.jsx)(n.code,{children:"result.limit"})," \u306e\u4ee3\u308f\u308a\u306b\u3053\u308c\u3092\u4f7f\u3046)\u3002"]}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"5-\u5b88\u308b\u3079\u304d\u30eb\u30fc\u30eb",children:"5. \u5b88\u308b\u3079\u304d\u30eb\u30fc\u30eb"}),"\n",(0,i.jsxs)(n.ol,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:["\u6700\u521d\u306e\u30af\u30a8\u30ea\u306e\u524d\u306b\u5fc5\u305a ",(0,i.jsx)(n.code,{children:"/guide"})," \u3092\u547c\u3076\u3053\u3068\u3002"]})," tracking_id\u3001\u30de\u30c6\u30ea\u30a2\u30eb\u3001\u6a5f\u80fd\u306e\u30b5\u30dd\u30fc\u30c8\u72b6\u6cc1\u3092\u63a8\u6e2c\u3057\u306a\u3044\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"\u30ab\u30e9\u30e0\u3092\u767a\u660e\u3057\u306a\u3044\u3053\u3068\u3002"})," \u5bfe\u8c61\u30de\u30c6\u30ea\u30a2\u30eb\u306e ",(0,i.jsx)(n.code,{children:"materials.yaml"})," \u306b\u5b58\u5728\u3059\u308b\u30ab\u30e9\u30e0\u3060\u3051\u3092\u4f7f\u3046\u3002\u30e6\u30fc\u30b6\u30fc\u304c\u5b58\u5728\u3057\u306a\u3044\u30ab\u30e9\u30e0\u3092\u8981\u6c42\u3057\u305f\u3089\u3001\u4f5c\u308a\u4e0a\u3052\u305a\u306b\u300c\u7121\u3044\u300d\u3068\u8a00\u3046\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"time"})," \u306f\u5e38\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3002"]})," \u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u6642\u9593\u7bc4\u56f2\u306f\u306a\u3044\u3002",(0,i.jsx)(n.code,{children:"time"})," \u7121\u3057\u306e\u30af\u30a8\u30ea\u306f\u62d2\u5426\u3055\u308c\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"result.use"})," \u306f\u5e38\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3002"]})," ",(0,i.jsx)(n.code,{children:"make"})," \u3067\u5b9a\u7fa9\u3057\u305f\u30d3\u30e5\u30fc\u3092\u53c2\u7167\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002\u672a\u5b9a\u7fa9\u306e\u30d3\u30e5\u30fc\u53c2\u7167\u306f ",(0,i.jsx)(n.code,{children:"E_UNKNOWN_VIEW"})," \u3092\u8fd4\u3059\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"count_only: true"})," \u3067\u306a\u3044\u9650\u308a ",(0,i.jsx)(n.code,{children:"result.limit"})," \u3092\u5fc5\u305a\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3002"]})," \u5b9f\u884c\u30b3\u30b9\u30c8\u3092\u4e88\u6e2c\u53ef\u80fd\u306b\u4fdd\u3064\u65b9\u6cd5\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"\u540c\u3058\u540d\u524d\u306e\u30d3\u30e5\u30fc\u30922\u3064\u7f6e\u304b\u306a\u3044\u3053\u3068\u3002"})," ",(0,i.jsx)(n.code,{children:"make"})," \u5185\u3067\u30d3\u30e5\u30fc\u540d\u306f\u30e6\u30cb\u30fc\u30af\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"enabled"})," \u304c ",(0,i.jsx)(n.code,{children:"false"})," \u306e\u6a5f\u80fd\u3092\u8981\u6c42\u3057\u306a\u3044\u3053\u3068\u3002"]})," ",(0,i.jsx)(n.code,{children:"/guide"})," \u306e ",(0,i.jsx)(n.code,{children:"features_detail"})," \u30de\u30c3\u30d7\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\u3002\u7121\u52b9\u306a\u6a5f\u80fd\u3092\u8981\u6c42\u3059\u308b\u306e\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5074\u306e\u30d0\u30b0\u3067\u3001\u30b5\u30fc\u30d0\u30fc\u5074\u306e\u30d0\u30b0\u3067\u306f\u306a\u3044\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsxs)(n.strong,{children:["\u4f55\u304b\u304c\u5931\u6557\u3057\u305f\u3089 ",(0,i.jsx)(n.code,{children:"/guide"})," \u3092\u8aad\u307f\u76f4\u3059\u3053\u3068\u3002"]})," \u30ad\u30e3\u30c3\u30b7\u30e5\u3055\u308c\u305f\u77e5\u8b58\u3068\u5b9f\u969b\u306e\u30c7\u30d7\u30ed\u30a4\u72b6\u614b\u306e\u9593\u3067\u30eb\u30fc\u30eb\u304c\u52d5\u3044\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\u3002"]}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"6-\u30de\u30c6\u30ea\u30a2\u30eb\u306e\u9078\u3073\u65b9",children:"6. \u30de\u30c6\u30ea\u30a2\u30eb\u306e\u9078\u3073\u65b9"}),"\n",(0,i.jsxs)(n.p,{children:["\u6b63\u672c\u306f ",(0,i.jsx)(n.code,{children:"materials.yaml"}),"\u3002\u7d20\u65e9\u3044\u624b\u5f15\u304d:"]}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"allpv"})," \u2014 1\u884c = 1\u30da\u30fc\u30b8\u30d3\u30e5\u30fc\u3002\u30c8\u30e9\u30d5\u30a3\u30c3\u30af\u3001\u30bb\u30c3\u30b7\u30e7\u30f3\u3001\u30ea\u30d5\u30a1\u30e9\u30fc\u3001\u30c7\u30d0\u30a4\u30b9\u3001\u30da\u30fc\u30b8\u4eba\u6c17\u5ea6\u306e\u8cea\u554f\u306f\u3053\u3053\u304b\u3089\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"click_event"})," \u2014 1\u884c = 1\u30af\u30ea\u30c3\u30af\u3002\u30af\u30ea\u30c3\u30af\u30b9\u30eb\u30fc\u7387\u3001\u30ec\u30a4\u30b8\u30af\u30ea\u30c3\u30af\u3001\u8981\u7d20\u30ec\u30d9\u30eb\u306e\u95a2\u5fc3\u5ea6\u306b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"gsc"})," \u2014 Google Search Console \u30c7\u30fc\u30bf\u3002\u691c\u7d22\u30af\u30a8\u30ea\u3001\u30a4\u30f3\u30d7\u30ec\u30c3\u30b7\u30e7\u30f3\u3001\u30aa\u30fc\u30ac\u30cb\u30c3\u30af CTR \u306b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"goal_N"})," \u2014 \u30b5\u30a4\u30c8\u3054\u3068\u306b\u8a2d\u5b9a\u3055\u308c\u305f conversion / goal \u30a4\u30d9\u30f3\u30c8\u3002\u30b3\u30f3\u30d0\u30fc\u30b8\u30e7\u30f3\u7387\u306e\u8cea\u554f\u306b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"page_version"})," \u2014 \u30da\u30fc\u30b8\u30d0\u30fc\u30b8\u30e7\u30f3\u30e1\u30bf\u30c7\u30fc\u30bf\u3002\u30b3\u30f3\u30c6\u30f3\u30c4\u5909\u66f4\u3084 A/B \u30c6\u30b9\u30c8\u306e\u30b9\u30e9\u30a4\u30b7\u30f3\u30b0\u306b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"datalayer_event"})," \u2014 \u30ab\u30b9\u30bf\u30e0 dataLayer \u30a4\u30d9\u30f3\u30c8\u3002\u30e6\u30fc\u30b6\u30fc\u304c\u660e\u793a\u7684\u306b dataLayer \u30a4\u30d9\u30f3\u30c8\u540d\u3092\u8a00\u53ca\u3057\u305f\u3068\u304d\u3060\u3051\u4f7f\u3046\u3002"]}),"\n"]}),"\n",(0,i.jsxs)(n.p,{children:["\u5168\u30ea\u30b9\u30c8\u3068\u5404\u30de\u30c6\u30ea\u30a2\u30eb\u306e\u30ab\u30e9\u30e0\u306f ",(0,i.jsx)(n.code,{children:"materials.yaml"})," \u306b\u3042\u308a\u307e\u3059\u3002\u30af\u30a8\u30ea\u3092\u51fa\u3059\u524d\u306b\u305d\u3053\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002"]}),"\n",(0,i.jsx)(n.h2,{id:"7-join-\u30eb\u30fc\u30eb",children:"7. JOIN \u30eb\u30fc\u30eb"}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"materials.yaml"})," \u306e ",(0,i.jsx)(n.code,{children:"join"})," \u30bb\u30af\u30b7\u30e7\u30f3\u306b\u5217\u6319\u3055\u308c\u3066\u3044\u308b\u30ad\u30fc\u3060\u3051\u304c JOIN \u30ad\u30fc\u306b\u4f7f\u3048\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:["1\u3064\u306e\u30d3\u30e5\u30fc\u306f ",(0,i.jsx)(n.code,{children:"from"})," \u30bd\u30fc\u30b9\u306e\u4e0a\u306b\u6700\u59271\u3064\u306e\u30de\u30c6\u30ea\u30a2\u30eb\u3092 JOIN \u3067\u304d\u308b\u30021\u30d3\u30e5\u30fc\u5185\u3067\u8907\u6570 JOIN \u3092\u9023\u9396\u3057\u306a\u3044 \u2014 \u5225\u306e\u30d3\u30e5\u30fc\u3092 ",(0,i.jsx)(n.code,{children:"make"})," \u306b\u4f5c\u3063\u3066 ",(0,i.jsx)(n.code,{children:"view_chaining"})," \u3067\u9023\u9396\u3059\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"pv_id"})," \u306f ",(0,i.jsx)(n.code,{children:"allpv"})," \u3068 ",(0,i.jsx)(n.code,{children:"click_event"})," \u9593\u306e\u6b63\u898f\u306e JOIN \u30ad\u30fc\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"session_id"})," \u306f\u8907\u6570\u30de\u30c6\u30ea\u30a2\u30eb\u306b\u307e\u305f\u304c\u308b\u30bb\u30c3\u30b7\u30e7\u30f3\u5358\u4f4d\u30e1\u30c8\u30ea\u30af\u30b9\u306e\u6b63\u898f JOIN \u30ad\u30fc\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"page_id"})," \u306f ",(0,i.jsx)(n.code,{children:"page_version"})," \u3068\u76f8\u95a2\u3059\u308b\u3068\u304d\u306e\u6b63\u898f JOIN \u30ad\u30fc\u3002"]}),"\n"]}),"\n",(0,i.jsxs)(n.p,{children:["\u4ed6\u306e ID \u3063\u307d\u3044\u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u5c06\u6765\u7528\u307e\u305f\u306f\u5185\u90e8\u7c3f\u8a18\u7528\u3067\u3059\u3002",(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"materials.yaml"})," \u306e ",(0,i.jsx)(n.code,{children:"join:"})," \u306b\u306a\u3044\u30ab\u30e9\u30e0\u3067 JOIN \u3057\u305f\u304f\u306a\u3063\u305f\u3089\u3001\u3084\u3081\u308b\u3053\u3068\u3002"]})]}),"\n",(0,i.jsx)(n.h2,{id:"8-filter-calc-sort--\u5b89\u5168\u306a\u8868\u9762",children:"8. Filter, calc, sort \u2014 \u5b89\u5168\u306a\u8868\u9762"}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"filter"})," \u306f\u30d5\u30e9\u30c3\u30c8\u306a ",(0,i.jsx)(n.code,{children:"{column: value}"})," \u307e\u305f\u306f ",(0,i.jsx)(n.code,{children:"{column: {op: value}}"})," \u3092\u53d7\u3051\u308b\u3002\u81ea\u7531\u5f62\u5f0f SQL \u306f\u7121\u3044\u3002\u751f\u306e\u5f0f\u306f\u7121\u3044\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"calc"})," \u306f\u30db\u30ef\u30a4\u30c8\u30ea\u30b9\u30c8\u5316\u3055\u308c\u305f\u95a2\u6570\u96c6\u5408\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u3002\u73fe\u5728\u306e\u30ea\u30b9\u30c8\u306f ",(0,i.jsx)(n.code,{children:"qal-validation.yaml"})," \u3092\u53c2\u7167\u3002\u95a2\u6570\u540d\u3092\u767a\u660e\u3057\u306a\u3044\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"sort"})," \u306f ",(0,i.jsx)(n.code,{children:"{column, direction}"})," \u306e\u30ea\u30b9\u30c8\u3002\u65b9\u5411\u306f ",(0,i.jsx)(n.code,{children:"asc"})," \u304b ",(0,i.jsx)(n.code,{children:"desc"})," \u3060\u3051\u3001\u4ed6\u306f\u7121\u3057\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"result.limit"})," \u304c\u884c\u6570\u306e\u4e0a\u9650\u3002",(0,i.jsx)(n.code,{children:"result.count_only: true"})," \u306a\u3089\u30b9\u30ab\u30e9\u30fc\u306e\u30ab\u30a6\u30f3\u30c8\u3060\u3051\u8fd4\u3063\u3066 ",(0,i.jsx)(n.code,{children:"limit"})," \u306f\u7121\u8996\u3002"]}),"\n"]}),"\n",(0,i.jsxs)(n.h3,{id:"81-calc-\u3068\u5217\u5ba3\u8a002026-05-11-\u304b\u3089",children:["8.1 ",(0,i.jsx)(n.code,{children:"calc"})," \u3068\u5217\u5ba3\u8a00\uff082026-05-11 \u304b\u3089\uff09"]}),"\n",(0,i.jsxs)(n.p,{children:[(0,i.jsx)(n.code,{children:"calc"})," \u5f0f\u306e\u4e2d\u306e ",(0,i.jsx)(n.code,{children:"material.column"})," \u53c2\u7167\u306f\u3001\u305d\u306e\u5217\u306e\u5ba3\u8a00\u305d\u306e\u3082\u306e\u3067\u3059\u3002Executor \u306f\u305d\u306e\u30de\u30c6\u30ea\u30a2\u30eb\u304c\u3042\u308b\u3069\u3061\u3089\u5074\uff08",(0,i.jsx)(n.code,{children:"from"})," \u307e\u305f\u306f ",(0,i.jsx)(n.code,{children:"join.with"}),"\uff09\u304b\u3089\u3067\u3082\u5217\u3092 fetch \u3057\u3001\u96c6\u8a08\u304b\u3089\u898b\u3048\u308b\u3088\u3046\u306b merge \u3092\u901a\u308a\u629c\u3051\u3055\u305b\u307e\u3059\u3002\u305d\u306e\u5217\u306f ",(0,i.jsx)(n.strong,{children:"\u51fa\u529b\u306b\u306f\u4e57\u308a\u307e\u305b\u3093"}
1)," \u2014 \u30ec\u30b9\u30dd\u30f3\u30b9\u306e\u5217\u306f\u3061\u3087\u3046\u3069 ",(0,i.jsx)(n.code,{children:"keep"})," \u222a ",(0,i.jsx)(n.code,{children:"calc"})," \u30ad\u30fc\u3067\u3001",(0,i.jsx)(n.code,{children:"GROUP BY"})," \u306f\u3061\u3087\u3046\u3069 ",(0,i.jsx)(n.code,{children:"keep"})," \u3067\u3059\u3002"]}),"\n",(0,i.jsxs)(n.p,{children:[(0,i.jsx)(n.code,{children:"calc"})," \u304b\u3089\u898b\u3048\u308b\u3088\u3046\u306b\u3059\u308b\u305f\u3081\u3060\u3051\u306b join \u5074\u5217\u3092 ",(0,i.jsx)(n.code,{children:"keep"})," \u306b\u5165\u308c\u308b\u5fc5\u8981\u306f ",(0,i.jsx)(n.strong,{children:"\u3042\u308a\u307e\u305b\u3093"}),"\u3002\u3080\u3057\u308d\u3001\u5165\u308c\u308b\u3068 ",(0,i.jsx)(n.code,{children:"GROUP BY"})," \u306e\u7c92\u5ea6\u304c\u5909\u308f\u3063\u3066\u307b\u307c\u5e38\u306b\u9593\u9055\u3044\u3067\u3059:"]}),"\n",(0,i.jsx)(n.pre,{children:(0,i.jsx)(n.code,{className:"language-jsonc",children:'// \u2705 \u6b63\u89e3: COUNT \u306f calc \u53c2\u7167\u7d4c\u7531\u3067 click_event.pv_id \u3092\u898b\u308b\u3002\n// GROUP BY = (selector)\u3002selector \u3054\u3068\u306b1\u884c\u3002\n{\n "from": ["allpv"],\n "join": { "with": "click_event",\n "on": [{ "left": "allpv.pv_id", "right": "click_event.pv_id" }] },\n "keep": ["click_event.selector"],\n "calc": { "clicks": "COUNT(click_event.pv_id)" }\n}\n\n// \u274c \u9593\u9055\u3044: keep \u306b pv_id \u304c\u5165\u3063\u3066 GROUP BY = (selector, pv_id) \u306b\u306a\u308b\u3002\n// \u5168\u884c\u304c\u30e6\u30cb\u30fc\u30af\u306a\u30b0\u30eb\u30fc\u30d7\u306b\u306a\u308a\u3001\u3069\u3053\u3067\u3082 clicks = 1 \u306b\u306a\u308b\u3002\n{\n "from": ["allpv"],\n "join": { "with": "click_event",\n "on": [{ "left": "allpv.pv_id", "right": "click_event.pv_id" }] },\n "keep": ["click_event.selector", "click_event.pv_id"],\n "calc": { "clicks": "COUNT(click_event.pv_id)" }\n}\n'})}),"\n",(0,i.jsxs)(n.p,{children:[(0,i.jsx)(n.code,{children:"calc"})," \u5f0f\u304c\u3001",(0,i.jsx)(n.code,{children:"from"})," \u304b ",(0,i.jsx)(n.code,{children:"join.with"})," \u306b\u767b\u5834\u3057\u306a\u3044 ",(0,i.jsx)(n.code,{children:"material.column"})," \u3092\u53c2\u7167\u3059\u308b\u5834\u5408\u3001\u307e\u305f\u306f\u5b58\u5728\u3057\u306a\u3044\u5217\u3092\u53c2\u7167\u3059\u308b\u5834\u5408\u3001\u30d0\u30ea\u30c7\u30fc\u30bf\u306f\u5b9f\u884c\u524d\u306b ",(0,i.jsx)(n.code,{children:"E_CALC_COLUMN_UNRESOLVED"})," \u3092\u8fd4\u3057\u307e\u3059\u3002\u53c2\u7167\u3092\u4fee\u6b63\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u5909\u66f4\u305b\u305a\u306b\u30ea\u30c8\u30e9\u30a4\u3057\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002"]}),"\n",(0,i.jsxs)(n.p,{children:[(0,i.jsx)(n.strong,{children:"\u4e92\u63db\u6027\u30e1\u30e2\u3002"})," ",(0,i.jsx)(n.code,{children:"2025-10-20"})," \u306f ",(0,i.jsx)(n.code,{children:"from"})," \u5074\u5217\u306e\u307f\u3092\u81ea\u52d5 fetch \u3057\u3066\u3044\u307e\u3057\u305f\u3002\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5bfe\u3057\u3066\u3001join \u5074\u53c2\u7167\u3092 ",(0,i.jsx)(n.code,{children:"calc"})," \u306e\u4e2d\u306b\u5165\u308c\u305f\u30af\u30a8\u30ea\u306f\u30b5\u30a4\u30ec\u30f3\u30c8\u306b 0 \u884c\u3092\u8fd4\u3057\u307e\u3059\u3002\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304c\u4e21\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u5834\u5408\u3001",(0,i.jsx)(n.code,{children:"/guide"})," \u306e ",(0,i.jsx)(n.code,{children:"features_detail.calc_join_symmetric"})," \u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044: ",(0,i.jsx)(n.code,{children:"false"})," \u304b\u975e\u5b58\u5728\u306a\u3089\u300c\u65e7\u6319\u52d5 \u2014 \u5217\u3092 ",(0,i.jsx)(n.code,{children:"from"})," \u5074\u306b\u7f6e\u304f\u304b\u3001",(0,i.jsx)(n.code,{children:"2026-05-11"})," \u30b5\u30fc\u30d0\u30fc\u306b\u79fb\u884c\u300d\u3057\u3066\u304f\u3060\u3055\u3044\u3002"]}),"\n",(0,i.jsxs)(n.h3,{id:"82-joinonleft--joinonright-\u30eb\u30fc\u30eb2026-05-11-\u304b\u3089",children:["8.2 ",(0,i.jsx)(n.code,{children:"join.on.left"})," / ",(0,i.jsx)(n.code,{children:"join.on.right"})," \u30eb\u30fc\u30eb\uff082026-05-11 \u304b\u3089\uff09"]}),"\n",(0,i.jsxs)(n.p,{children:[(0,i.jsx)(n.code,{children:"on.left"})," \u3068 ",(0,i.jsx)(n.code,{children:"on.right"})," \u306f\u30d4\u30f3\u30dd\u30a4\u30f3\u30c8\u30fb\u30b9\u30b3\u30fc\u30d7\u3067\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3\u3055\u308c\u307e\u3059:"]}
1),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"on.left"})," \u306f ",(0,i.jsx)(n.code,{children:"from"})," \u5074\u306e ",(0,i.jsx)(n.strong,{children:"\u89e3\u6c7a\u6e08\u307f\u7269\u7406\u30de\u30c6\u30ea\u30a2\u30eb\u540d"})," \u3068\u5b8c\u5168\u4e00\u81f4\u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002",(0,i.jsx)(n.code,{children:"from[0]"})," \u304c\u30d3\u30e5\u30fc\u30c1\u30a7\u30a4\u30cb\u30f3\u30b0\u306e\u3068\u304d\u306f\u3001\u30d0\u30ea\u30c7\u30fc\u30bf\u304c\u6bd4\u8f03\u524d\u306b\u30d3\u30e5\u30fc\u3092\u5143\u306e\u30de\u30c6\u30ea\u30a2\u30eb\u540d\u307e\u3067\u89e3\u6c7a\u3057\u307e\u3059\u3002\u7d20\u306e\u30d3\u30e5\u30fc\u540d\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\uff08\u4f8b: ",(0,i.jsx)(n.code,{children:"top_pages.pv_id"}),"\uff09\u306f left \u5074\u3067\u306f\u62d2\u5426\u3055\u308c\u307e\u3059\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"on.right"})," \u306f ",(0,i.jsxs)(n.strong,{children:[(0,i.jsx)(n.code,{children:"join.with"})," \u6587\u5b57\u5217\u3068\u5b8c\u5168\u4e00\u81f4"]})," \u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002"]}),"\n"]}),"\n",(0,i.jsxs)(n.p,{children:["\u5931\u6557\u6642\u306b\u306f ",(0,i.jsx)(n.code,{children:"E_INVALID_JOIN"})," \u304c ",(0,i.jsx)(n.code,{children:"details"})," \u306b ",(0,i.jsx)(n.code,{children:"side"}),"\u3001",(0,i.jsx)(n.code,{children:"received_value"}),"\u3001",(0,i.jsx)(n.code,{children:"expected_prefix"}),"\u3001",(0,i.jsx)(n.code,{children:"hint"})," \u3092\u69cb\u9020\u5316\u3057\u3066\u8fd4\u3057\u307e\u3059\u3002\u30ec\u30b9\u30dd\u30f3\u30b9\u306e\u53b3\u5bc6\u306a\u5f62\u3068\u52d5\u4f5c\u30b5\u30f3\u30d7\u30eb\u306f ",(0,i.jsx)(n.a,{href:"/ja/docs/developer-manual/api/2026-05-11/reference/reference-errors-2026-05-11",children:"\u30a8\u30e9\u30fc"})," \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002"]}),"\n",(0,i.jsxs)(n.h2,{id:"9-\u3084\u3063\u3066-\u3044\u3051\u306a\u3044-\u3053\u3068",children:["9. \u3084\u3063\u3066 ",(0,i.jsx)(n.strong,{children:"\u3044\u3051\u306a\u3044"})," \u3053\u3068"]}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsx)(n.li,{children:"SQL \u3092\u66f8\u3053\u3046\u3068\u3057\u306a\u3044\u3002SQL \u5c64\u306f\u9732\u51fa\u3057\u3066\u3044\u306a\u3044\u3002"}),"\n",(0,i.jsx)(n.li,{children:"\xa72 \u306b\u6319\u304c\u3063\u3066\u3044\u306a\u3044 URL \u7d4c\u7531\u3067\u30c7\u30fc\u30bf\u3092\u53d6\u308d\u3046\u3068\u3057\u306a\u3044\u3002"}),"\n",(0,i.jsxs)(n.li,{children:["\u8a18\u61b6\u304b\u3089\u30ab\u30e9\u30e0\u30ea\u30b9\u30c8\u3092\u30cf\u30fc\u30c9\u30b3\u30fc\u30c9\u3057\u306a\u3044\u3002\u6b63\u672c\u306f ",(0,i.jsx)(n.code,{children:"materials.yaml"})," \u3067\u3001update \u9593\u3067\u5909\u308f\u308a\u3046\u308b\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.code,{children:"time"})," \u3092\u30d0\u30a4\u30d1\u30b9\u3057\u3088\u3046\u3068\u3057\u306a\u3044\u3002\u300c\u5168\u671f\u9593\u300d\u30af\u30a8\u30ea\u306f\u610f\u56f3\u7684\u306b\u4f7f\u3048\u306a\u3044 \u2014 \u901a\u5e38\u305d\u308c\u306f\u30df\u30b9\u3060\u304b\u3089\u3002"]}),"\n",(0,i.jsxs)(n.li,{children:["\u904e\u53bb\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3067\u6709\u52b9\u3060\u3063\u305f\u6a5f\u80fd\u304c\u73fe\u5728\u3082\u5b58\u5728\u3059\u308b\u3068\u4eee\u5b9a\u3057\u306a\u3044\u3002\u30bb\u30c3\u30b7\u30e7\u30f3\u3054\u3068\u306b ",(0,i.jsx)(n.code,{children:"features_detail"})," \u3092\u518d\u78ba\u8a8d\u3059\u308b\u3002"]}),"\n",(0,i.jsx)(n.li,{children:"\u5bfe\u8c61\u30de\u30c6\u30ea\u30a2\u30eb\u306e\u5b58\u5728\u3092\u691c\u8a3c\u305b\u305a\u306b\u30e6\u30fc\u30b6\u30fc\u306e\u610f\u56f3\u3092\u30af\u30a8\u30ea\u306b\u76f4\u8a33\u3057\u306a\u3044\u3002"}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"10-\u8ff7\u3063\u305f\u3089",children:"10. \u8ff7\u3063\u305f\u3089"}),"\n",(0,i.jsxs)(n.p,{children:["\u63a8\u6e2c\u3059\u308b\u3088\u308a ",(0,i.jsx)(n.strong,{children:"\u30e6\u30fc\u30b6\u30fc\u306b\u8cea\u554f\u3059\u308b"})," \u3053\u3068\u3092\u512a\u5148\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3046\u307e\u304f\u5f62\u6210\u3055\u308c\u305f\u8cea\u554f\u30921\u56de\u3059\u308b\u307b\u3046\u304c\u3001\u62d2\u5426\u3055\u308c\u305f\u30af\u30a8\u30ea\u30923\u56de\u6295\u3052\u308b\u3088\u308a\u5b89\u3044\u3002\u3053\u306e API \u306f\u6b63\u3057\u304f\u7d44\u307f\u7acb\u3066\u3089\u308c\u305f\u30af\u30a8\u30ea\u3092\u66f8\u304d\u3084\u3059\u304f\u3059\u308b\u305f\u3081\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059 \u2014 \u3082\u3057\u3042\u306a\u305f\u304c\u5f62\u3068\u6226\u3063\u3066\u3044\u308b\u306a\u3089\u3001\u30de\u30c6\u30ea\u30a2\u30eb\u9078\u3073\u3092\u9593\u9055\u3048\u3066\u3044\u308b\u53ef\u80fd\u6027\u304c\u9ad8\u3044\u3067\u3059\u3002"]})]})}function x(e={}){const{wrapper:n}={...(0,d.R)(),...e.components};return n?(0,i.jsx)(n,{...e,children:(0,i.jsx)(j,{...e})}):j(e)}},8453:(e,n,c)=>{c.d(n,{R:()=>s,x:()=>r});var l=c(6540);const i={},d=l.createContext(i);function s(e){const n=l.useContext(d);return l.useMemo((function(){return"function"==typeof e?e(n):{...n,...e}}),[n,e])}function r(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(i):e.components||i:s(e.components),l.createElement(d.Provider,{value:n},e.children)}},9915:(e,n,c)=>{c.d(n,{A:()=>l});const l=c.p+"assets/files/materials-60a96f8f79c9b73070b916e82abfe1fb.yaml"}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.