Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning!
I have an application where the user wants to know the list of Codes that are linked to a Prime Code, but he will search and filter by the Code itself.
A manual solution would be, after it performs the filter by Code, to filter the corresponding Prime and then clear the initial filter to have the complete list.
Example:
User filters code 414800:
Now he filters the corresponding Prime Code:
Finally, he clears the Code filter. Now he has the complete list of Codes that are related to the Prime Code of the initial Code that was searched:
I would like this process to be done naturally after the user searches for a Code.
I thought of creating a Chain ID for each Prime and dualizing, but I don't see a way to relate this directly to the filter, because it will always look for a Code, never the Prime Code.
Does anyone have any suggestions?
Thanks!
Adding a measure with the set modifiers that I suggest could emulate the required behavior.
This measure counts records but you could replace it with a more meaningful one using the same set modifiers.
Sum({<[Ecode] =, [Ecode Prime] = P([Ecode Prime])>} 1)
Adding a measure with the set modifiers that I suggest could emulate the required behavior.
This measure counts records but you could replace it with a more meaningful one using the same set modifiers.
Sum({<[Ecode] =, [Ecode Prime] = P([Ecode Prime])>} 1)