I killed myself for hours on this, still never got it but it was created for me by a smarter mind:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | < quer:or > < quer:equal > < quer:field path = "ProfileInformation,Experiences,DisplaySequence" /> < quer:query projectedClass = "Application" alias = "expSubQuery" > < quer:projections > < quer:projection > < quer:maximum > < quer:field path = "ProfileInformation,Experiences,DisplaySequence" /> </ quer:maximum > </ quer:projection > </ quer:projections > < quer:filterings > < quer:filtering > < quer:equal > < quer:field ownerQuery = "expSubQuery" path = "Number" /> < quer:field ownerQuery = "mainQuery" path = "Number" /> </ quer:equal > </ quer:filtering > </ quer:filterings > </ quer:query > </ quer:equal > < quer:isNull > < quer:field path = "ProfileInformation,Experiences,DisplaySequence" /> </ quer:isNull > </ quer:or > </ quer:filtering > |