{"id":631,"date":"2018-05-23T17:09:17","date_gmt":"2018-05-23T08:09:17","guid":{"rendered":"https:\/\/www.oqiita.com\/?p=631"},"modified":"2018-06-07T09:45:46","modified_gmt":"2018-06-07T00:45:46","slug":"post-631","status":"publish","type":"post","link":"https:\/\/www.oqiita.com\/?p=631","title":{"rendered":"\u3010GeneXus\u3011Find"},"content":{"rendered":"

\u6b8b\u308a\u306eFind\u3092\u66f8\u3053\u3046\uff08\u9045\u3044\uff09<\/p>\n


\n<\/p>\n

\u7d50\u69cb\u524d\u306e\u30a8\u30f3\u30c8\u30ea\u30fc<\/p>\n

\n\t\t\t
\n\t\t\t\"\"<\/span><\/p>\n
\n\t\t\t\t

DB\u95a2\u4fc2\u306e\u6e96\u5099<\/h3>\n

\"\"<\/a><\/p>\n

\u30c7\u30fc\u30bf\u306f\u9069\u5f53\u306b\u521d\u671f\u30c7\u30fc\u30bf\u3068\u3057\u3066100\u4ef6\u304f\u3089\u3044\u30eb\u30fc\u30d7\u3067\u767b\u9332\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n

\nFor &i = 1 to 100\n\tNew\n\t\t\/\/Transaction2_ID \u30aa\u30fc\u30c8\u30ca\u30f3\u30d0\u30fc\n\t\tTransaction2_NAME = \"TEST_\" + &i.ToFormattedString()\n\tEndnew\nEndfor\n\nCommit\n<\/code><\/pre>\n
 <\/p>\n
\"\"<\/a><\/p>\n
Transaction3_Transaction2_NAME \u306e\u5f0f\u306e\u5185\u5bb9\u306f\u4ee5\u4e0b\u3067\u3059\u3002<\/p>\n
find(Transaction2_NAME, Transaction2_ID = Transaction3_Transaction2_ID, \"\")<\/code><\/pre>\n
\u8aac\u660e\u3059\u308b\u3068
\n\u53d6\u5f97\u9805\u76ee\uff1aTransaction2_NAME
\n\u53d6\u5f97\u6761\u4ef6\uff1aTransaction2_ID = Transaction3_Transaction2_ID
\n\u53d6\u5f97\u3067\u304d\u306a\u304b\u3063\u305f\u5834\u5408\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u9805\u76ee\uff1a\u201d\u201d<\/p>\n
\u30d3\u30eb\u30c9\u3092\u884c\u3044Transaction3\u306b\u9069\u5f53\u306b\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3057\u307e\u3059\u3002<\/p>\n
 <\/p>\n
Transaction3\u306e\u753b\u9762\u3067\u3059\u3002
\n\"\"<\/a>
\n\u8d64\u67a0\u3067\u56f2\u3063\u305f\u90e8\u5206\u3067\u65e2\u306b\u308f\u304b\u308b\u3068\u601d\u3044\u307e\u3059\u304c
\nTransaction3_Transaction2_ID\u3068\u3044\u3046\u9805\u76ee\u306b1\uff5e100\u306e\u5024\u3092\u5165\u308c\u308b\u3068
\nTransaction2_NAME\u304c\u53d6\u5f97\u3067\u304d\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
\u78ba\u8a8d<\/h3>\n
\u9069\u5f53\u306a\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u4f5c\u6210\u3057\u3066\u3069\u3093\u306aSQL\u304c\u767a\u884c\u3055\u308c\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n
\n\/\/ \u3068\u308a\u3042\u3048\u305a Transaction3 \u3092\u5168\u4ef6\u53c2\u7167\nFor each\n\tMSG(Transaction3_ID.ToString().Trim())\n\tMSG(Transaction3_NAME)\n\tMSG(Transaction3_Transaction2_NAME)\n\tMSG(\"====================================\")\nEndfor\n\nReturn\n<\/code><\/pre>\n
\u4e0a\u8a18\u306e\u3088\u3046\u306aFor each\u3092\u8a18\u8ff0\u3057\u3066\u81ea\u52d5\u751f\u6210\u3055\u308c\u308bJava\u30b3\u30fc\u30c9\u3092\u898b\u308b\u3068
\n\u4ee5\u4e0b\u306e\u3088\u3046\u306aSQL\u304c\u8a18\u8ff0\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n
\nSELECT\n  T2.Transaction2_ID\n  , T1.Transaction3_Transaction2_ID\n  , T1.Transaction3_ID\n  , T1.Transaction3_NAME\n  , COALESCE(T2.Transaction2_NAME, N'') AS Transaction3_Transaction2_NAME \nFROM\n  ( \n    Transaction3 T1 \n      LEFT JOIN Transaction2 T2 \n        ON T2.Transaction2_ID = T1.Transaction3_Transaction2_ID\n  ) \nORDER BY\n  T1.Transaction3_ID\n<\/code><\/pre>\n
\u7279\u306b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u306a\u304f\u3066\u3082LEFT JOIN\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n
\u307e\u3068\u3081<\/h3>\n
\u3053\u3093\u306a\u611f\u3058\u3067\u5f0f\u9805\u76ee\uff08Formula\uff09\u3092\u4f7f\u7528\u3059\u308b\u3068
\n\u767a\u884c\u3059\u308bSQL\u304c\u6e1b\u3063\u305f\u308a\u3057\u3066\u30ec\u30b9\u30dd\u30f3\u30b9\u304c\u826f\u304f\u306a\u3063\u305f\u308a\u3057\u307e\u3059\u306e\u3067
\n\u305c\u3072\u4f7f\u3063\u3066\u307f\u3066\u306f\u3069\u3046\u3067\u3057\u3087\u3046\u304b\uff01\uff01\uff01<\/p>\n
  
\n    \u53c2\u8003<\/span>
\n    Find \u5f0fwiki.genexus.jp<\/span><\/span>
\n  <\/a><\/p>\n
\u4ee5\u4e0a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6b8b\u308a\u306eFind\u3092\u66f8\u3053\u3046\uff08\u9045\u3044\uff09<\/p>\n","protected":false},"author":1,"featured_media":722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[104,37,105,92],"class_list":{"0":"post-631","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-genexus","8":"tag-find","9":"tag-genexus","10":"tag-left-join","11":"tag-oracle","12":"entry"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.oqiita.com\/wp-content\/uploads\/2018\/05\/sango_gx_icatch.png","jetpack_shortlink":"https:\/\/wp.me\/p8QluP-ab","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=631"}],"version-history":[{"count":12,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/631\/revisions"}],"predecessor-version":[{"id":833,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/posts\/631\/revisions\/833"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=\/wp\/v2\/media\/722"}],"wp:attachment":[{"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oqiita.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}