Skip to main content
Question

Lobby Navigation IFS Cloud

  • 4 July 2024
  • 8 replies
  • 73 views

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: s{"code":"TYPES_NOT_COMPATIBLE","message":"The types 'Edm.DateTimeOffset' and 'Edm.Date' are not compatible."}]

 

Anyone know if I am formatting the URL incorrectly?

8 replies

Shehan Chandrasekara
Rank
Userlevel 4
Badge +8

Try the following URL format:

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

COVJAMIEB
Rank
Userlevel 4
Badge +11

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

Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
Shehan Chandrasekara
Rank
Userlevel 4
Badge +8

what is the Application version?

 

COVJAMIEB
Rank
Userlevel 4
Badge +11

IFS Cloud 23R1

Thanks,

Jamie

Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/
Shehan Chandrasekara
Rank
Userlevel 4
Badge +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
Rank
Userlevel 4
Badge +8

 

The below could also help,

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

Shehan Chandrasekara
Rank
Userlevel 4
Badge +8

Hi @COVJAMIEB ,

 

Was it worked? How is the output?

BR/Sheha

COVJAMIEB
Rank
Userlevel 4
Badge +11

@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.

Opinions are my own and not the views of my employer or IFS. Feel free to connect with me - https://www.linkedin.com/in/jamie-baird-29615591/

Reply


Terms & ConditionsCookie settings