Is it possible to have a conditional survivorship rule based on a SemQL filter (akin to the filter on privileges)?
F
Fathia Jama
started a topic
over 4 years ago
We have an entity that is only partially sourced (ID matched). The records that are authored directly in Semarchy end up with an override strategy that is not adequate.
Best Answer
F
Fathia Jama
said
over 4 years ago
in such complex situations, you should select the Consolidation StrategyCustom Ranking and write this kind of Ranking Expression
case PublisherID when 'PUB1' then
case when <your_conditions_for_actual_publishers> then 1 else 2 end
when 'PUB2' then
case when <your_conditions_for_authored_masters> then 1 else 2 end
else 3 end ASC, <your_other_conditions_that_could_apply_to_both> ASC
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
1 Comment
F
Fathia Jama
said
over 4 years ago
Answer
in such complex situations, you should select the Consolidation StrategyCustom Ranking and write this kind of Ranking Expression
case PublisherID when 'PUB1' then
case when <your_conditions_for_actual_publishers> then 1 else 2 end
when 'PUB2' then
case when <your_conditions_for_authored_masters> then 1 else 2 end
else 3 end ASC, <your_other_conditions_that_could_apply_to_both> ASC
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
Fathia Jama
We have an entity that is only partially sourced (ID matched). The records that are authored directly in Semarchy end up with an override strategy that is not adequate.
in such complex situations, you should select the Consolidation Strategy Custom Ranking and write this kind of Ranking Expression
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
Fathia Jama
in such complex situations, you should select the Consolidation Strategy Custom Ranking and write this kind of Ranking Expression
This way, you have the capability to return the desired number according to your specific conditions, and also specify any common conditions, that will be sorted ASC or DESC to decide which one should be consolidated.
If my answer does not help, please give me some concrete samples from your masters and desired consolidation, so that I can guide you to the appropriate Custom Ranking Expression.
-
LOV label in Named Query
-
How we can set Dynamically changing Form field Description?
-
Where Do I View 2 Merged Records?
-
Show/hide an attribute in a form
-
Restrict access of attributes
-
Is it possible to manage visible/invisible value in List depend on user role??
-
Why am I unable to merge duplicates?
-
How are child records selected when parent records are manually merged?
-
Can the response from the API Call Response can be formatted differently in the JSON output?
See all 178 topics