Skip to main content

Please see my images below. I am trying to filter Start Date column and  in Lobby Element Designer using url like below. 

page/ShopOrders/List?$filter=RevisedStartDate ge #START_OF_THIS_MONTH# and RevisedStartDate le #END_OF_THIS_YEAR#   or page/ShopOrders/List?$filter=(RevisedStartDate ge ‘#START_OF_THIS_MONTH#’ and RevisedStartDate le ‘#END_OF_THIS_YEAR#’) , but kept getting and error. Not sure what could be the issue. Thank you very much in advance. 

 

​@jgrace not sure what format is required in Lobby Element Designer, but in the Shop Orders page this would be the format

 

 

Hi ​@jgrace,

I tested this out, and I am also facing the same error. There is no issue with the URL formatting -page/ShopOrders/List?$filter=(RevisedStartDate ge ‘#START_OF_THIS_MONTH#’ and RevisedStartDate le ‘#END_OF_THIS_YEAR#’) since the system is accurately creating RevisedStartDate parameter values on the destination page.

Better raise a support ticket with IFS.

 

Regards

Abdul Rehman

Hi ​@jgrace,

Following are the date related CSV (Context Substitution Variable) values for searching dates available in IFS Cloud Web so far;

  • #TODAY#, #TOMORROW#, #YESTERDAY#

  •  YEAR, MONTH, WEEK
    #START_OF_THIS_#
    #END_OF_THIS_#
    #START_OF_LAST_#
    #END_OF_LAST_#
    #START_OF_NEXT_#
    #END_OF_NEXT_#

However, there have been some issues observed when using these variables in Lobby Datasource WHERE clauses or in navigation URLs. These issues have been acknowledged by the IFS Product Development team and a fix has been provided in version 25.2E.0 (25R2 EA).

 

Best Regards,
Asjath.

 

Reply


Terms & ConditionsCookie settings