Шаблон:DS Min1: различия между версиями
PatukMI (обсуждение | вклад) |
PatukMI (обсуждение | вклад) |
||
Строка 7: | Строка 7: | ||
|join on=a.dspace_object_id=b.dspace_object_id | |join on=a.dspace_object_id=b.dspace_object_id | ||
|where=(upper(a.text_value) like '%{{{1}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | |where=(upper(a.text_value) like '%{{{1}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | ||
|limit= | |limit=400 | ||
|data=Paper_name=a.text_value, Paper_link=a.dspace_object_id | |data=Paper_name=a.text_value, Paper_link=a.dspace_object_id | ||
}} | }} | ||
Строка 18: | Строка 18: | ||
|join on=a.dspace_object_id=b.dspace_object_id | |join on=a.dspace_object_id=b.dspace_object_id | ||
|where=(upper(a.text_value) like '%{{{1}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | |where=(upper(a.text_value) like '%{{{1}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 | ||
|limit= | |limit=400 | ||
|data=Paper_name=b.text_value, Paper_link=a.dspace_object_id | |data=Paper_name=b.text_value, Paper_link=a.dspace_object_id | ||
}} | }} |
Версия 07:26, 28 сентября 2021
Ошибочный запрос SELECT "a.text_value","a.dspace_object_id" FROM "metadatavalue" "b" WHERE (upper(a.text_value) like '%{{{1}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 400 (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}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 400 ).
Ошибочный запрос SELECT "b.text_value","a.dspace_object_id" FROM "metadatavalue" "b" WHERE (upper(a.text_value) like '%{{{1}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 400 (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}}}%' or upper(a.text_value) like '%{{{2}}}%') AND a.metadata_field_id = 70 and b.metadata_field_id = 31 LIMIT 400 ).