x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 693 views
  • Users 0 members are here
Browse Forums
Announcements
103
topics
4
replies
General Discussion
1k
topics
2k
replies
Andrew1986

Filter $skip doesn't work for method sales_transaction_enquiry_views

SUGGESTED
Posted By

Hello Team,

Could you help me with the following issue?
I am using the method sales_transaction_enquiry_views to receive transaction allocations.

Example:
https://api.columbus.sage.com/uk/sage200extra/accounts/v1/sales_transaction_enquiry_views?$filter=customer_id eq 1581643&$expand=allocation_session_items

But, when I add the filter $skip, Sage 200 returns the error message.

For other methods, filter Skip is working.

Could you please explain why for method sales_transaction_enquiry_views it doesn't work?

Parents
  • 0
    SUGGESTED

    This query was raised to Developer Services, and the following solution was given:

    When using the skip parameter, you need to include an orderby clause to justify the usage of skip.
    For example, if you used &$skip=5&$top=5&$orderby=id desc this would return the top 5 items, after the first 5 have been passed over, ordered by their id in a descending order.

    Further information can be found here

Reply
  • 0
    SUGGESTED

    This query was raised to Developer Services, and the following solution was given:

    When using the skip parameter, you need to include an orderby clause to justify the usage of skip.
    For example, if you used &$skip=5&$top=5&$orderby=id desc this would return the top 5 items, after the first 5 have been passed over, ordered by their id in a descending order.

    Further information can be found here

Children
No Data

*Community Hub is the new name for Sage City