No, my question here is more like "how the heck is the getResourcesTag Snippet working AT ALL?" If you store a list of values with a delimiter, e.g. "12,123,456", then searching to see if a TV contains "12" is hard -- LIKE ’12%’ produces false positives. The Auto-Tag TVs should insert the delimiter
before and
after all values in a list so you can write LIKE statements that actually work, e.g. LIKE ’%,12,%’.
Does that make sense? I’m kinda stuck on a variation of the getResourcesTag Snippet and the only database query I have that returns appropriate results is fugly because it has to accommodate 4 possible cases:
WHERE
(
my_tv_val = '12' // TV contains only 1 tag in the list
OR
my_tv_val LIKE '12,%' // The tag we're looking for is at the start of the list
OR
my_tv_val LIKE '%,12,%' // The tag we're looking for is somewhere in the middle of the list
OR
my_tv_val LIKE '%,12' // The tag we're looking for is at the end of the list
)
Does that make sense? If the Auto-Tag stored ",1,2,3," instead of "1,2,3", custom queries would be MUCH easier. The getResources Snippet can’t help me here because it allows only 2 TV filters in its tvFilters parameter. Major bummer.
odeclas -- what do you prefer better than Redmine? I’ve tested at least 20 of these project management software packages and taken some pretty in-depth notes and Redmine is one of only a few that didn’t really suck. I’d be curious to know if there’s something better out there.
☆ A M B ☆
MODX Staff
☆ A M B ☆