Sorting cards

[Alex Tweedly]

I'd be happy to look - but my knowledge is entirely LC - never touched 
HC, so that may prevent me seeing something relevant.

Suggestions (that you may have tried already :-) :

1. loop through the cards: put the short ID of this card & TAB & field 
"title" ... after myVariable

then try sorting the items of myVariable.

That might tell you whether there's something odd in or about the 
fields, or whether it's card-specific.

2. Take advantage of the stable sort.
   For those cards that shouldn't move, add a specific custom property / 
value.
   Then, after sorting the way you want the cards, do an additional
      sort cards descending by myNewProperty
   to move those not-to-be-moved ones to the front, and leave all the 
others in their proper order.

Or, feel free to email the stack to me off-list and I'll poke at it.

Alex.

On 01/01/2022 20:10, J. Landman Gay via use-livecode wrote:
> I'm still not having much luck with this. Everything works as expected 
> except that the first 50 cards or so simply don't move. I can't find 
> anything different about them that would explain it.
>
> Anyone out there have an inclination to take a look and find what I'm 
> missing? There's nothing confidential about the stack.
>
>
> On 12/31/21 12:05 AM, J. Landman Gay via use-livecode wrote:
>> Thanks for all the ideas, guys. I seem to get the most consistent 
>> results if I sort by the short ID of each card and then follow that 
>> with the sort for category or title. Because the data was imported 
>> from a text file, the original order is the order of the card IDs.
>>
>> What threw me originally is that some cards don't sort in the order I 
>> expect. A category that starts with B is sorted before a category 
>> that starts with A. I assume the categories retain their original 
>> order when they collect matching cards. A few cards with blank 
>> categories sort to the front (good) but when sorted by title they 
>> remain at the front even though the titles all start with "The". 
>> That's okay because they are summary cards that should be at the 
>> front, but I'm not sure why they stay there during an alphabetical 
>> title sort instead of moving to the Ts. I didn't find any leading 
>> spaces or invisible characters.
>>
>
>