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:
You are Superrr.
I want to write this request to XDataWebDataSet1.
This query is universal and contains: aggregate function, Order by with desc, Group by, Having, where and join table
how to write down all this request using just one XDataWebDataSet1 component
and I want to display the result, for example, in WebDBGrid1 in this form:
$filter option in XData doesn't have ROW_NUMBER, or grouping, or having.