INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Advanced Query Modifiers in Smartlists--Possible?  (Read 1088 times)

Omni

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 827
Advanced Query Modifiers in Smartlists--Possible?
« 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
Logged

RemyJ

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1245
Re: Advanced Query Modifiers in Smartlists--Possib
« Reply #1 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.
Logged
Fedora 38 x86_64 Xfce

Omni

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 827
Re: Advanced Query Modifiers in Smartlists--Possib
« Reply #2 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
Logged

kcorbett

  • Regular Member
  • Recent member
  • *
  • Posts: 41
  • we wanna make him stay up all night here we go
Re: Advanced Query Modifiers in Smartlists--Possib
« Reply #3 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
Logged

TimB

  • Citizen of the Universe
  • *****
  • Posts: 1062
Re: Advanced Query Modifiers in Smartlists--Possib
« Reply #4 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=-
Logged
Boy do I LOVE Media Center!!!
Pages: [1]   Go Up