Skip to main content
Question

Navigation to Work Tasks for Lobby Element


jbernardo
Hero (Partner)
Forum|alt.badge.img+13

There is a similar question in the community here

However, i have replied/tested out what was here for Work Tasks and havent been able to get the same result.

I entered the following into the Navigation URL of the element designer

page/WorkTasks/List?$filter=Objstate ne IfsApp.WorkTasksHandling.JtTaskState'WORKDONE' and LatestStartTruncated eq #TODAY#

and receive the following error

 

IFS Web Version: 23.1.3.20230705170642.0
Date: 2024-03-07T15:30:26.049Z

---------------------------------------------------------------------------

WorkTasks/List (server error)
Malformed Request.
Error details: [{"code":"EXPRESSION_PROPERTY_NOT_IN_TYPE","message":"The property 'LatestStartTruncated', used in a query expression, is not defined in type 'IfsApp.WorkTasksHandling.JtTask'."}]

Request Id: 52783eec-c241-4f02-b0d0-166427301f7f

Url: https://pdip8uw-dev1.build.ifs.cloud/main/ifsapplications/projection/v1/WorkTasksHandling.svc/JtTaskSet?$filter=(Objstate%20ne%20IfsApp.WorkTasksHandling.JtTaskState%27WORKDONE%27%20and%20LatestStartTruncated%20eq%202024-03-07)%20and%20(Objstate%20ne%20IfsApp.WorkTasksHandling.JtTaskState%27WORKDONE%27%20and%20LatestStartTruncated%20eq%202024-03-07)&$select=AdjustedDuration,CWorkSent,WoNo,WoStatus,QuotationNo,QuotationRev,TaskSeq,CustomerNo,ActualConnectionType,Objstate,OnHoldDb,Objgrants,TransferredToMobile,IsOnHold,Company,PreAccountingId,Site,DocumentTextCount,NoteId,ActualObjectId,ActualObjectSite,HasSignature,SlaOrderNo,SlaOrderLineNo,EquipClassificationExists,EquipmentObjectSeq,ActualObjConnLuNameDb,ActualObjectDescription,LinastInstalled,ActualObjConnRowkey,ReportedConnectionType,ReportedObjConnRowkey,ReportedObjectId,WoObjectCurrentPos,IsReleased,IsActive,TaskObjectCurrentPos,HasResourceDemands,IsInternallySourced,Duration,HasCrewDemands,DuplicateTypeDb,WoConnectionType,WoHasStructure,Description,Dependencies,ExcludeFromScheduling,AppointmentBookingAllowed,CancelAppointmentAllowed,FinallyPosted,HasCostLines,HasWipAccounting,InspectorSignOffExists,InspectorSignOffPerformed,IndependentSignOffExists,IndependentSignOffPerformed,PlannedStart,ReportedBy,CreatedBy,OrganizationSite,ContractId,LineNo,WorkTypeId,EventId,SrvRequestScopeId,OrderNo,LatestStart,AllowMultipleVisits,GenerateNote,ItemClassId,ItemClassSource,MaintTeamSite,OrganizationId,TeamId,EarliestStart,LatestFinish,PriorityId,ReportedObjConnLuNameDb,ReportedObjectSite,luname,keyref&$expand=SlaOrderLineNoRef($select=SlaLatestFinish,ResolvedDate,luname,keyref),SiteRef($select=ContractDesc,luname,keyref),OrganizationSiteRef($select=ContractDesc,luname,keyref),OrganizationIdRef($select=Description,luname,keyref),MaintTeamRef($select=Description,Objgrants,luname,keyref),PriorityIdRef($select=Description,Objgrants,luname,keyref),ReportedObjectSiteRef($select=ContractDesc,luname,keyref)&$skip=0&$top=25

---------------------------------------------------------------------------

Error makes it sound like that field doesnt work. However when you do DateEnteredTruncated on the Customer Work Orders screen, it works fine and DateEnteredTrucated isnt a field that exists on that table

2 replies

Charana Udugama
Superhero (Employee)
Forum|alt.badge.img+12
  • Superhero (Employee)
  • 115 replies
  • November 19, 2024

Hi ​@jbernardo

You might need to use it as ‘#TODAY#’

 

Please check this 
Lobby Navigation Guideline - Technical Documentation For IFS Cloud


Forum|alt.badge.img+1
  • Do Gooder (Partner)
  • 1 reply
  • February 19, 2025

Hello ​@jbernardo,

I encountered a similar requirement, although it was based on a different page. After reviewing the article you referenced in your inquiry, I successfully achieved the desired result by utilizing the following in the Navigation URL of the element designer,

          page/InventoryTransactionsHistory/List?$filter=DateCreated eq #TODAY#

 

In my situation, the element does not feature ‘DateCreatedTruncated,’ as you have also observed. It appears that a frequent misconception may stem from the inclusion of ‘...Truncated’ in the example presented in the referenced article.

 

In your situation,  I observed that the Latest Start was being filtered based on time (from midnight to the last second of the day), given that it is a Date and Time field. You should be able to achieve your intended filtering by simply using the following,

         page/WorkTasks/List?$filter=LatestStart ge #TODAY#T00:00:00Z and LatestStart le #TODAY#T23:59:59Z

 


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