Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

VB Excel add-in: How to sort a Child Collection chronologically by Period

edited Sep 18, 2024 5:44PM in Visual Builder 2 comments

Summary:

Using the VB for Excel add-in. Created a Workbook with the following layouts:

  • Financial Project Plans
    • Resource Assignments
      • Planning Amounts
        • Planning Amount Details

How do I retrieve the Planning Amount Details results sorted by Period — chronologically, not alphabetical?

Content (please ensure you mask any confidential information):

I referenced the documentation on sort and this Support Document, added orderBy to the Download parameters for the Planning Amount Details.

…PlanningAmountDetails?offset=0&limit=499&orderBy=Period:asc&links=self&fields=PeriodName,RawCost,ManualSpreadFlag

I keep getting the following error.

URL request parameter orderBy with value Period:asc is not valid.

AND, even if that worked, wouldn't it return with the collection sorted alphabetically? How would I get the results to sort chronologically?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!