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?