Search the FirstSpirit Knowledge Base
Dear All,
I am facing a issue (Column Mapping Not Found) in the Page Store. I have tow tables (for eg. A and B) and its having 1:N mapping and in the B Table
i have wriiten the code like below (B table's Template).
<CMS_INPUT_COMBOBOX name="cs_list_type" hFill="yes" singleLine="no" useLanguages="no">
<CMS_INCLUDE_OPTIONS type="database">
<LABELS>
<LABEL lang="*">#item.name</LABEL>
<LABEL lang="DE">#item.name</LABEL>
<LABEL lang="EN">#item.name</LABEL>
</LABELS>
<TABLE>schema.list_type</TABLE>
</CMS_INCLUDE_OPTIONS>
<LANGINFOS>
<LANGINFO lang="*" label="List Type"/>
</LANGINFOS>
</CMS_INPUT_COMBOBOX>
Even i have mapped the cs_list_type to the A table. I have added the value in the table A and I also mapped the Table A value to the Value B.
Finally i mapped the B table to the Master Page template to get the value (see the code below) and I added the Master Page Template to the some page..
<FS_LIST name="pt_XXXX" hFill="yes">
<DATASOURCE type="database" useLanguages="yes">
<ACTIONS>
<ACTION name="ADD">
<PARAM name="add-index">last</PARAM>
<PARAM name="select-ui">dialog</PARAM>
</ACTION>
<ACTION name="REMOVE"/>
</ACTIONS>
<COLUMNS>
<COLUMN show="no">#identifier</COLUMN>
</COLUMNS>
<LAYOUT>
<ADD component="toolbar" constraint="top"/>
<ADD component="overview" constraint="center"/>
<ADD component="stackedview" constraint="hide"/>
</LAYOUT>
<table>schema.list_type</table>
</DATASOURCE>
<LANGINFOS>
<LANGINFO lang="*" label="A-Z Configurations"/>
<LANGINFO lang="DE" label="A-Z Konfigurationen"/>
</LANGINFOS>
</FS_LIST>
But in the Page, I tried to add the records of the B table. And i am getting the Error Message like "Column Mapping for cs_list_type Not Found".
please suggest me to solve this issue.
Thank You,
Vasanth
which FirstSpirit-VErsion do you use?
could provider us with a screenshot of the described mappings (schema.list_type) ?
regards
andré
> could provider us with a screenshot of the described mappings (schema.list_type) ?
See an example of the mithras demo project below:
Hello Mr. Andre,
Please find the screenshot below ..
The posted screenshot shows a mapping of a table template named "...page_type". This table template has never been mentioned in your first posting.
Furthermore the screenshot shows a mapping of a CMS_INPUT_TEXT component with name "cs_pagetype" which has not been mentionend in your first posting either.
Please check the column mapping in table template related to "B" in your first post for the CMS_INPUT_COMBOBOX component named "cs_list_type".