Шаблон:DSpace1: различия между версиями
PatukMI (обсуждение | вклад) |
PatukMI (обсуждение | вклад) |
||
| (не показано 16 промежуточных версий этого же участника) | |||
| Строка 1: | Строка 1: | ||
<!-- | <!-- Request to DSpace {{{1}}} --> | ||
< | |||
<div class="mw-collapsible mw-collapsed" data-expandtext="-" data-collapsetext="_"> | |||
{{#get_db_data: | {{#get_db_data: | ||
db=DSpace | db=DSpace | ||
|from=metadatavalue = a,metadatavalue = b | |from=metadatavalue = a,metadatavalue = b | ||
|join on=a.dspace_object_id=b.dspace_object_id | |join on=a.dspace_object_id=b.dspace_object_id | ||
|where=a.text_value like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | |where=upper(a.text_value) like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | ||
|limit=100 | |limit=100 | ||
|data=Paper_name=a.text_value, Paper_link=a.dspace_object_id | |data=Paper_name=a.text_value, Paper_link=a.dspace_object_id | ||
}} | }} | ||
{{#display_external_table:template=DS name2|data=Name=Paper_name, Link=Paper_link}} | {{#display_external_table:template=DS name2|data=Name=Paper_name, Link=Paper_link}} | ||
{{#get_db_data: | {{#get_db_data: | ||
db=DSpace | db=DSpace | ||
|from=metadatavalue = a,metadatavalue = b | |from=metadatavalue = a,metadatavalue = b | ||
|join on=a.dspace_object_id=b.dspace_object_id | |join on=a.dspace_object_id=b.dspace_object_id | ||
|where=a.text_value like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | |where=upper(a.text_value) like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | ||
|limit=100 | |limit=100 | ||
|data=Paper_name=b.text_value, Paper_link=a.dspace_object_id | |data=Paper_name=b.text_value, Paper_link=a.dspace_object_id | ||
}} | }} | ||
{{#display_external_table:template=DS cite2|data=Cite=Paper_name, Link=Paper_link}} | {{#display_external_table:template=DS cite2|data=Cite=Paper_name, Link=Paper_link}} | ||
| {{#clear_external_data:}} | ||
{{#clear_external_data:}} | |||
</div> | </div> | ||
Текущая версия на 15:11, 12 сентября 2021
Ошибочный запрос SELECT "a.text_value","a.dspace_object_id" FROM "metadatavalue" "b" WHERE upper(a.text_value) like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 100 (Error 42703: ОШИБКА: столбец "a.text_value" не существует LINE 1: SELECT /* EDConnectorRdbms::fetch */ "a.text_value","a.dsp...
^
HINT: Возможно, предполагалась ссылка на столбец "b.text_value".
Function: EDConnectorRdbms::fetch Query: SELECT "a.text_value","a.dspace_object_id" FROM "metadatavalue" "b" WHERE upper(a.text_value) like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 100 ).
Ошибочный запрос SELECT "b.text_value","a.dspace_object_id" FROM "metadatavalue" "b" WHERE upper(a.text_value) like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 100 (Error 42703: ОШИБКА: столбец "b.text_value" не существует LINE 1: SELECT /* EDConnectorRdbms::fetch */ "b.text_value","a.dsp...
^
HINT: Возможно, предполагалась ссылка на столбец "b.text_value".
Function: EDConnectorRdbms::fetch Query: SELECT "b.text_value","a.dspace_object_id" FROM "metadatavalue" "b" WHERE upper(a.text_value) like '%{{{1}}}%' AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 100 ).
