search

Accounting-Companion / TallyConnector

You can use Tally Connector to Connect your desktop/Mobile Applications with Tally seamlessly.
47 stars 29 forks source link

Requesting to add support for sorting by field on PagniatedRequests #36

Closed samsylvestertty closed 7 months ago

samsylvestertty commented 7 months ago

Is there an option to retrieve Paginated objects with sort? I tried searching for the Paginated request in the list of properties and in code but couldn't find an object for sort. I can fetch records and sort with the result but I would like to have the sort in paginated result.

Please close if the capability already exists.

Thank you

saivineeth100 commented 7 months ago

Since TDL does not support Paginated requests I Implemented pagination myself using line Index, which allocated Line Index based on default sort.

If we use pagination and use custom sort it messes up with pagination. So, if we want Custom sort from Tally then we need to remove pagination.

samsylvestertty commented 7 months ago

Understood. My usecase is to process data from tally. If it is GUID sorted I can read Invoices before receipts and payments. Could you please share the xml tag in the api that is responsible for sorting? I tried using SORT tag under collection but doesn't seem to work. Thanks again for your response.

saivineeth100 commented 7 months ago

If sort is in collection that is used as source collection sort will not work

Also, it needs to be like this. Collection.Sort =[ "@@Default :$GUID"]

this is how it will be in TDL

image
samsylvestertty commented 7 months ago

Thanks again for your prompt response. I don't have much knowledge on TDL.

Is this from your code? Collection.Sort =[ "@@default :$GUID"]. IF yes, can I use it in PaginatedRequestionOptions?

Out of topic question: Is there a way to read Deleted Vouchers? I tried $IsDeleted = Yes in the Filters collection. Didn't work

saivineeth100 commented 7 months ago

no, In options I didn't provided sort but you can create your implementation and set that property for collection.

Deleted vouchers are not saved in Tally unless you use Edit log if you are using Edit log and need deleted vouchers you need to Extend Collection class and add property IncludeDeleted and set to Yes

samsylvestertty commented 7 months ago

Thank you. Understood introduction of sort might affect the common functionality. Closing the issue.