Solved

Due date not getting filtered when going from lobby to page

  • 4 November 2021
  • 3 replies
  • 275 views

Userlevel 7
Badge +14

We have created a lobby in REGIONAL TEST CMB to display the no of invoices per due date . And we expect when we click on a record to traverse to “ManageSupplierInvoice” and only display the specific no of invoices .

 

EX - fourth record says the count as 9 and if we click on the line it should only display nine records.

 

The lobby is available in Regional TEST CMB under the name supplier Invoice .

 

Lobby details 

This is the web access URL we use page/ManageSupplierInvoice/Form?$filter=(Company eq $[COMPANY]) & DueDate eq due_date.

But it does not work as we expect and it seems it does not get filtered by the due date. when it goes to the page. Kindly advice on fixing this matter :) 

is it a limitation from the framework on using a date variable or is it a syntactical error.

Feel free to do changes to the lobby element if you need to 

icon

Best answer by Himasha Abeywickrama 8 November 2021, 16:31

View original

This topic has been closed for comments

3 replies

Userlevel 7
Badge +18

Hi @Chamaka Wimalarathne,

In the Web Access URL, you have used ‘&’ as the AND operator. Replace that with ‘and’ and it will work. 

page/ManageSupplierInvoice/Form?$filter=Company eq $[COMPANY] and DueDate eq $[DUE_DATE]

 

However, even after setting up like this, you will receive an error saying that the types 'Edm.Date' and 'Edm.String' are not compatible. If you open up the Search box, you can see that the Due Date and Company are correctly fetched but would not populate any data. This could be a bug!

Userlevel 7
Badge +14

Hi @Chamaka Wimalarathne,

In the Web Access URL, you have used ‘&’ as the AND operator. Replace that with ‘and’ and it will work. 

page/ManageSupplierInvoice/Form?$filter=Company eq $[COMPANY] and DueDate eq $[DUE_DATE]

 

However, even after setting up like this, you will receive an error saying that the types 'Edm.Date' and 'Edm.String' are not compatible. If you open up the Search box, you can see that the Due Date and Company are correctly fetched but would not populate any data. This could be a bug!

Hi Himasha,
RND provided a solution (291368) about using one or more variables in a navigate URL and they suggested on using “ & .”

When using more than one parameter for the same navigation in lobby, the parameters need to be separated
using '&' Eg. page/PersonQualificationsCompetencies/List?$filter=CompetencyName eq $[COMPETENCY_NAME]&scope=MIFOLK

 

And about this being a bug Yes you are correct :slight_smile: .

a date related inquiry has been reported from Solution  296772 .

Thank you for your input .

 

Userlevel 7
Badge +18

Hi @Chamaka Wimalarathne,

Nice! Not sure if you already have this but i’ll attach it anyway.