I have a project that loads work order templates into a template repeater limited to max of 100. The repeater will load in the designer but when I open the same window in the client it will not. It is also worth noting that the same repeater will load on some computers in the client while not at all on others, like mine.
The template has 15 parameters to fill in the location, status, colors, etc. I supply the template params via a single query from our database shown below.
On the computers that work it takes a few seconds to load but does load. Mine can be left for 30 mins without loading anything.
Originally I thought it was the query performance causing loading issues but that doesn't make sense given the difference of client vs designer on my computer. I then thought it was a rendering issue and the computer being fast enough but again client/designer difference throw that out.
I'm at a loss for why this is happening. Any ideas?
param query
SELECT
*
FROM
(
SELECT
r.id as "id",
e.Name as "Requester",
title as "Title",
detail as "Detail",
`timestamp` as "Submitted",
a.tag as "Area",
a.id as "aId",
a.color as "AreaColor",
r.priority as "PriorityId",
p.color as "PriorityColor",
p.tag as "Priority",
r.top as "top",
r.images as "images",
CONCAT(
"R",
LPAD(r.id, 4, "0")
) as "rId",
r.clockNumber as "ClockNumber"
From
Requests r
JOIN ShopOrderData.Employees e ON r.clockNumber = e.ClockID
JOIN Area a ON a.id = r.area
JOIN Priority p ON p.id = r.priority
) as request
JOIN (
SELECT
rh.requestId,
s.id as "StatusId",
s.status as "Status",
s.color as "StatusColor",
rh.id as rhId
From
RequestHistory rh
JOIN Status s ON s.id = rh.statusId
WHERE
rh.id IN (
SELECT
MAX(id)
From
RequestHistory
Group By
requestId
)
) AS history ON request.id = history.requestId
LEFT JOIN (
SELECT
eqc.reqid,
eqc.equipment as "Equipment"
FROM
Equipment_conn eqc
) equip ON equip.reqid = request.id
LEFT JOIN (
SELECT
eq.equipment,
eq.description as "EquipmentDesc"
FROM
Equipment eq
) equipd ON equipd.equipment = SUBSTRING_INDEX(
SUBSTRING_INDEX(
SUBSTRING_INDEX(equip.equipment, '"', 2),
'"',
-1
),
',',
-1
)
WHERE
(
SELECT
IF("{searchString}" = "ALL",
TRUE,
ClockNumber = CAST('{searchString}' AS SIGNED)
OR Requester LIKE '%{searchString}%'
OR Title LIKE '%{searchString}%'
OR CONCAT(Requester, Title) LIKE '%{searchString}%'
OR id = :partToRequest
OR CONCAT(
"R",
LPAD(id, 4, "0")
) LIKE '%{searchString}%'
OR equip.equipment LIKE '%{searchString}%'
OR equipd.EquipmentDesc LIKE '%{searchString}%'
)
)
AND history.StatusId in {statusFilter}
AND IF(
:AreaFilter > 0,
(aId = :AreaFilter),
True
)
AND IF(
:hideCompleted,
(Status != 'COMPLETE'),
True
)
ORDER BY
request.id DESC
LIMIT 100
