blog documentation FAQ followers forum marketplace services youtube

searching multiple like patterns

The Jamroom Network » Forum » Using Jamroom » Page » searching multiple like patterns
blindmime
@blindmime
3 years ago
772 posts
I'm trying load a player where the profile name is something or where a variable called "audio_credits" contains a phrase. search1="profile_name LIKE %`$_post.play`% || audio_credits LIKE %`$_post.play`%" ignores the audio_credits query. It's also ignored if I do this: search1="profile_name LIKE %`$_post.play`%" search2="audio_credits LIKE %`$_post.play`%".

If I do either of them alone, each works. What am I missing?
updated by @blindmime: 11/23/21 05:45:30AM
michael
@michael
3 years ago
7,692 posts
That search WILL NOT SCALE. 'Like' queries are already slow and each time you add another % to it, its getting slower still.

ok, so given that whats the issue...... It looks like you have 2 types of datastore items listed. you have 'profile_name' which would be searching the jrProfile modules datastore and also 'audio_credits' which would be searching the jrAudio modules datastore. What does the 
module=""
part of the request look like?
blindmime
@blindmime
3 years ago
772 posts
jrAudio

Tags