What is the best approach to fetch data from different object types if they are having same key where we can identify the data in both the object type. But the issue is if there is an entry in object type 1, there might be multiple entries in the other object type. Do we still do Object table widget where we bring both the Object types in the Object Set using a union or intersection. Or is it a best practice to have a link type between these object types
Or if there are other better approaches, please let me know!
Do you mind providing some examples of the object types/data? There are probably a couple of different options, but I want to be make sure I understand the context completely. Thanks!
We have two different object types which we use to search and display data using an object table widget.
Currently, after storing the values in a string array over object type 1, which is aggregated on unique values, we create another object set definition on object type 2 and filter the matching property with the string array variable.
But we are hitting the limit of 10,000 properties for the unique values of a string array