labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_SoftwareSimpleSearch
Parameters
Name
Type
Mode
search
varchar(75)
IN
page
int
IN
pagesize
int
IN
userid
int
IN
Definition
BEGIN PREPARE STMT FROM "Select a.AppID, a.Name, b.Name, a.Location, a.DateInstalled, a.Size, a.Version, a.ComputerID from Software a, Computers b where a.ComputerID = b.ComputerID and ( a.AppID like concat('%',?,'%') or a.Name like concat('%',?,'%') or b.Name like concat('%',?,'%') or a.Location like concat('%',?,'%') or a.DateInstalled like concat('%',?,'%') or a.Size like concat('%',?,'%') or a.Version like concat('%',?,'%') ) and a.ComputerID in (Select ComputerID From UserSec Where UserID=?) order by a.ComputerID ASC, b.Name ASC LIMIT ?,?"; SET @LIMIT = (page * pagesize) - pagesize; SET @s = search; SET @size = pagesize; SET @U = userid; EXECUTE STMT USING @s, @s, @s,@s,@s,@s,@s,@U,@LIMIT,@size; END