Any suggestions on how I can get results back from a query rule where my value i

Any suggestions on how I can get results back from a query rule where my value is not null? It appears I can't use null as an input so I'm at a loss. Thanks!...

OriginalPostID-100758

OriginalPostID-100758

  Discussion posts and replies are publicly visible

Parents
  • Here are a few ideas I can think of:

    1. Use a query database node: ex. select <fieldA> from <table> where <fieldB> is not NULL
    2. Create a view that filters the rows based on these null values. Then query that table.
    3. Use a query rule to call back a bigger datasubset, then filter nulls in process.

    There are positives and downsides to each scenario, so think about each one before implementing.
Reply
  • Here are a few ideas I can think of:

    1. Use a query database node: ex. select <fieldA> from <table> where <fieldB> is not NULL
    2. Create a view that filters the rows based on these null values. Then query that table.
    3. Use a query rule to call back a bigger datasubset, then filter nulls in process.

    There are positives and downsides to each scenario, so think about each one before implementing.
Children
No Data