Field Comparison in Reports

Related products:CS Reports

Forum|Forum|9 years ago
August 16, 2017
6 replies
160 views

Hey Team,

This is Logan from Support. We've recently had a few requests for some additional features in the Report Builder's Advanced Logic that seem like great ideas!

Specifically, the ability to compare two fields to narrow down results.

For example:

(Created By = 😵 AND (Assignee = X)

In this case, we would be looking for records where both the "Created By" would also have a "Assignee" of the same user.

But we would need the ability to add variables in here, as we wouldn't want to specify which user exactly.

In our Rules Engine "Setup Action" additional criteria, we have the ability to add a filter saying "Created By = FIELD (or VALUE)". This same type of filtering would be beneficial in the Reports for showing granular results that our users are looking for!

Thanks for the help! I'd be happy to provide additional information if requested.

dan_ahrens

Expert ⭐️⭐️⭐️

I'll +1 this idea. It came up with me today on a call with a customer who was looking to do that exact same type of logic - comparing the values of two fields and filtering based on if the two fields were identical (or not identical).

VP of Customer Success at Forcepoint

spencer_engel

Expert ⭐️

Yeah, +1 here as well. I could definitely use this for one of my customers. Without this capability, the only option is to write a bionic rule and loading values to another MDA object, which in my opinion, is way too cumbersome of a process.

joseph_siudzinski

Helper ⭐️

+1 to this. Super valuable in bionic rule transformation, really need it for reports as well.

spencer_engel

Expert ⭐️

I assume this should be marked as “Implemented”, right? Since we can now compare string fields in HA.