Skip to main content
reenab9586
reenab9586
New Participant
Dec 19, 2023 4:59 PM UTC
Question

Querying a database in expression rule

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
    stefanhelzle0001
    Brainy
    Dec 19, 2023 5:42 PM UTC

    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
    mikes0011
    Brainy
    Dec 19, 2023 7:22 PM UTC

    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
    Terms & ConditionsAccessibility statement