Skip to main content

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

Hi ​@jbernardo

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

 

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


Reply