Skip to main content
reenab9586
December 19, 2023
Question

Querying a database in expression rule

  • December 19, 2023
  • 2 replies
  • 0 views

How to Query a database values which exceeds the memory limit without any filters. Is there a way we can just type the first 3 characters and the respective values should be fetched?

    2 replies

    stefanhelzle0001
    Brainy
    December 19, 2023

    Yes, there is a way.

    You could check for the length of that text and return a empty data subset if the text has less than 3 characters.

    mikes0011
    Brainy
    December 19, 2023

    You would want to have a paging limit applied to the search results, especially when they might possibly return so many that it throws an error due to the memory limit.

    The Expression Guru