Start a new topic
Discussions xDM xDM - Data Certification
Answered

publisher unavailable on SemQL validation form on post-consolidation scope

Hello ,

I need to implement a SemQL validation in post-consolidation scope  like discussed in this forum topic  Cross parent-child entities validation.

But I was surprised to find that in post-consolidation I don't have acces to the PublishedID attribute to use in my SemQL condition! 

How can I work around this issue?

Best Answer

Hello Joao,


semQL is not exactly like SQL. In fact, accessing children entities in semQL is allowed by the automatic syntax "any" or "all" conditions.

The associated documentation is here : https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/SemQL/related-entities-attributes.html#_child_entities 

Your semQL could look like this : 

any childEntityRecord has (1=1)


It means in this example, that at least one childEntityRecord exist and is available in GD, which would mean that it did not fail with its pre-conso validation for the child record.


I hope this helps.

Stéphanie.

2 CommentsSorted by Oldest First

Besides that,  SourceID is also not accesible in the post-consolidation scope.

My question is then, how do we manage to make JOIN condtions in SemQL with related entities a the Golden Tables level ? 

Answer

Hello Joao,


semQL is not exactly like SQL. In fact, accessing children entities in semQL is allowed by the automatic syntax "any" or "all" conditions.

The associated documentation is here : https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/SemQL/related-entities-attributes.html#_child_entities 

Your semQL could look like this : 

any childEntityRecord has (1=1)


It means in this example, that at least one childEntityRecord exist and is available in GD, which would mean that it did not fail with its pre-conso validation for the child record.


I hope this helps.

Stéphanie.

Login to post a comment
More topics in xDM - Data Certification
See all 55 topics
Help Desk Software by Freshdesk