getting started with relationships and detail views

Hello @ all

First of all i want to thank the developement Team for this great Framework.
It's the rigth thing for my Project and a very powerful tool in my eyes.

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:
2 objects (1 regular and one with the relationship)
1 form and finaly 1 view

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.
The downloadable files have no values and jus the sql structure so i'm not able to check if the original files work.

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

Please be aware of that the tutorial is not up to date with openbiz 2.4. Openbiz team are working on a serial of new video tutorial. Openbiz 2.4 will use a new web tool called AppBuilder. It will be covered in the video as well. We will post the video once they are done.

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