locked
collection query (WQL) to get all sub collection systems into Master Collection1 minus system in other Master collection2 RRS feed

  • Question

  • Hi Team,

    I am working on a collection query(WQL not SQL) to get systems from all sub collections into master collection1 without hardcoding subcollection IDs and then minus systems into Master Collection2 - (have  created SQL query but as you know it will not supported in WQL)s

    what I need is WQL query for collection like below

     Master Collection1 =  Machines of all sub collections(sub to sub also) under master collection1  - (minus)  Machines in Master Collection2 (which also include systems from all its sub collections)

    Collection structure like –

    Master Collection2
              --------SubCollection
                          ---SubtoSubCollection
             ---------SubCollection
                         -----SubToSubCollection

    Master Collection1
                    ———-SubCollection1
                    ———-Subcollection2
                                            —–Link Collection1
                   ———-SubCollection3
                                  —– SubCollection4

    Regards
    Prashant

    Sunday, February 16, 2014 6:13 PM

Answers

All replies