Skip to main content
B
brindas
July 16, 2021
Solved

Using RecordFilterList function does not filter properly if there are null values

  • July 16, 2021
  • 9 replies
  • 0 views

Hi all,

I have created a entity-based record type which is based on a view.  I have created a user filter in the record based on a!recordfilterlist function. The user filter does not give correct result.  The field on which I am using the filter has null values in the view.  Can someone help me to fix this ussue?

Thanks in advance.

    Best answer by stefanhelzle0001

    If you filter for a name, then DB would only return lines with this value. You mentioned a view. Did you test a query against the view itself in cloud database?

    9 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 16, 2021

    What is the expected result and what do you observe?

    B
    brindasAuthor
    July 16, 2021

    Hi Stefan,

    I am using recordfilterlist function which fetches all the candidate names from the view and lists them in the candidate name user filter drop-down. The column candidate name has null values also. For example if I select "Josh Mathew" In the filter it simply gives some random rows with different candidate names along with null values for the candidates rows. Actual result should show only rows where the candidate name is "Josh Mathew". I am not sure if this is because of the null values or due to view definition.

    gayathris111098
    gayathris111098
    July 16, 2021

    Quick question, does view has PK?

    Sometimes If the primary key field contains duplicate, non-unique values or null values we may see some weird behavior!

      Terms & ConditionsAccessibility statement