Hello everyone,
I have a question regarding Report Editor Multiple object history.
I have created query "Person" as "Object" and "PersonHistory" as "Multiple object history".
Is there a way to resolve foreign keys in multiple object history like you do it with object query module type?
If not, is there a way to use Multiple object history results in another defined query as view or something else?
Thank you and best regards,
Vitomil
You cannot resolve the foreign keys for the "Multiple object history" but you can use the results in another query.
This has been done in the ootb report "VI_UNS_Account_Operations", where the results of the query "UNSAccounts" is used to fetch a "Single object history" in the query "SingleHistoryUNS" for the accounts that are part of the UNSAccounts query. The "Single object history" is able to fetch the display values for your changes then
You need to assign the parent query and can use <ParentQueryName>.<ColumnName> in your child query as criteria.
You cannot resolve the foreign keys for the "Multiple object history" but you can use the results in another query.
This has been done in the ootb report "VI_UNS_Account_Operations", where the results of the query "UNSAccounts" is used to fetch a "Single object history" in the query "SingleHistoryUNS" for the accounts that are part of the UNSAccounts query. The "Single object history" is able to fetch the display values for your changes then
You need to assign the parent query and can use <ParentQueryName>.<ColumnName> in your child query as criteria.
