View Single Post
Old 10-16-2011, 07:22 AM   #15
Noughty
Addict
Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.
 
Posts: 352
Karma: 103850
Join Date: Apr 2011
Device: Kindle NT
Basically these 4 columns manipulate shelves and tags. In tags I have 102 items, shelves about 118. That's why I created these other columns to make it neater. I categorize all items in tags and shelves into a few categories:
genre (40 items),
character (58 items),
mode (22 items),
and whatever is left (84 items).


GENRE:
Code:
program:
	list_union(
		list_intersection(field('tags'), '40 tags&shelves listed', ','),
		list_intersection(field('#shelf'), '40 tags&shelves listed', ','), 
		',')
CHARACTER:
Code:
the same as above just different tags,shelves listed. Total 58 items
MODE:
Code:
the same as above just different tags,shelves listed. Total 22 items
LEFTOVERS :
Code:
program:
list_sort(
   list_difference(
      list_union(field('#shelf'), field('tags'), ','),
      list_union(
         "delete", 
         strcat(field('#genre'), ',',
                field('#mode'), ',', 
                field('#character'), ',',
                field('#length')),
         ','), 
      ','),
   0, ',')
I just changed this one to, #length wasn't needed here, only word Short:
Code:
program:
list_sort(
   list_difference(
      list_union(field('#shelf'), field('tags'), ','),
      list_union(strcat('Short', ',',
        'delete'),
         strcat(field('#genre'), ',',
                field('#mode'), ',', 
                field('#character')),
         ','), 
      ','),
   0, ',')
And I have a few more columns like tags but they are simple columns.
Length has 4 values, status-6,managing-22, anthology-18 and a few more. But nothing major and with very few values.

Last edited by Noughty; 10-16-2011 at 07:33 AM.
Noughty is offline   Reply With Quote