Skip to main content
Question

Get number of instances of object type O1 which is related to n instances of object type O2

  • March 26, 2025
  • 2 replies
  • 23 views
Sony Shrestha
Level 2
Forum|alt.badge.img

I want to write PQL that gives me number of instances of object type O1 which is related to n instances of object type O2. Ex: Number of Purchase Order which is related to 2 instances of payment. There is no 1:N relation between these table. In this scenario, is it still possible to get number of instances of one object based on how many times it is related to other object type?

    2 replies

    manuel.wetze
    Level 9
    Forum|alt.badge.img+8

    I think your solution will be including PU_COUNT and some case when. Question is: why is there no relationship if you want to bring them together now? DOMAIN_TABLE could be of help to bring the relationship together in runtime.

    A first draft might if there is a relationship would be:
    COUNT(CASE WHEN PU_COUNT(O1, O2.ID) =2 THEN 1 END)

    Sony Shrestha
    Level 2
    Forum|alt.badge.img
    • Sony Shrestha
    • Author
    • Level 2
    • March 26, 2025

    ​@manuel.wetze There is relationship between two tables but not direct 1:N, Suppose, I have Purchase Order which is related to Payment and I want to find number of instances of Purchase Order which is related to more than one payment. It gives error below

     

    Community Code of ConductAccessibility statement