Skip to main content
Question

Lobby Navigation IFS Cloud


COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11

Hello.

I am trying to add in a navigation path to take me through to the Background Jobs overview screen and populate the records which were executed #TODAY#.

 

I have entered the following,

page/BackgroundJobsHandling/BackgroundJobsOverview?$filter=Executed eq #TODAY#

 

When I click the element I receive the following error.

 

Error details: [{"code":"TYPES_NOT_COMPATIBLE","message":"The types 'Edm.DateTimeOffset' and 'Edm.Date' are not compatible."}]

 

Anyone know if I am formatting the URL incorrectly?

9 replies

Shehan Chandrasekara
Sidekick (Former Employee)
Forum|alt.badge.img+8

Try the following URL format:

page/BackgroundJobsHandling/BackgroundJobsOverview?$filter=startswith(Executed,'#TODAY#')
 


COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Author
  • Hero (Partner)
  • 218 replies
  • July 4, 2024

Thanks @Shehan Chandrasekara I have tried this and still receive the same error.


Shehan Chandrasekara
Sidekick (Former Employee)
Forum|alt.badge.img+8

what is the Application version?

 


COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Author
  • Hero (Partner)
  • 218 replies
  • July 5, 2024

IFS Cloud 23R1

Thanks,

Jamie


Shehan Chandrasekara
Sidekick (Former Employee)
Forum|alt.badge.img+8

it seems that direct date-only comparisons are not possible due to the type mismatch (Edm.DateTimeOffset vs. Edm.Date), the best approach is to filter by a datetime range.

 

page/BackgroundJobsHandling/BackgroundJobsOverview?$filter=Executed ge #TODAY#T00:00:00Z and Executed le #TODAY#T23:59:59Z

 

The above URL should work with your requirement.


Shehan Chandrasekara
Sidekick (Former Employee)
Forum|alt.badge.img+8

 

The below could also help,

page/BackgroundJobsHandling/BackgroundJobsOverview?$filter=Executed le #TODAY#T23:59:59Z


Shehan Chandrasekara
Sidekick (Former Employee)
Forum|alt.badge.img+8

Hi @COVJAMIEB ,

 

Was it worked? How is the output?

BR/Sheha


COVJAMIEB
Hero (Partner)
Forum|alt.badge.img+11
  • Author
  • Hero (Partner)
  • 218 replies
  • July 11, 2024

@Shehan Chandrasekara  afraid this didnt work either.

Its weird. Replicating some of the standard element navigation logic doesn't seem to execute the same results.


..only to say this worked perfectly - but in my case for a lobby.

 

whilst it is not intuitive when developing it in the application or covered in the lobby training specifically - this works for CSV defined Date Time parameter in Lobby ‘datasource designer’ by applying the same technique in the filter. I could not find reference to this technique in the technical documentation either.

So thanks ​@Shehan Chandrasekara 👍

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings