Nuxeo DAM system: Get document by file:content/data
I would like to execute an (NXQL) query which would return to me the document based on the file:content/data field. I have tried several different ways of writing the query down but nothing seems to be working for me.
Could you please tell me is it (and how) possible to retrieve a document via REST API or .NET Client based on the download link of the asset(file:content/data)?
I look forward to hearing from you!
The reason I believe why querying based on file:content/data field is not working is because digest value is actually stored instead of link in a data field
Alternative Solution would be querying based on file:content/name. If you have a LINK like
http://host:port/nuxeo/nxfile/default/cfb12863-3ac2-4778-8b4b-06a275a7943b/report:file/2017-Gartner-MQ-CSP.jpg?changeToken=1-0"
Here '2017-Gartner-MQ-CSP.jpg' is the name of a file
So NXQL Query would be->
SELECT * FROM Document WHERE report:file/name = '2017-Gartner-MQ-CSP.jpg'
And REST API would be->
http://host:port/nuxeo/api/v1/search/lang/NXQL/execute?query=SELECT * FROM Document WHERE report:file/name = '2017-Gartner-MQ-CSP.jpg'&properties=*
- query multiple IIF statement
- count distinct values while left joining
- MySQL: Order by Count(*)?
- How to select data items of a certain length?
- Comparing JSON-typed column with specific string value
- How to treat MAX() of an empty table as 0 instead of NULL
- Declare variable in SQLite and use it
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- Snowflake: Using multiple AND/OR statements breaks my date filter
- How to get the insert ID in JDBC?
- Add a column to a DB2/400 table with a specific ordinal position
- SQL conditional MAX extraction
- Drop Column from Large Table
- Can using isnull in a where statement cause problems with using indexes?
- How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?
- SQL Concat Subquery
- Oracle client appears to be transmitting all 4000 varchar characters for each row
- Java JDBC executeUpdate not working on Delete SQL with TRUNC function in where clause
- Oracle thinks table doesn't exist during alter
- How to bulk update sequence ID postgreSQL for all tables
- Remote clickhouse error: DB::Exception: There's no column '__table1.event_params.key' in table '__table1'
- How do I catch a query exception in laravel to see if it fails?
- How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
- SQL Stored Procedures not finishing when called from Python
- Make a paginated table without offset limit
- How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
- How do composite indexes work?
- Rank rows by specified partition
- SQL Get "ISO Year" for ISO Week
- How to insert an array value to an existing JSON document?