Incorrect sorting in payments

?????

Good afternoon, I don’t understand, as if it’s your own idea of payment. At the same time, "Advance payment" is filled in for 1 payment, first of all, then all the rest for changing dates.

Another screen - sorted by "prepayment" and "date of creation" No payments on the new screen 3 19694 19692

For whom, additional work was done specially. I understand that you can’t say for sure if you’re fed, but for those, for like a shoulder strap - can you say more? The day of nourishment did not begin to be observed.

The reason for this situation is explained here https://crm-onebox.com/ru/support/orders/11191-ne-rabotaet-sortirovka-v-protsessah-spiskom/ Vlasne with such a sorting of payments do not appear, the stench is sorted out once for payments, according to which a record was found in the database For example, https://orc-test.kiev.ua/admin/shop/finance/?contractorid=&filterdatefrom=2021-09-20+00%3A00&filterdateto=2021-09-28+10%3A20&filtercomment=&filtersumfrom=0&filtersumto=0&order =&filterlinkkeyorder=0&clientid=&filternobalance=&filteruserid=&filterdirection=0&filterdocumentid=&filtercode=&filterbankdetail=&ok=%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0% B2%D0%B0%D1%82%D1%8C&page=3 So, here, for payment 19503 and higher, there is a record in the database (accept empty), and for 19694 and lower - no

I don't understand It was worth adding that we have two sortings. 1st class of payments. 2nd sort already sorted payments. Axis task: https://crm-onebox.com/ru/support/finances/6156-sortuvannya-za-dodatkovim-polem/ There, put it on, like everything can be practiced and how it worked until the last day.

In the first place, I could not know the source, for you wrote from a different profile. And the axis is an example of how sorting by additional fields functions according to different entities of the system. How to sort products like in the image and go to the page 2 sides, you can mark 2 significant changes in the field Code https://orc-test.kiev.ua/admin/shop/products/?searchLine=&page=64 here 1 goes to 0 https://orc-test.kiev.ua/admin/shop/products/?searchLine=&page=79 here the saving of data on the additional field in the database ends So it works by itself sorting by additional payment fields. [file]11035[/file] [file]11036[/file] [file]11037[/file]

I’ll understand that you are trying to explain to me: if the value was taken - and recorded in the database, and then it was deleted - I’ll do it again, writing to the database is the highest priority, lower just without a record. Ale, I can’t believe in those who fawned over them, mayzhe, didn’t mark them. Exactly s tsim everything was ok, more important functionality. What are the variants of the cherry?

?

This is how filtering functions in the system from the very beginning, at the moment there was simply no respect. You can try before filtering, for example, mass-write the required value in the additional payment field. For the main food - payments are not known.

That stench does not know - I'm throwing off screens de stink. The stench is waking up from filtration, which didn’t happen before. This definitely didn't happen before. Well, you understand, what for yourself for whom was it necessary to do the extra work ???

You write to me at once, what doopration, if it was broken - do not work through the work of the river. І scho I may zim zrobiti?

[quote] Valentine wrote: The stench is waking up from filtration, which didn’t happen before. [/quote] The stench does not know about filtration, but moves, I have shown it. So bulo zavzhdi, you didn’t turn on respect.

I don’t know how it will be earlier than it will be later, but the axis is additional: https://crm-onebox.com/en/support/finances/6156-sortuvannya-za-dodatkovim-polem/ Ale: Payment ID - 1, Additional field - 1 Payment ID - 3, additional field - 0 ID payment - 4, additional field - 1 id payment - 2, additional field - 0 Guilty pratsyuvati: 1. Boxing takes all payments and divides into 2 groups: A) Payments with field value 1 (1, 4) B) Payments with field value 0 (2, 3) Since the sorting by the additional field is in descending order, then first you will be shown group A and then group B. That is. you will see payments 1 and 4 first. 2. If sorting 2 is specified, then payments INSIDE the group will be sorted according to this sorting. Take for example group A. There are payments with id 1 and 4, since sorting in ascending order will show payment 1 first and payment 4 second. Total: one four 2 3 We need food solutions, not comments.

Good afternoon Valentine. The modification you mentioned works correctly. If you add a field and fill it in for only a few payments, sorting may not be done as you plan, since these payments do not have a field filled in and it is not taken into account in sorting. If you take them into account, this will negatively affect the performance of the page (depending on the number of payments, loading can become several times longer). We can one-time fill in all payments the values of the fields by which you filter as empty so that they are taken into account, or you can do it yourself through the bulk changes panel.

Good day Having tried manually putting in a mass order - nothing happened. Less than a part of pcs (30) https://orc-test.kiev.ua/admin/shop/finance/ And can you dorobiti, for example, automatic diy, as if the hour of creation of the update would put “no” in the additional field, or else, because the field has not yet been filled in?

God, let me complete this task, you will go another month at a time. The client is as loyal as possible, why do you need and do the work yourself?

[quote] Valentine wrote: Having tried manually putting in a mass order - nothing happened. Less than a part of pcs (30) [/quote] did you win this option? [file]12073[/file]

Zvichayno, scho vikoristovuvav I have 100 on my side, but not all of the stench was noticed.

Give me permission to filter payments, I'll check what I need to put down the value of all records. What additional field and what values are you trying to remember?

I filter less by actual payments https://orc-test.kiev.ua/admin/shop/finance/?contractorid=&filterdatefrom=&filterdateto=&filtercomment=&filtersumfrom=0&filtersumto=0&order=&filterlinkkeyorder=0&clientid=&filternobalance=balance&filteruserid=&filterdirection=0&filterdocumentid=&filtercode=&filterbankdetail=&ok =%D0%A4%D0%B8%D0%BB%D1%8C%D1%82%D1%80%D0%BE%D0%B2%D0%B0%D1%82%D1%8C&id[0]=21001&id [1]=21000&id[2]=20998&id[3]=20990&id[4]=20989&id[5]=20988&id[6]=20973&id[7]=20972&id[8]=20969&id[9]=20962&id[10]=20958&id [11]=20955&id[12]=20950&id[13]=20949&id[14]=20947&id[15]=20934&id[16]=20932&id[17]=20933&id[18]=20931&id[19]=20930&id[20]=20929&id [21]=20928&id[22]=20927&id[23]=20926&id[24]=20925&id[25]=20924&id[26]=20923&id[27]=20922&id[28]=20919&id[29]=20918&id[30]=20917&id [31]=20916&id[32]=20915&id[33]=20907&id[34]=20908&id[35]=20906&id[36]=20900&id[37]=20901&id[38]=20894&id[39]=20889&id[40]=20884&id [41]=20883&id[42]=20882&id[43]=20877&id[44]=20864&id[45]=21108&id[46]=21107&id[47]=21099&id[48]=21097&id[49]=21096&id[50]=21088&i d[51]=21085&id[52]=21084&id[53]=21082&id[54]=21083&id[55]=21077&id[56]=21076&id[57]=21075&id[58]=21074&id[59]=21073&id[60]= 21072&id[61]=21070&id[62]=21059&id[63]=21056&id[64]=21053&id[65]=21040&id[66]=21037&id[67]=21036&id[68]=21023&id[69]=21016&id[70]= 21015&id[71]=21014&id[72]=21013&id[73]=21012&id[74]=21011&id[75]=21010&id[76]=21008&id[77]=21007&id[78]=20983&id[79]=20865&id[80]= 20853&id[81]=20852&id[82]=20851&id[83]=20850&id[84]=20848&id[85]=20843&id[86]=20841&id[87]=20837&id[88]=20836&id[89]=20835&id[90]= 20829&id[91]=20827&sortkey=custom_tipplatezha3&sorttype=DESC [file]12077[/file] I want to set "prepayment" = No

?)

Okay, I protest. But don't solve the problem. Can you tell me how I wrote more? "Can you do it, for example, automatically, for example, if the hour of creation of the update would put "no" in the additional field, or else, because this field has not yet been filled in?

Yes, you can make an automatic action once a day, which will fill in the selected additional field for payments if it is not filled or empty or there is 0. It will take about 2 hours