Skip to main content
Question

How do you write a navigator command URL in a timezone aware fashion?

  • May 19, 2026
  • 0 replies
  • 24 views

Forum|alt.badge.img+5

Say that I have a requirement where I need to write a custom command or a command in the Cust layer, to fetch all the Customer Order Lines that has same ‘Planned ship date’ as the one that I have selected.

So I write it as below

client CustomerOrderLines;
component ORDER;
layer Cust;
:

command CGetSameShipDate for CustomerOrderJoin {
   label = "Get Lines With Same Ship Date";
   execute {
      navigate page CustomerOrderLines.List {filter(PlannedShipDate, PlannedShipDate);}}}
--      navigate "page/CustomerOrderLines/List?$filter=PlannedShipDate eq $[PlannedShipDate]";
}

But writing like above or as a Custom command just doesn’t return any data because the entity CustomerOrderLines has timeZoneawareness set in the entity definition as  TimestampTZRef "site(Contract)";

For example below line has Planned ship date/time as ‘6/28/10, 6:00 AM’

 

But the navigated form has the search value as ‘2010-06-28T04:00:00Z’ (and the URL query string is main/ifsapplications/web/page/CustomerOrderLines/List;$filter=PlannedShipDate%20eq%202010-06-28T04:00:00Z;)

 

But what i really need as the search value is ‘2010-06-28T06:00:00Z’. But how do you do that?

 

This issue exists when we have set the TimeZoneAwareness. similar operation done on a timestamp field on an entity without TimeZonEAwareness does not have this issue. (ex: in /page/ObjectTransactionsAnalysis/List; when you filter for ObjectTransactionDate) 

Is there a special property to be set in the URL parameters?