Skip to main content

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?

Try the following URL format:

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

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

what is the Application version?

 

IFS Cloud 23R1

Thanks,

Jamie

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.

 

The below could also help,

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

Hi @COVJAMIEB ,

 

Was it worked? How is the output?

BR/Sheha

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

Reply


Terms & ConditionsCookie settings