Have a look at the UNFINISHED REPAIRS lobby element, I think it does something similar to what you’re trying to achieve and also uses a parameter.

Hi Alexander,

I reviewed the lobby you mentioned. It does not have date range as I was asking for.

This link works

page/PurchaseDeliveryStatistics/List?$filter=VendorNo eq $VENDOR_NO$

However, this still does not work.

page/PurchaseDeliveryStatistics/List?$filter=VendorNo eq $VENDOR_NO$ and RealDeliveryDate ge $REAL_DELIVERY_DATE_FROM$ and RealDeliveryDate le $REAL_DELIVERY_DATE_TO$
 

Please review my images I attached previously. Thank you

I don’t have Purchase data, so I created a simple example using Service Requests This is the lobby with 2 parameters:

This is the lobby element with the navigation:

Navigation URL is page/RequestOverview/RequestManagementOverviewPage?$filter=Created ge $START_DATE$ and Created le $END_DATE$

Thank you for the sample you provided.

When hard coded, works

navigation

page/PurchaseDeliveryStatistics/List?$filter=VendorNo eq $VENDOR_NO$ and RealDeliveryDate ge 2024-07-02 and RealDeliveryDate le 2024-08-02

result url
page/PurchaseDeliveryStatistics/List;$filter=VendorNo%20eq%20'ULINE001'%20and%20RealDeliveryDate%20ge%202024-07-02%20and%20RealDeliveryDate%20le%202024-08-02

When use parameters - errored

navigation

page/PurchaseDeliveryStatistics/List?$filter=VendorNo eq $VENDOR_NO$ and RealDeliveryDate ge $REAL_DELIVERY_DATE_FROM$  and RealDeliveryDate le $REAL_DELIVERY_DATE_TO$

result url

page/PurchaseDeliveryStatistics/List;$filter=VendorNo%20eq%20'ULINE001'%20and%20RealDeliveryDate%20ge%202024-07-01T00:00:00.000Z%20%20and%20RealDeliveryDate%20le%202024-08-06T00:00:00.000Z

Do you think time highlighted has might have cause it? Not sure how it gets added to url. Image # 3, under Advance, it displayed correctly. ((VendorNo = 'ULINE001')) AND RealDeliveryDate >= 2024-07-01 AND RealDeliveryDate <= 2024-08-06 and when cliecked Search it worked. When navigated from Lobby, it did not.

,

Thank you for the sample you provided.

When hard coded, works

navigation

page/PurchaseDeliveryStatistics/List?$filter=VendorNo eq $VENDOR_NO$ and RealDeliveryDate ge 2024-07-02 and RealDeliveryDate le 2024-08-02

result url
page/PurchaseDeliveryStatistics/List;$filter=VendorNo%20eq%20'ULINE001'%20and%20RealDeliveryDate%20ge%202024-07-02%20and%20RealDeliveryDate%20le%202024-08-02

When use parameters - errored

navigation

page/PurchaseDeliveryStatistics/List?$filter=VendorNo eq $VENDOR_NO$ and RealDeliveryDate ge $REAL_DELIVERY_DATE_FROM$  and RealDeliveryDate le $REAL_DELIVERY_DATE_TO$

result url

page/PurchaseDeliveryStatistics/List;$filter=VendorNo%20eq%20'ULINE001'%20and%20RealDeliveryDate%20ge%202024-07-01T00:00:00.000Z%20%20and%20RealDeliveryDate%20le%202024-08-06T00:00:00.000Z

Do you think time highlighted has might have cause it? Not sure how it gets added to url. Image # 3, under Advance, it displayed correctly. ((VendorNo = 'ULINE001')) AND RealDeliveryDate >= 2024-07-01 AND RealDeliveryDate <= 2024-08-06 and when cliecked Search it worked. When navigated from Lobby, it did not.

,

For my example to work I had to specify the parameters as DateTime, Date only gave me an error message.

Alexander,

We are currently using these versions. I don’t see DateTime option in DataType.

IFS Aurena framework version: 21.2.16.20

IFS Aurena client version: 21.2.16.20

IFS OData provider version: 21.2.16.20

 

This is the column I am using from db.

 

Oh, still 21R2. Is that even supported? In that case I cannot help I’m afraid, don’t have that release available anymore.

No problem. Thank you very much for your help. I will just have to do it without date range for now.