Commencer un nouveau sujet
Répondu

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 ?


Meilleure réponse

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 commentaire

Réponse

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

Connexion pour poster un commentaire