Skip to Content
0

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

Jul 14, 2017 at 04:20 AM

364

avatar image
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.

10 |10000 characters needed characters left characters exceeded
Former Member

Hi Raye,

Did you got a solution for this ?

Regards,

Amit

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sriprasad Shivaram Bhat Jul 14, 2017 at 06:46 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 24, 2017 at 05:18 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Hadrien Paquet Jun 11 at 07:39 PM
0

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'


Share
10 |10000 characters needed characters left characters exceeded