Any Better Way to Strip the Fractions of Seconds from a Posix Time?

Question 1

質問

Jean Millette · 2025年8月14日

Is there a better way (i.e., without string commands) to remove the fractions of seconds from a %Library.PosixTime value?

This works, but seems inefficient:

set posix = 1154669852181849976
w ##class(%Library.PosixTime).LogicalToTimeStamp(posix)
2025-05-27 12:06:15.003
set str = ##class(%Library.PosixTime).LogicalToTimeStamp(posix)
set stripped = $P(str,".",1)
w ##class(%Library.PosixTime).TimeStampToLogical(stripped)
1154669852181846976
set newposix = ##class(%Library.PosixTime).TimeStampToLogical(stripped)
w ##class(%Library.PosixTime).LogicalToTimeStamp(newposix)
2025-05-27 12:06:15

Note that I don't need the last string output; the value stored in "newposix" is what I want to retain.

Thanks in advance

8 Comments

ディスカッション (8)3

続けるにはログインするか新規登録を行ってください

Question 2

質問

Aaron Laferty · 2025年8月14日

#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)

}

ディスカッション (0)1

続けるにはログインするか新規登録を行ってください

検索

Any Better Way to Strip the Fractions of Seconds from a Posix Time?

ZenPage Table not Updating

[Video] Testing Non-functional Requirements in Applications

Exploring the Carolinas: The Ultimate Travel Guide to North and South Carolina

The Charms of North Carolina

The Smoky Mountains

The Historic Charm of Asheville

Coastal Escapes: Outer Banks

South Carolina: A Blend of History, Culture, and Coastline

Charleston: Where History Meets Southern Hospitality

Myrtle Beach: Family Fun by the Sea

Hilton Head Island: Relaxation and Recreation

A Hub for Outdoor Adventures

Hiking and Camping

Water Sports and Fishing

Carolinas: A Cultural Tapestry

Music and Festivals

Historic Sites

Planning Your Trip: Tips and Recommendations

Conclusion

FAQs

InterSystems IRIS for Health : la solution la plus rapide pour optimiser les données de santé

DU TABLEAU BLANC À LA PRODUCTION, RAPIDEMENT

CONÇU POUR LES GRANDES VOLUMÉTRIES

ACCÉLÉRER LES CONNEXIONS

UNE INTELLIGENCE PLUS PROFONDE

CONNAISSANCE APPROFONDIE