JAMROOM
How can i pass multiple parameter in module search?
{jrCore_list module="jrProfile" search1="profile_name = something" search2="profile_url = something else" search3="xxxx = yyyy" . . . }
hth
Pa
--
Paul Asher - JR Developer and System Import Specialist
hth
Pa
--
Paul Asher - JR Developer and System Import Specialist
You can try something like this:
https://www.jamroom.net/the-jamroom-network/documentation/development/89/jrcore-list
--
Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos
{jrCore_list search1="profile_name = something" search2="profile_url = something"}
https://www.jamroom.net/the-jamroom-network/documentation/development/89/jrcore-list
--
Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos
$profile_i = jrCore_db_table_name('jrProfile','item');
$profile_k = jrCore_db_table_name('jrProfile','item_key');
SELECT $profile_i ._item_id FROM profile_k k inner join $profile_i i ON i._item_id=k._item_id WHERE (k.key='profile_name' AND k.value='something')
Next i need to pass
(k.key='profile_url' AND k.value='something')
------------------
Is there any way to write it?
updated by @ashiksh: 09/10/14 08:23:56AM
$profile_k = jrCore_db_table_name('jrProfile','item_key');
SELECT $profile_i ._item_id FROM profile_k k inner join $profile_i i ON i._item_id=k._item_id WHERE (k.key='profile_name' AND k.value='something')
Next i need to pass
(k.key='profile_url' AND k.value='something')
------------------
Is there any way to write it?
updated by @ashiksh: 09/10/14 08:23:56AM
There are many examples of it in the code datastore queries.
Here is one from the action module:
If you could say what your trying to retrieve that would help answering the question.
From you query it looks like your trying to get a specific set of profile names.
If you need multiple search strings then add to the array
Here is one from the action module:
//actions
$_sp = array(
'search' => array(
"_profile_id = {$params['profile_id']}"
),
'skip_triggers' => true,
'limit' => 1000000
);
$_rt = jrCore_db_search_items('jrAction', $_sp);
If you could say what your trying to retrieve that would help answering the question.
From you query it looks like your trying to get a specific set of profile names.
//profiles
$_sp = array(
'search' => array(
"profile_name = 'something'"
),
'limit' => 500
);
$_rt = jrCore_db_search_items('jrProfile', $_sp);
If you need multiple search strings then add to the array
//profiles
$_sp = array(
'search' => array(
"profile_name = 'something'",
"profile_xxxx = 'xxxxxxxxx'"
),
'limit' => 500
);
$_rt = jrCore_db_search_items('jrProfile', $_sp);
