Start a new topic
Answered

Show the golden very first publisher confirmed in a golden view

Hi, how can I show the golden very first publisher confirmed in a golden view ?


Best Answer

I don't think we have a ConfirmationDate property, so the SemQL that will work best is this:


lookup
first PublisherID
from IntegrationMasterRecords
where ConfirmationStatus='CONFIRMED'
order by CreationDate asc
end


Using this approach translates to:

A) taking all confirmed masters from the golden then 

B) take the publisher from the first created one

1 Comment

Answer

I don't think we have a ConfirmationDate property, so the SemQL that will work best is this:


lookup
first PublisherID
from IntegrationMasterRecords
where ConfirmationStatus='CONFIRMED'
order by CreationDate asc
end


Using this approach translates to:

A) taking all confirmed masters from the golden then 

B) take the publisher from the first created one

Login to post a comment