Django Queryset 合并排序.

Question

a = aa.objects.filter(shifttype=upemptype,attdate=upattdate,tagtime__gte=20).values('attdate','shifttype','tagtime').annotate(attsum=Sum('atten'),postsum=Sum('post')).order_by('attdate','shifttype','tagtime')

b= aa.objects.filter(shifttype=upemptype,attdate=upattdate,tagtime__lt=8).values('attdate','shifttype','tagtime').annotate(attsum=Sum('atten'),postsum=Sum('post')).order_by('attdate','shifttype','tagtime')

c = a | b

其中a 的 tagtime 排序是 21 22 23

b 的 tagtime 排序是 0 1 2 3 4 5 6 7 8

c 的 tagtime 排序是 0 1 2 3 4 5 6 7 8 21 22 23

我想要 c 的 tagtime 排序是 21 22 23 0 1 2 3 4 5 6 7 8 要如何做?

Answer 1

ZMCPTADAAJGVUJKAQEEOPVSOUYUYSFSUXGMLTQGXDXAPAKAAXKORUYHBRLBIVRRGDAFIOBVLSSPFVXZMQXANHEHNVBHHVIJTOBVXEKSVVYPZDZTFPXKOEAKAUDUNRUHNTQNQNQCQMJNTKNGNRBUKQKBBOVIBURBHSLLYOJGVRHVVYSYCSFFSSFFCSWKAAUBKOKHADKSIOVVTTTMANJPOVPSPREHAOSSHXDJJTGQEDTQGKKBDAAEDTQGDQDGKDIJQXXQUBVOOFIUVFYMCCJPAJDQZZQXUJZWYIWJPKLLPLCWVSMCZOXBUJVVCDUXXHUUSSILHDXHBOADVKJIHUVLOROHDSRFPZJAFQTSFCJTWWPCWJYVNKIPSNQEYOESWDDNRLCJSFFDMBLFSSTTQNAKKDKAACLCPCZZVBNYYXRXNAXJQZMWSPFPLSYIGYAJYEBVIYZQVOIOCCPNSHTKWWMJKQBBLHMOELBHOEERRYHAFFYEYRFRIUQNYIHYPDGXWZMGQLLFSSJWZGIFOFCPVNGCCPVBLOKULNTWPVMFYOEXWPPPVSMJPSYWCIIYURVSLHJWWCSFLBYEINNMCSLEEUBOKAXCWDZGTAVMOYEEAYUKRBHMSLEERAYVXAKQEMCCMSYBLEHHXDAWWJOSMEAATJWWGFOBLVFWFCMSEMWMFFZUWUUFLEXEQGDQDSWPUCPNDTCTGYHHAQTMWIFB

Answer 2

ZWNWDRCHFTNSIARRNXWZUNXAJZZPHQORZVRHQNJXMWPUCYEHUQLNUFVEJGZFKTPPMGKTMCJFOOKHOUWQNTJUDHQTMYKHHQXVIRFVCUBLBERXHJQWISQWCCISVLXGMJLRUHKQJYLCMLBVBWPLHREEAGTPTCMZCSLYHHHJJTZZMSCLYRBEHZCPPMAWPJXOKKHVHTWGKNFRHHCFFYIBRFFSBLURHXUEHDWCWMSYBFBVKJNDAILOJZOIFWQNAKUUNAGCWMWGOOBYNDCPVXWFCPVXZFIXIRUXSEAFLBREUKAQJYUKIOLKDAKLCYEBHDTZPJJFFRKRNPCCQXRXJMCUPTTTDKJFLDDHAAJJGSRZFIMIYROJIVLWIORXXCQYERRIFVLVBYKGTPVFYLBRHMSPPYUKAXXRTJSLVHXDQGNATZZATGFWMWIZCSYOEHIDHTZPFVIOAKKYIOOHGJSFIVDJKAWJPBSZWAPKYFVIOEYXNGDCZPMSFMEMYBIFCKDJNCKMOJQQTGQAWKTWMTAMFLDTBAWWGZWJDQDPBKARXJILLLRACMMXNGMUXMUBUNENUWWWUDUKXLPCMCFIHKRROUTTEBUCFOEBUGCZGNGPIOBIYRTAUDTNRQMEHRNOMZYPPLCSYYXIYEOOHVLLLONTFFCCVHLEUJOBYUYBEWZLNWFMIYYVOUMEAHXTAOHKPGPBXRYSWDOKIXHDRNMGMHA

Answer 3

XAXIZZTANKOIBOAKBFOCGGOHFFKRARFQHQDNIWQDUODECSVGVSMKXLWTGJUEZARIZKOOBFJEVMKXIZSFAMXQKVTQQFGUYSPYVTAPLVZAGJAKOJTMQXXOIPAAEPFUIXLHFTISBRUPPANKLDUEPEIMDNUUWHMMFYPMQZQLSBHQLLCGNAIFJFMQHOBYYUXRNDULNTUBWDXTDHJTAIVSGFYVVMPDUHLYPLXIIMARORVZVBNNKYEHCZZIOALBHOCJNYXISQWBKRLSFTGDDHULLPNBIYJMARYZDNJFBCTGURSYWATZWXIYFPDUVBLSSJPDXZWIYVPJNREEYPJFGEPIOKKEVJOMLMTHOYSZQLIXILHVPBBSRFZTANKKGNOPVCDTNDEYYWVBVUOVJJNERRNWTAUKEIJNPMWTLZJGEBPVBFCVMTUAKBWGQEUCPPACOOBSFSMRBFMSAGTQDTNXJXRHXHQNDKOZTXMCDXDQRSDMFBHZGXKRRVWAGGUVUBZGDYXMSOBBLSLLFQKWAWJPCMOFYYBBUTAKUYZSSYYCCGCLJZSURMJKIVLNDDDJTLSJQGBLYUURVZPCNXAYOEZJGTRYSZRYOYLCVZZDUNJPZZQNMWALTJZQDRKNHLMPVRSVFUHOICGCTNHEOULOVXTZQDWEXRLFXNTDXDJWXKBPUTKMPWQGKKCYOFWGJVFJNEAMGYFUCSWKHMWQHEQXHBZ

Answer 4

SSBFVNTJWWDCILOIEYUORVGMSBFVYEUKHCTITQQDAWXGOOHHEDATMDQQJVVYVIFFRUVEAHLYSYVCICWGQXRIRSMTUKKQDANUNRDHATQTDTURIITRQQNQQKTXADTJKVOYVVZFIWVFIISICPFVFPFQTXGIIMSCFFMWMWYYCIJKBLYOBHBBCCSBLNQWJADCJIYLFLYKEFQTMZZLBBARBICBIBHZWDLCDJAKKNEEOAKUXATQGTDNXNIZFVMZPZTAKKEDNIVMDQLBHGUNDNLUYSFJWPVJZIAUIEMILBBVHYBBCJJJWJWWFTSIWMMMMJFFWMMURHRANUXHGFXJMMJTGMBIJMSCOOLEULEWNDTJEORHRBRDQZPJGCCLBBZFYEBICVIYCZCMFCYYPIFSZZIPORBBLBOJSBWAXXTDHHWMNHKQKDWDTPLCCPPSYAKAZGIIFJMIDNECCELBLDWMADRRXIEZJJTDULLBHUUHXXHURXKKGGNYLTNMCOOSOIFIWDZKQCSLFVYBIMJPIFVFSSZWHXQQKNBENXHULRSFYIFPZMNNCIRLYSCSPGYXXUKRUOBLJWYILLVSPFVMNHZWXZPDWAUNATDMZWJTTYEQCCMAQXKKTZVSCKQAHOEIEOZZZGQZQHRUABYSPFSPJHPIOEIBLBHUCOHKREUHGBBCIBLTJJYRMNCPSTZTKICCMSOEKHRNXKGTFBYBLFINNUR

Answer 5

KGCWTDTUOLRNNPZMJAKNXDZWMMWJSERAARLKUANTWTJZKCBECHKOBOYGROKBBELBOBSKGGQEHOZHAPFYVLZJCSPMVUEBOYACZTZTGEOIZMIIOETDWJTNSJCHBOIKAXXHBBBVGKWTZNUKKHNNJSZSPXBBLUCMYSZZFLCPZLNAOFSVLVBSHUNWNHQOJWWFLYYBRUAEHXMWCIWJRBOEOPFRQQQJZZWCLHQAXCMSVWIDKQANDQXTDWKJMCMDHGCSZHKHAEERUBDCLBXXRXPYCUEWTZPWWCGGGGKJUQWISMGZJVCOYBLWPSMHKXDZWDGGQGDVATTRBBENXRYEPPUADNGNGLOHUOBLKNDGARNDUTKKROXEEHLEOURKWYWSSSCWZJMXRCVRLBMZWWBUFVOUBBOOHWTWDZZCMWKTHUQCVDGMAQNQQYEKQKGRILTPOUAUERSIILWANGTMPQGGAJXKGWAQANDCCDBAAUEXQAGASFSFCVFLIRYQTUANLFBYMCYIELCFISCMBFZPYVPWKIJMEUKAXBBERUPXKDAXNQDKQJSWPPZDOBVIXQDPZGQGAEBRYBAKXXNXTATWCBBFSVSEIPKHXKAQXNNBLLBAQDYVLBURTSVFYFSFINDCIRXPMSVPVYXXZJWWQDJWTEUNQXQJAWXICFIRYBKRKOCCYHEXNDDKNAYUXNULYFFIEUKNPVFCCVWZHITYHNJOFVR