Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 14, 2017 at 06:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2017 at 05:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 11 at 07:39 PM

    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'


    Add comment
    10|10000 characters needed characters exceeded