XDataWebDataSet - any select

BIZ TMS XData
1
Есть 2 таблицы:  Таблица 1 и таблица 2.
Существует один запрос, присоединяющийся к этим 2 таблицам.
XDataWebDataSet1.EntitySetName - принимает только одну таблицу, и мне нужно отображать данные из связанного запроса на WebDbGrid, а не только в одной таблице. Как внедрить в XDataWebDataSet1.EntitySetName не таблицу, а какой-то запрос?
2
3

The underlying object entities in server have associated objects. If you retrieve an Invoice object for example, it should have mapped a "Customer" object associated to it. So in the TXDataWebDataset you just:


1. Set the QueryString property to "$expand=Customer" 

2. Add sub property fields to show data from customer. For example, you can create dataset fields named as 'Customer.Name', 'Customer.Id', 'Customer.City'

4

You are Superrr. 

Thanks for everything.
İ`m so grateful to you.
5
Hi Wagner R.,

http://5.189.181.100/TestDB

SELECT      TOP (15) ROW_NUMBER() OVER (ORDER BY SUM(A1.CASH) DESC) AS 'Numb', 
                    COUNT(A1.ID) AS COUNT_ID, A1.SUPPLY_ID, A2.SNAME, SUM(A1.CASH) AS CASH
FROM          OPERATIONS A1, SUPPLY A2 
WHERE        A1.SUPPLY_ID=A2.ID AND A1.OPER_DATE BETWEEN '2020-03-01' AND '2020-03-31' 
GROUP BY  A1.SUPPLY_ID, A2.SNAME
HAVING       COUNT(A1.ID) > 1
6

I want to write this request to XDataWebDataSet1.

7

This query is universal and contains: aggregate function, Order by with desc, Group by, Having, where and join table

8

http://www.tmssoftware.biz/business/xdata/doc/web/query_options.html

9

how to write down all this request using just one XDataWebDataSet1 component

10

and I want to display the result, for example, in WebDBGrid1 in this form:

11
Numb COUNT_ID SUPPLY_ID SNAME CASH
1               5                1           Apple 170,00
2               3 2 Samsung 110,00
3       3 4           Xiaomi 105,00
4       3 3      LG   95,00
12

http://5.189.181.100/TestDB/OPERATIONS?$expand=SUPPLY_ID

13

$filter option in XData doesn't have ROW_NUMBER, or grouping, or having.

For that you just need to create a service operation (http://www.tmssoftware.biz/business/xdata/doc/web/service_operations.html), execute an SQL statement, build a JSON (or a simple object) and return it to the client.