--- title: "Set up dynamic queries - Data Entry Workflow" slug: "set-up-dynamic-queries" status: "update" updated: 2026-10-05T10:22:53Z published: 2026-10-05T12:24:45Z canonical: "docs.staedean.com/set-up-dynamic-queries" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.staedean.com/llms.txt > Use this file to discover all available pages before exploring further. # Set up dynamic queries - Data Entry Workflow Use a dynamic query to find one or more records in the database. The found records are the input for further processing. You can use a dynamic query on a data entry workflow template SQL trigger assignment. To define a query range, you can use a function. ## Flow diagram [Embedded content](https://viewer.diagrams.net/?tags=%7B%7D&lightbox=1&highlight=0000ff&edit=_blank&layers=1&nav=1&title=Set%20up%20dynamic%20queries.drawio&dark=auto#R%3Cmxfile%3E%3Cdiagram%20name%3D%22Page-1%22%20id%3D%220%22%3E7VpZb9s4EP41BnYfHOjw1cfaSdoCu90sgiKbR1oaW6wpUqUoH%2F31O6Qo67JTXzlaNEggzpAckvMNZ8hhOv4kXn%2BQJIn%2BFiGwjueE645%2F3fE81%2Bl5%2BNGcTc7pDyxjLmloG5WMe%2Fodip6Wm9EQ0lpDJQRTNKkzA8E5BKrGI1KKVb3ZTLD6qAmZQ4txHxDW5j7QUEU5953jlPyPQOeRalTEpGhrGWlEQrGqsPybjj%2BRQqi8FK8nwLTuCrXk%2FW731G7nJYGrQzp47Q5WRqo2xWqxCyoWifEqogruExLomhVii7xIxQwpF4szythEMCFNP382m3lBgPxUSbGASo1jfrY1hQ61jHz0JWGZHf1eEaksF6SCdWWadlEfQMSg5AabRBW196ySVyVEA8sqhAwtvan3INY%2B5lvBpQ6xYNW4W6X%2BISqVkYinWVpXH2F0zrEs8yWM9XIpGt17y49pGGoBY0amwO5EShUVuoLBrNr%2Br0b1th8XpurBALcbMRicj9inVKsQ%2FyThuI%2FwC98yKiHU2zQiCOaAxNp0%2BDRNjIAB0%2FMP6RKLc13MUiiEzDIemIV4jlARyH29EZeKgB0ycWhuZqCnBGuaKsrnlQEQjdtDhV%2FGGnsNaxzVrdH1jjfHLynIf6ZftdPzHGMneddrWAITSV2fASNpmg%2FBKF%2FkLfVSiSLdmHB0Y7E2YuSIINWfXEq3kNGtSCjsv19Rhd0aP9gLIuMhhNaa9ruTqQM%2BDI40zl0e6yT4Rm343IY38b06fqe4EyQrED4J6UQCUWCiKCcxDbD0LQMz8RXFORam%2FkC%2FExkeA3NgJHet3K6R2tUyuygRC6W8AvTheaAfF1dOMoTnAt1tgO4PLgJ6K6yM3lSk9nb5%2FRsevlScHl0gUL%2FLRUDYOuu1VSwyGUDtyFTVOkq4tySwqVjdlIxx3dCFVJGYC45BWogiCH8FpTb2kEsyJepQAQ%2Ff6yMrklMmgsVJdo9nqDmo2gGlAtxuiCQwouiyrpxzFF6c3o%2FVuH%2BOxkOSRhdSv0iAH6l9XJbc%2FIeEUxCPmrjqF%2BT1ulp5valSdyApKhmkZbah%2FJdvfPYxc%2B%2BGn714za97dzeLrttvAfwI6Uth7L4Cxm9hVw1bSv8sXkrn%2Fmk67%2F8K%2B6rcSo%2B1nfQM%2B6oN8ZkA2653gurTVxHsek7jRNEMdvlMba%2BGmWyncZjl9I6wnF9oaz4Lbv6omUxo4JbvvYvg1j9txw9%2FdihHr3V22e0RBqfB8GTY3gNOqf0qQmlEEl1rE51ap%2BMgk0sDmnMZCE%2FztHWcQ5iRzGRSiiRXgM21B96f5ZoJrm7xAsq0yI%2FAlqDb2Qo7X9e1dHsgc1Mek2AxNzpoN6gYp0lj0GCnyfVf1cL6h%2FjjRLsUM3R%2FjL%2FOldvDfpPtt9PHVhNTk9N13qi%2Fu7VruE0JRWv7bch2G7xiJq3Wddn4WxpzvJ7rZ4OraRLzK1iahVdNcl%2BecyqUEvF%2B6POLLv7ssDqlt0PbOJPKUcFeriunh7HIFKMcrbx4ZtCWT9IkJ2Z0rXde0UrLJSqIdNYRF7uJp0KvKIY0Nc8NB17Kmb44d0MiF3%2BU3hN1qvMQ%2FiDsu47z5%2Fm7p%2BVnP%2FGZkLHNydo8oE7GOmKbVG1lXJvZ1Hbq0UF34zlTqMgMXzTn2gzap%2BRcD9vKReLgMsHi6Uj%2BWsHiJ3X6sKZqe0nHcuWOjlQZ4DSxqRA%2Fvkhc%2FOh5XjQZ%2Fo4mv6PJm4om%2BRNFCCmqyoSTAx8I836VgELNe%2BGSUISLwavGkNaF%2FbAngPLVP78Rlv864d%2F8Dw%3D%3D%3C%2Fdiagram%3E%3C%2Fmxfile%3E)