Help Center » Developing Applications » The MQL Cookbook » Find distinct co-types

Find distinct co-types

> I'm trying to form an MQL read query that specifies a type
> (e.g. /business/company), finds all topics of that type, lists all other
> types linked to those topics and returns a distinct list of those other
> types (as per a SQL SELECT DISTINCT... query).
>
> Is there an MQL "shortcut" equivalent to SQL's SELECT DISTINCT?

The trick to this, in MQL, is to turn the query inside out.

You want to find all types who have instances shared with a target type
(/business/company).

{
"query":[
{
"type":"/type/type",
"name":null,
"id":null,
"instance":[
{
"type":"/business/company",
"limit":1
}
]
}
]
}

(The limit clause is in there to keep it more readable and to decrease
the likelihood of timeout.)

Recent Discussions about Find distinct co-types

There are no conversations on this topic. Would you like to start one?

Start the Discussion

Related Help Topics

empty