INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Omni on April 12, 2003, 01:46:27 pm

Title: Advanced Query Modifiers in Smartlists--Possible?
Post by: Omni on April 12, 2003, 01:46:27 pm

If this is not doable, that's okay.  I don't want to come off like someone who asks for too much. :D

Can string searches be done within the queries for smartlists?

Specific example:  I use MC to rip my CD's.  (I don't care about CUE sheets, so using "Secure Mode" beats using EAC in my book.)  For the scratched/damaged CD's, I save the SecureRip.log file and also update each track's "Comment" field with the "Quality XX.YY%" string from the SecureRig.log file.

May Be Doable:

How do I list only the entries that contain the substring "Quality" in the "[Comment]" field?

Highly Doubtful It Is Doable:

Is there a way to extract the number, i.e., the XX.YY, from the string and use that number with other qualifiers.  For instance, list only entries where XX.YY is greater than 80.00 (XX.YY > 80.00)?

Omni

Title: Re: Advanced Query Modifiers in Smartlists--Possib
Post by: RemyJ on April 12, 2003, 02:41:57 pm

The first one's easy:  

comment=[Quality" finds anything starting with "Quality".
comment="Quality]  find anything ending with "Quality".
comment="Quality" finds anything with "Quality" in it.

Don't think there's a way to do a compare on a substring right now, especially in a text field like comment, but you could create a new database field called Quality with a type of decimal.  Of course you'd have to move your existing values from comment to the new field.

Title: Re: Advanced Query Modifiers in Smartlists--Possib
Post by: Omni on April 12, 2003, 03:16:20 pm

Hey, I actually ended up using both your suggestions!

I added a decimal "Quality" field, and then used the comment="Quality" modifier to list the files I needed to update, and then I went through and updated each tag accordingly.  (I didn't have that many bad files, it wasn't too hard.)

Now I can use the qualiifer Quality: >= 90.00 in my query.

This program is just too powerful for its own good, I tell ya. :D

Omni

Title: Re: Advanced Query Modifiers in Smartlists--Possib
Post by: kcorbett on April 14, 2003, 10:51:14 am

I'm doing something similar to tag files that are "broken" (jitter or other quality problem). I enter "broken" as the value in the keywords field. I created a smart list that finds all entries with keywords=broken.

/kmc

Title: Re: Advanced Query Modifiers in Smartlists--Possib
Post by: TimB on April 14, 2003, 10:52:57 am

Quote

This program is just too powerful for its own good, I tell ya. :D

Omni

SO true.

:)

-=Tim=-