SQL request + borrow a document.

[meteos77]

Situation : I have created my personal query, it displays the list of books with the columns in the right order.
I can edit the documents (SQL query with myoid and type).

SELECT accession_number AS "Référence", title AS "Titre", author AS "Auteur", isbn13 AS "ISBN", location AS "Localisation", deweynumber AS "Dewey", target_audience AS "Public", originality AS "Origine", myoid, type FROM book ORDER BY CAST(accession_number AS REAL) ASC

But I can't borrow it because on the copy choice panel, no copy appears.
What more do I have to do to see the copies appear?

[textbrowser]

It doesn't fulfill the requirements.

[textbrowser]

SELECT accession_number AS "Référence", title AS "Titre", author AS "Auteur", isbn13 AS "ISBN", location AS "Localisation", deweynumber AS "Dewey", target_audience AS "Public", originality AS "Origine", quantity AS 'Quantity', myoid, type FROM book ORDER BY CAST(accession_number AS REAL) ASC

[textbrowser]

BQ will adapt to some incomplete queries.

[meteos77]

For my request, it works well, thank you for the evolution

[textbrowser]

BQ is aware of the shortfalls of humanity.

bcd1205

[meteos77]

The release note starts to make a lot of new features for the future version.

This will probably be our version for training and the beginning of use in our library.
It's great, it has all the main features to make the transition as smooth as possible.

Thank you again for the efforts you have made over the last 18 months to make BiblioteQ a pleasure to use.

[textbrowser]

:)