For eg., Below Sales order ‘SONDE0110031’ has three lines. We have fetched first line.<\/p>\n
Kindly refer fig. FirstRecordOut <\/em>for the same.<\/p>\n fig. FirstRecord\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n Output:<\/p>\n 2. Last : <\/strong>\u00a0It is used as a read or update option to define the Last<\/em><\/strong> record in the key order.<\/p>\n For eg., Here, we have fetched the last record from the same sales order as above.<\/p>\n Output:<\/p>\n Thus, we can fetch the very first and last record from the table using respective key words.<\/p>\n Hope this helps!<\/strong><\/p>\n <\/p>\n About Us<\/strong><\/p>\n Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n Greytrix<\/a>\u00a0has some unique solutions of\u00a0Sage X3 integration with Sage CRM<\/a>,\u00a0Salesforce.com<\/a>\u00a0and\u00a0Magento eCommerce<\/a> along with Sage X3 migration from Sage 50 US, Sage Pro and QuickBooks. \u00a0We also offer best-in-class\u00a0Sage X3 customization and development services<\/a>\u00a0to Sage business partners, end users and Sage PSG worldwide.<\/p>\n For more information on Sage X3 Integration and Services, please contact us at\u00a0x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":" While coding in any programming language, we often use loops like for,while etc. Basically, loops are performed in two cases: * Read loops on database tables or joins. * Loops on index values or on a list of values. Sage X3 provides two special key words to fetch the required data more quickly. Two of\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,8],"tags":[790,794],"class_list":["post-11314","post","type-post","status-publish","format-standard","hentry","category-features","category-sage-erp-x3","tag-fetch-data-quickly-from-tables","tag-fetch-the-required-data"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/11314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=11314"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/11314\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=11314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=11314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=11314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Fetch](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/01\/Fetch-Data-Quickly-From-Tables.png\")
<\/p>\n![\"First](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/01\/First-Record-Output-1.png\")
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n