Шаблон:DSpace1: различия между версиями

Материал из GeologyScience Wiki
Перейти к:навигация, поиск
(Новая страница: «<!-- Test request to DSpace --> {{#get_db_data: db=DSpace |from=metadatavalue = a,metadatavalue = b |join on=a.dspace_object_id=b.dspace_object_id |where=a.t...»)
 
 
(не показано 56 промежуточных версий этого же участника)
Строка 1: Строка 1:
<!-- Test request to DSpace -->
<!-- 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_name|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:
Строка 16: Строка 17:
  |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_cite|data=cite=Paper_name, link=Paper_link}}
{{#display_external_table:template=DS cite2|data=Cite=Paper_name, Link=Paper_link}}


 
{{#clear_external_data:}}
{{#cargo_query:tables=DS_name1=a, DS_cite1=b
</div>
|join on=a.Link=b.Link
|fields=a.Name=name1, b.Cite=cite1
|format=table
}}

Текущая версия на 15:11, 12 сентября 2021


Не удаётся подключиться к базе данных (Cannot access the database: Postgres functions missing, have you compiled PHP with the --with-pgsql option? (Note: if you recently installed PHP, you may need to restart your webserver and database)).


Не удаётся подключиться к базе данных (Cannot access the database: Postgres functions missing, have you compiled PHP with the --with-pgsql option? (Note: if you recently installed PHP, you may need to restart your webserver and database)).