ZenPage Table not Updating

Question

Question

#JavaScript #ZEN #HealthShare #Caché #InterSystems IRIS

Hi all,

I’m running into an issue with a %ZEN.Component.tablePane in a Zen page.

We have:

A fully styled table with all columns defined
A backend query (SearchMessages) that accepts multiple filter parameters
A set of input fields at the top of the page for filtering (text, date, and checkboxes)

We’re trying to run the query from a button click using a client-side method (runSearch()) that collects the filter values, sets them as parameters, and calls executeQuery().

The problem is that the table does not update at all. Old rows remain, or sometimes nothing appears. I am struggling to debug this issue and anyone with experience making zen tables and updating them using queries would be extremely helpful. Below is a bit of my code

</group>

</group>

</group>

</group>

</group>

</group>

</group>

</group>

</group>

</group>

</hgroup>

<tablePane id="resultsTable"

autoExecute="true"

queryClass="MD.UI.MessageTrackingQuery"

queryName="SearchMessages">

</tablePane>

/// JS to run the search

ClientMethod runSearch() [ Language = javascript ]

{

function normalize(value) {

return (value === "" || value === undefined) ? null : value;

}

function normalizeDate(value, endOfDay) {

if (!value) return null;

// Otherwise append start or end of day

return endOfDay ? value + " 23:59:59" : value + " 00:00:00";

}

var params = {

DocumentID: normalize(zenPage.getComponentById('filterDocumentID').getValue()),

DocumentSource: normalize(zenPage.getComponentById('filterDocumentSource').getValue()),

SessionID: normalize(zenPage.getComponentById('filterSessionID').getValue()),

MessageControlID: normalize(zenPage.getComponentById('filterMessageControlID').getValue()),

PersonID: normalize(zenPage.getComponentById('filterPersonID').getValue()),

SourceFacility: normalize(zenPage.getComponentById('filterSourceFacility').getValue()),

EventType: normalize(zenPage.getComponentById('filterEventType').getValue()),

EncounterNumber: normalize(zenPage.getComponentById('filterEncounterNumber').getValue()),

MessageDateFrom: normalizeDate(zenPage.getComponentById('filterMessageDateFrom').getValue(), false),

MessageDateTo: normalizeDate(zenPage.getComponentById('filterMessageDateTo').getValue(), true),

SendTimeFrom: normalizeDate(zenPage.getComponentById('filterSendTimeFrom').getValue(), false),

SendTimeTo: normalizeDate(zenPage.getComponentById('filterSendTimeTo').getValue(), true),

IsActive: zenPage.getComponentById('filterIsActive').getValue() ? 1 : null,

IsDuplicate: zenPage.getComponentById('filterIsDuplicate').getValue() ? 1 : null,

LastUpdateFrom: normalizeDate(zenPage.getComponentById('filterLastUpdateFrom').getValue(), false),

LastUpdateTo: normalizeDate(zenPage.getComponentById('filterLastUpdateTo').getValue(), true),

OriginalMessageID: normalize(zenPage.getComponentById('filterOriginalMessageID').getValue())

};

console.log("Starting to get results");

console.log("Filters:");

console.log("------------------------");

for (var key in params) {

if (params[key] != null && params[key] !== "") {

console.log(key + ": " + params[key]);

}

// Assign to tablePane parameters and run query

var table = zenPage.getComponentById('resultsTable');

table.parameters = params;

console.log(table.parameters);

table.executeQuery(true, true);

console.log(table.getColumnFilters());

}

Query SearchMessages(DocumentID, DocumentSource, SessionID, MessageControlID, PersonID, SourceFacility, EventType, EncounterNumber, MessageDateFrom, MessageDateTo, SendTimeFrom, SendTimeTo, IsActive, IsDuplicate, LastUpdateFrom, LastUpdateTo, OriginalMessageID) As %SQLQuery

{

SELECT DocumentID, DocumentSource, SessionID, MessageControlID, PersonID, SourceFacility, EventType, EncounterNumber, MessageDate, SendTime,

IsActive, IsDuplicate, LastUpdateTime, OriginalMessageID

FROM MD.MessageTracking

WHERE (DocumentID = :DocumentID OR :DocumentID IS NULL)

AND (DocumentSource = :DocumentSource OR :DocumentSource IS NULL)

AND (SessionID = :SessionID OR :SessionID IS NULL)

AND (MessageControlID = :MessageControlID OR :MessageControlID IS NULL)

AND (PersonID = :PersonID or :PersonID IS NULL)

AND (SourceFacility = :SourceFacility or :SourceFacility IS NULL)

AND (EventType = :EventType or :EventType IS NULL)

AND (EncounterNumber = :EncounterNumber or :EncounterNumber IS NULL)

AND (MessageDate >= :MessageDateFrom OR :MessageDateFrom IS NULL)

AND (MessageDate <= :MessageDateTo OR :MessageDateTo IS NULL)

AND (SendTime >= :SendTimeFrom OR :SendTimeFrom IS NULL)

AND (SendTime <= :SendTimeTo OR :SendTimeTo IS NULL)

AND (IsActive = :IsActive OR :IsActive IS NULL)

AND (IsDuplicate = :IsDuplicate OR :IsDuplicate IS NULL)

AND (LastUpdateTime >= :LastUpdateFrom OR :LastUpdateFrom IS NULL)

AND (LastUpdateTime <= :LastUpdateTo OR :LastUpdateTo IS NULL)

AND (OriginalMessageID = :OriginalMessageID OR :OriginalMessageID IS NULL)

}

Product version: IRIS 2022.3

Discussion (0)1

Log in or sign up to continue