Hello @ all First of all i want to thank the developement Team for this great Framework. I tried all tutorials an i also have the manuel here but there's still a missing solution for relationships and detail views. My solution: The Tutorial with the cars is quite useful (built it with the eclipse plugin) but nothing apperas in the views so i don't know if my coding / xml is wrong or i have just the wrong values in the table. Does anyone have a document, tutorial or tip to solve my problem?
best regards
|
|||

I actually have the same
I actually have the same problem thanks for sharing as I can now apply it with mine. I hope you could add up more informations and more alternatives so this would not bother me any more. Double Falsehood
Problem solved - i watched
Problem solved - i watched the final video and the solution was simple :)
MOther object - child
child => relation
mother => child reference
child => mother reference
view class changed to easyview and not to dynaview.
now the relation is always active and i don't need a where statement anymore.
Also if i create a new child object (toggle form) the foreign key is allready filled in and i don't need to use the variable.
I hope this helps someday someone :)
Greets
Newly uploaded video
Newly uploaded video (Openbiz table join and link) can the steps of how to link tables.
Per your question, 2 suggestions:
1. Check the SQL in app/log/log_DEBUG.html. See if there is anything wrong on your SQL.
2. Check if the baseapp Event tab works. Compare your metadata with that.
Ah thanks - the Logfile
Ah thanks - the Logfile Mechanism is really great.
The Problem was, that the "Where" Query was missing. I thought the relation between the Objects is enough.
I also have now "toggling" forms :)
But there are 2 questions left:
1) What ist the difference between easyform & bizform?
2) In the Detail view - i want to add related "child" Elements.
So i made a new form but i'm not able to tell the new child Element the primary key of the mother element
For exmaple i tried it like this in my Textfield: Text="mailto:{@application.form.f_sample_basic_detail:Elem[fld_Id].Value}"
But there apperas the @application.... phrase without any other value.
In my list view, this works without any Problem (also @:Elem[fld_Id] works).
So my question - how can i show an Value in a form which is shown in the form above
view detail====================
form mother detail==============
Field_ID
Field......
/Form mother==================
form add child toggle ============
Field_ID_Child (SYSID - not whown in form)
Field_ID_Mother Text="{@application.form.f_sample_basic_detail:Elem[fld_Id].Value}"
....
/form add child toggle ===========
/view Detail===================
But in the list view of the child elements i usw the same statement for my query (in the dataobject) an it works perfectly.
best regards
Oh Great ! After another
Oh Great !
After another 12- Hour Session with openbiz i solved the Problem with the relations, mapped a column to a dropdown and got the Detail View ( but this wouldn t be possible without your wizard ( i should have Found it earlier ;). )
This was my first milestone - but there is à Lot to do ( user Login , Mapping over 40 tables, layouting ...
I think the Problem with openbiz is that there is à professional Manual an some beginner tutorials but it s difficult After the First steps.
I Hope Tomorrow bring's me again more forward with openbiz :)
is there à showroom ?
Best regards
Please be aware of that the
So now i'm again in troubles
So now i'm again in troubles :(
I have a detail view an under the details of my object i have a list of refered objects.
For example:
===============================================
Object #3
Name:
Adress:
Attribute4:
Attribute5:
Attribute6:
.... and so on...
List of refered obejects:
id | object id | name ...........
1 | 3 | test
2 | 3 | test
3 | 4 | test
4 | 5 | test
===============================================
So i build a Dataobject for my main object with the Object reference to the "sub" Dataobject.
<ObjReferences>
<Object Name="application.dataobj.mysubojectlist" Relationship="1-M" Table="test_sub" Column="object_id" FieldRef="Id" CascadeDelete="Y"/>
</ObjReferences>
mysubobjectlist looks like:
<?xml version="1.0" encoding="UTF-8"?>
<EasyForm Name="mysubojectlist" Class="EasyForm" Title="Districts" FormType="List" jsClass="jbForm" BizDataObj="application.dataobj.mysubojectlist" TemplateEngine="Smarty" TemplateFile="grid.tpl" PageSize="500" Access="">
<DataPanel>
<Element Name="id" Class="ColumnText" FieldName="Id" Link="..." Label="id of my subobject"/>
<Element Name="object_id" Class="ColumnText" FieldName="object_id" Label="referedobject"/>
<Element Name="info" Class="ColumnText" FieldName="info1" Label="info1"/>
</DataPanel>
<ActionPanel>
</ActionPanel>
</easyform>
and finally my view
<?xml version="1.0" standalone="no"?>
<EasyView Name="detail" Class="DynaView" Description="Detailansicht" TemplateEngine="Smarty" TemplateFile="view.tpl">
<FormReferences>
<Reference Name="application.form.f_basic_detail" SubForms="application.form.f_sub_list"/>
<Reference Name="application.form.f_sub_list" />
</FormReferences>
</EasyView>
My problem ist, that this damn ;) subform doesn't care about the selected object - i always shows the whole list of all objects like in my sample above.
I tried to understand with the help of the "Trac" component, but the trac component (extracted it from 2.3) won't work like in your online version.
If this solution wil work, it would be perfect because i can easy use the cascading delete from openbiz and avoid a lot of data garbage (or orphaned entries)
I hope you understand what i mean (well, my english isn't perfect but i hope at least some words make sense ;) )
I also searched the forum but the thread with the subcontrols is exactly that what i did :( and i think after two days trying, that there was a change in 2.4 so it works another way.
It wourld be gread if someone could help me :(
best regards