I have a read only grid with a record type as its source called Survey Data and it displays data from another record related with a one-to-many relationship called Recommendations. I'd like to create a user filter in the Survey Data record type that would allow the user to either see all the rows that have information in the Recommendations record (aka the Survey Data id exists in the Recommendations table), or see all the rows that do not have Recommendation information (aka the Survey Data id does not exist in the Recommendations table).
Does anyone have an idea of how to do this? I've tried setting it up so that it finds where the Survey Data id in the Recommendations table is null() but that did not work. I also have the ability to change this to a one-to-one relationship if I need to.
Any guidance is appreciated, thanks!
Discussion posts and replies are publicly visible
Can you try to see if the recommendation relationship is null instead of looking for where the survey ID is null? That should return any surveys that don't have any related recommendations: docs.appian.com/.../fnc_system_a_queryfilter.html
That worked! I didn't know that you could check if a relationship itself was null, that's very useful. Thanks Peter!