Example of DataSourceLoadOptions in sdk.Model to sort the Model

Hello,

Here is a handler that will trigger calling the model load with the sorting using the "Name" column from the "Account" entity in the ascending order with row offset 15 and 1 record fetch:

{
				"request": "usr.TriggerCustomRequest",
				handler: async (request, next) => {
					const accountModel = await sdk.Model.create("Account");
					const accounts = await accountModel.load({
							attributes: ['Id', 'Name'],
							options: {
								pagingConfig: {
									rowsOffset: 15,
									rowCount: 1
								},
								sortingConfig: {
									columns: [
										{
											columnName: "Name",
											direction: "asc"
										}
									]
								}
							}
						});
					return next?.handle(request);
				},
			}

Hi Oleg, is there a way to retrieve distinct values modifying the "options"? How can I do it?

Luca Tavasanis,

Unfortunately, there is no way to apply distinct using the SDK model. 

We've registered the idea to our R&D team and hope to see the realization in the nearest releases. Thank you for making us better!