Here is an excerpt from my display document:
<DisplayField header="BOLD1" id="BOLD_1" data-type="string"
searchable="true">
<DisplayFieldElement name="Field1" viewName="BOLD_IDS"
viewColumn="BOLD_1"/>
</DisplayField>
<DisplayField header="BOLD2" id="BOLD_2" data-type="string"
searchable="true">
<DisplayFieldElement name="Field1" viewName="BOLD_IDS"
viewColumn="BOLD_2"/>
</DisplayField>
...
As you mentioned, all DisplayFields are marked searchable="true" and
each has an associated data-type. When I select "Options > Add
Columns" and select these fields, as well as a few others, I select
"Save" and the result comes back with the error message:
"Failed to create search results."
The xdat.log shows:
==> xdat.log <==
2010-04-20 11:38:19,849 [http-80-2] ERROR
org.nrg.xnat.restlet.resources.search.SearchResource - Failed POST
org.postgresql.util.PSQLException: ERROR: relation "bold_ids" does not
exist
at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:
139)
at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:
517)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:
298)
...
I don't think it's finding my ViewLink. I can run the SQL in that
ViewLink just fine through the psql terminal. I can add built-in
DisplayFields to table columns just fine.... just can't seem to ass
any that I've made it seems.
On Apr 20, 11:18 am, Timothy Olsen <
t...@npg.wustl.edu> wrote:
> You should be able to add any fields that were defined as <DisplayField>s in your display xml. If they were accessible in the old search interface, they should be more accessible now.
>
> One note, you may need to add a few attributes to your <DisplayField> for them to be accessible by the search engine in a meaningful way. In addition to the standard fields, you would also need searchable="true" and data-type="string|integer|float|date". There should be examples of these in plugin-resources\project-skeletons\xnat\src\schemas\xnat\display\mrSessionD ata_display.xml. The data-type field is especially important for fields that are generated from database views.