<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.7.2" -->
<rss version="2.0">
    <channel>
        <title>relationships.ini_file[ Search for &quot;&quot;]</title>
        <description></description>
        <link>http://xataface.com/wiki/index.php?-action=single_record_search&amp;-table=wiki&amp;page_id=%3D20&amp;-cursor=0&amp;-skip=0&amp;-limit=30&amp;-mode=list&amp;--subsearch=</link>
        <lastBuildDate>Sat, 18 May 2013 19:45:14 +0100</lastBuildDate>
        <generator>FeedCreator 1.7.2</generator>
        <item>
            <title>relationships.ini_file</title>
            <link>http://www.xataface.com/wiki/relationships.ini_file</link>
            <description>&lt;table&gt;&lt;thead&gt;&lt;tr&gt;&lt;th&gt;Field&lt;/th&gt;&lt;th&gt;Value&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Page name&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;relationships.ini_file&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Page id&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;20&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Page title&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;relationships.ini_file&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Content&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;
&lt;h2 id=&quot;toc0&quot;&gt;relationships.ini File Reference&lt;/h2&gt;
&lt;table border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;&gt;&lt;tr&gt;&lt;td&gt;
&lt;div id=&quot;toc&quot;&gt;&lt;strong&gt;Table of Contents&lt;/strong&gt;
	&lt;div style=&quot;margin-left: 0em;&quot;&gt;&lt;a href=&quot;#toc0&quot;&gt;relationships.ini File Reference&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc1&quot;&gt;Overview&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 1em;&quot;&gt;&lt;a href=&quot;#toc2&quot;&gt;Field Directives&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 0em;&quot;&gt;&lt;a href=&quot;#toc3&quot;&gt;Relationship Permissions&lt;/a&gt;&lt;/div&gt;
	&lt;div style=&quot;margin-left: 0em;&quot;&gt;&lt;a href=&quot;#toc4&quot;&gt;See Also&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;


&lt;h3 id=&quot;toc1&quot;&gt;Overview&lt;/h3&gt;
&lt;p&gt;The relationship.ini file is a configuration file which is associated with a single table of a database application.  It provides metadata about the table's relationships to other tables to help Xataface dictate how they should be included in the application.&lt;/p&gt;


&lt;h3 id=&quot;toc2&quot;&gt;Field Directives&lt;/h3&gt;
&lt;p&gt;The following directives may be added to a field's section of the relationship.ini file to customize the field's behavior.  Some directives are not applicable to all fields.&lt;/p&gt;



&lt;table class=&quot;listing listing2&quot;&gt;
    &lt;tr&gt;
        &lt;th&gt; Name&lt;/th&gt;
        &lt;th&gt; Description&lt;/th&gt;
        &lt;th&gt; Version&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; __sql__&lt;/td&gt;
        &lt;td&gt; The SQL query that defines this relationship. &lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; action:visible&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=action%3Avisible&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; A boolean value (0 or 1) that indicates whether this relationship should be visible in the record tabs.&lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; action:condition&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=action%3Acondition&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; An expression that evaluates to a boolean that determines at runtime whether the relationship's tab should appear in the record tabs.&lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; action:delegate&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=action%3Adelegate&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; The name of an alternative action that can be used instead of the standard related records list.  One possible value for this would be &amp;quot;related_records_checkboxes&amp;quot; which would provide the user with a checkbox group to select the records that should be part of the relationship rather than the usual related record list.&lt;/td&gt;
        &lt;td&gt; 1.0&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; section:limit&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=section%3Alimit&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; Integer.  The number of records to show in the related record sections (in the view tab).  Default is 5.&lt;/td&gt;
        &lt;td&gt; 1.0&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; section:visible&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=section%3Avisible&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; Boolean value (0 or 1) indicating whether the relationship information should appear as a section on the left side of the table.&lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; actions:addexisting&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=actions%3Aaddexisting&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; Boolean value (0 or 1) indicating whether the action to add existing records should exist in this relationship.&lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; actions:addnew&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=actions%3Aaddnew&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; Boolean value (0 or 1) indicating whether the action to add news records should exist in this relationship.&lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; action:label&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=action%3Alabel&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; The label that appears in the relationship tab for this relationship. &lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; &lt;a href=&quot;/wiki/list%3Atype&quot;&gt;list:type&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; Optional type of list to use for the related record list.  Possible value: &amp;quot;treetable&amp;quot;&lt;/td&gt;
        &lt;td&gt; 0.8&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; &lt;a href=&quot;/wiki/meta%3Aclass&quot;&gt;meta:class&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; An optional special class to assign to the relationship.  E.g. &amp;quot;parent&amp;quot; or &amp;quot;children&amp;quot;.&lt;/td&gt;
        &lt;td&gt; 0.8&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; metafields:order&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=metafields%3Aorder&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; If the relationship should have a default order this specifies the field that should be used for this sort. &lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; &lt;a href=&quot;/wiki/visibility%3AfieldName&quot;&gt;visibility:fieldName&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; If given the value hidden will make that particular fieldName disappear in the relationship.  This will only be applied for that particular relationship.  &lt;/td&gt;
        &lt;td&gt; all&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; visibility:find&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=visibility%3Afind&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; If given the value hidden this will cause the related fields to not appear on the find form.  Normally each relationship is provided a section of the find form to enable users to find records that contain at least one match in the related records.  &lt;/td&gt;
        &lt;td&gt; 1.3rc4&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt; vocabulary:existing&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=vocabulary%3Aexisting&quot;&gt;?&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt; Specifies a valuelist that can be used to provide the set of records that can be added to this relationship.  If target table has a single column primary key then the valuelist should use the primary key for the value.  If it has a multi-column primary key, then the value should be in the form key1=value1&amp;amp;key2=value2 etc...  See also relationshipname__getAddableValues&lt;a href=&quot;/wiki/index.php?-action=new&amp;-table=wiki&amp;page_name=relationshipname__getAddableValues&quot;&gt;?&lt;/a&gt; delegate class method for a programatic solution.&lt;/td&gt;
        &lt;td&gt; 1.0&lt;/td&gt;
    &lt;/tr&gt;
&lt;/table&gt;


&lt;h2 id=&quot;toc3&quot;&gt;Relationship Permissions&lt;/h2&gt;
&lt;p&gt;See &lt;a href=&quot;/wiki/Relationship_Permissions&quot;&gt;Relationship Permissions&lt;/a&gt;&lt;/p&gt;


&lt;h2 id=&quot;toc4&quot;&gt;See Also&lt;/h2&gt;
&lt;ul&gt;
    &lt;li&gt; &lt;a href=&quot;http://xataface.com/documentation/tutorial/getting_started/relationships&quot; onclick=&quot;window.open(this.href, '_blank'); return false;&quot;&gt;Getting started with relationships&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Keywords&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;relationships.ini file, relationships&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td valign=&quot;top&quot;&gt;Language&lt;/td&gt;&lt;td valign=&quot;top&quot;&gt;en&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;</description>
            <author>relationships.ini_file</author>
        </item>
    </channel>
</rss>
