CMS Made Simple Forums

Hi Everyone,

I have the below UDT which queries all inactice items in a LISE instance (LISEBookings):

$mod = cmsms()->GetModuleInstance('LISEBookings');
if (!is_object($mod)) return;

$parms = [
'pagelimit' => 1000,
'showall' => true
];

$item_query = new LISEItemQuery($mod, $parms);
$item_query->AppendTo(LISEQuery::VARTYPE_WHERE, "A.active = 0");
$result = $item_query->Execute(true);

How can I modify it so instead of querying items that are inactive, it queries items that have their Status (field definition) as "Pending"? At the moment, the above code returns all inactive items. However, the inactive items can have their Status as "Pending" or "Expired" which means I then have to filter through the inactive results for items that are Pending.

Can I filter through directly to the items with "Pending" status?

Thanks,

James

I think I've got it:

$mod = cmsms()->GetModuleInstance('LISEBookings');
if (!is_object($mod)) return;

$parms = [
'pagelimit' => 1000,
'showall' => true,
'xs_Status' => "Pending"
];

$item_query = new LISEItemQuery($mod, $parms);
$item_query->AppendTo(LISEQuery::VARTYPE_WHERE, "A.active = 0");
$result = $item_query->Execute(true);