HCI: Dynamic filter for SF Query and use results of that for another query

[Former Member]

Hi experts,

I have a requirement where I need to pull extracts from SF where lastModifiedOn is within the current week. Is this possible to have $select=personIdExternal&$filter=lastModifiedOn gt currentTime - 7 days?

Also, if that is possible, we need to use the resulting personIdExternal list of that to pull data from other entitySets. Is it possible?

Basically we need for example:

Select values from PerPersonal where personIdExternal in (Select personIdExternal from PerPerson where lastModifiedOn is within the current week).

Is this possible or do we need to use script?

Thanks.

[former_member292109]

Hi Raye,

Did you got a solution for this ?

Regards,

Amit

[rawinder2489]

Hi Friends,

I have a requirement where I need to pull extracts from SF where lastModifiedDate is used to pull latest records from SF. Below is my SF Query.

$select=externalCode,approvalStatus,cust_Endtime,cust_Starttime,endDate,fractionQuantity,lastModifiedDateTime,startDate,timeType,userId&$filter=lastModifiedDateTime ge datetimeoffset'${property.SystemDate}'. I have tried with SF Adapter but i am not getting data from SF. Can anyone provide me the solution for this issue.

[HadrienP]

Hello,

Did you find the way of doing this? I'm using the odatav2 for Successfactors and currently I have the following exception which I don't know understand ExpressionParserException: Operator "ge" incompatible with operand types "Edm.DateTimeOffset" and "Edm.DateTime" as in my query filter everything look to be correct lastModifiedDateTime ge datetime'2018-06-11T19:23:00'

[former_member54207]

Hello Sriprasad:

Im having the same trouble, i want to use "lastModifiedOn" in a query filter, can you please show us the way wee need to do it?

Thank you in advance

[Sriprasadsbhat]

Hello Raye,

Manipulation to lastModifiedOn field is not possible directly at query level.You have to write a script and then manipulate the date field and then store it in property [ Can be done at Script level ] and then add that property to your query at channel level.

If you are using SuccessFactors OData entity IN operator is not suported but SFAPI it is supported [ you might need to cross check supported operations at SFAPI data dictionary in SF ]

Regards,

Sriprasad Shivaram Bhat