{"id":5143,"date":"2026-05-30T02:45:48","date_gmt":"2026-05-30T02:45:48","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=glossary&#038;p=5143"},"modified":"2026-05-30T02:45:48","modified_gmt":"2026-05-30T02:45:48","slug":"deluge-fetch-records-zoho-creator","status":"publish","type":"glossary","link":"https:\/\/aaxonix.com\/resources\/glossary\/deluge-fetch-records-zoho-creator\/","title":{"rendered":"Deluge fetch records"},"content":{"rendered":"<h2>What Is the Deluge fetch records Statement?<\/h2>\n<p>The <code>fetch records<\/code> statement is a Deluge data retrieval operation that queries records from a Creator form based on a criteria expression. It returns a list of matching records that the script can loop through, extract values from, or count. It is the standard way to read existing data from within a Creator workflow or function.<\/p>\n<h2>Syntax and Criteria<\/h2>\n<p>The basic syntax is <code>records = FormName[CriteriaExpression];<\/code>. The criteria can reference field values, comparison operators, and logical operators. For example, <code>orders = Orders[Status == \"Pending\" &amp;&amp; Customer == input.CustomerName];<\/code> retrieves all pending orders for the current submitter. The returned list supports iteration with <code>for each<\/code> loops and size checks with <code>records.size()<\/code>.<\/p>\n<h2>Performance Considerations<\/h2>\n<p>Fetch records queries run against Creator&#8217;s data store on every execution. For forms with large record counts, adding indexed criteria fields improves query speed. Avoid fetching all records from a large form without criteria, as this can slow workflow execution and hit record fetch limits. Where possible, scope criteria to narrow the result set before iterating.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Deluge fetch records statement retrieves records from a Creator form that match specified criteria, enabling scripts to read and process existing data.<\/p>\n","protected":false},"template":"","meta":{"seo_title":"Deluge fetch records | Zoho Glossary | Aaxonix","seo_description":"The Deluge fetch records statement retrieves records from a Creator form that match specified criteria, enabling scripts to read and process existing data.","seo_keyword":"Zoho Deluge fetch records","seo_faqs":"","term_type":"","glossary_related":"","glossary_links":""},"glossary_category":[1258],"class_list":["post-5143","glossary","type-glossary","status-publish","hentry","glossary_category-zoho-creator"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary\/5143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary"}],"about":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/types\/glossary"}],"wp:attachment":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/media?parent=5143"}],"wp:term":[{"taxonomy":"glossary_category","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/glossary_category?post=5143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}