OverView

[TGSParth]

Had created 2 tables which is author and books where relationship is manage that is 1 to n normal add ,list data been shown and executed.
Now there is page where author all data been listed now in that author list page having button for add book record, have created a page where taking entity of author and created a form for book record insert. Now have use page type as 'Record Manage' taking author entity because wanted author ID should be display as particular author will be stored book details in form.
so taking author entity in that page we get our Author ID.
Now want to stored book details as reminder we have author entity

can we store book details using author entity as page type is record manage ?
also tell me about "record related record create" USE ?
/{AppName}/{AreaName}/{NodeName}/r/{RecordId}/rl/{RelationId}/c/{PageName?}

kindly guide also give some suggestion base on this.

[TGSParth]

also want eql syntax where i want record of particular author along with book he/she added ?
as i have written eql syntax which give me all record of author and books but not individual !!
SELECT ,$author_1n_book.
FROM book
WHERE author_id = $author_1n_book.id
ORDER BY @sortby ASC
PAGE @page
PAGESIZE @pageSize

as @id is not taking as parameter so can you tell how it would resolved !!!!
@bzashev can you help me with this little thing?

[bzashev]

You can do it like this SELECT ,$author_1n_book. ...
There are more examples here https://webvella.com/documents/developer/data-sources/eql
As for the @pageSize - these are parameters which you need later to provide. @id parameter should not be a problem

[bzashev]

You can also test in a datasource like described here
https://webvella.com/documents/developer/data-sources/database
you can check the generated SQL too and results

[bzashev]

As for the related page - this is a details page. The key here is that the Page Data Context is preinited to the related record.

[TGSParth]

can we make a small meeting and talk ?