How to filter imported attributes?

26 Aug '12, 04:35 PM

42,036 Views

Felix Franke

No Forum Badges

Hi again,

I´m trying to filter an imported attribute to show in a index unit only the values in the right language. Here´s the extract of my data modell:

alt text

I want to show the value of the room-type in the right language in the index unit of the entity rooms. So I imported the attribute "translation" from the table "Room Types Translations".

alt text

Now in the index unit all rooms are show as often as translations of the attribute "room type" exists. So I set an attributes condition on the importated attribute Room Type Translations.Language as you see in the following modell:

alt text

Attibutes Condition "Language":

alt text

Transport-Link: Selected Language to Room List:

alt text

Following the result:

alt text

Could anyone tell me what I´m doing wrong or if the whole way to get the translation is wrong???

Thank´s a lot!

Felix

x 0

3 Answers

29 Aug '12, 12:39 PM

Denis Kalgushkin

Forum Starter - Level 2

Well, definately not the best example but anyway http://pastebin.com/vEhmJQ68

The "Type" here is the sub-level with translated 'name'

x 0

26 Aug '12, 08:26 PM

Denis Kalgushkin

Forum Starter - Level 2

+1 I always have the same problem. Probably selectors in webratio can only join tables on id/relationship but not other conditions too when you import an attribute. So i have to use Hierarchical Index Unit and I add translations table as sub-level there and it allows me to filter it(adding attribute condition to translation sub-level). But templating of Hierarchical Index Unit seems to be very complex/difficult and very often i have to make specific template for each table.

x 0

26 Aug '12, 10:34 PM

Felix Franke

No Forum Badges

Hi Denis,

thank´s a lot for your reply.

So I will keep the thread as non answered. Maybe anyone has another solution for the issue.

Could you possibly send me an example of a hierarchical index unit template? I´m quite a raw recruit with web ratio and haven´t done layout templates before.

Cheers,

Felix

x 0

Related questions

Acceder a diferentes site views/ Acces to diferents site views Add to Bag link in ACME any webratio book ? Asking For a Book Attribute comparison in a selector unit Clarification about the NoOperation unit Codigo QR Como hacer un menu en webratio? Conditional Expression "greater than 0" on null fields Connect more query unit Content module page variable won't assign. coupled mandatory fields Create Unit with Date (Year only) Custom Attributes Condition Database Database List is not showing up in App Emulator Data is always created doubled Data Management: Updating Data - Attachments - Updating Data Sample Project Final Description: Unknown tag 'wr:LinkResource' Dudas sobre modelado(Data Flow,Forms y Operation Create) Empty record mistakenly saved en_US codify problem Export XML external link.= Filter information in a Simple List Format currency forward/backward navigation and bookmark in ajax web app "Generation Error" with Generate and Run Generation options problem get the attachment files of an email Get Unit problem Get Year from Date Help for connect public and private site views How can i create pagemenu or landmarkmenu with multiple levels. How does WebRatio represent these IFML elements? / ¿Cómo representa WebRatio estos elementos IFML? How i can reuse modules in multiple projects? How to define the sequence of execution units on a page? How to display the attributes of a related entity. How to include Selector Unit result in Mail Unit Body? How to pass vars to a alternative page How to process IFML Model (build with Eclipse editor) with ATL How to show a page based on a boolean? How to speed up the "last" link using PowerIndexUnit for lots of records How to store data related to an entity in relationships in a project web Insert data into database Insert master page to many hybrid modules Integrating a BPM model into an existent WebML model JSON I/O Unit e informazioni derivate KO Links in Selector Unit Landmark in hybrid module Link localization Links from Index unit with condition Link Visibility Condition Power Index Unit Mail multipla maintain the record order in a sortable list Math Unit to update attributes of an entity? [MOBILE] How I extract information from JSON client side? Modifica Entità tramite file xml Multi Entry Unit: How to forward only checked rows? multi-lingual product description Non riesco a fare funzionare Xml out unit Parametrizzazione Selector Unit Problem Example create Unit (no company in employee table) Problem in adding diagrams in IFML Editor (Eclipse) Problem with query unit! Problem with Scroller Unit query a database Question about Site Views Rename passing attributes Replace ID by its value in another table Search by Selector component does not work Select between parameters Selector unit doesn't return any value in hybrid module Sending mails is not working Sending mails with gmail is not working Setting the Default link for a Switch unit show/hide fields on button click (registration page) [solved] all links transparent, why ? Something leads to wrong condition expression evaluation. sumar atributos de una tabla filtrado por Role Condition Sum entity's values Transportation Link issue Unique Fields using relationship role conditional with null usuarios y grupos utilizzo componenti database Visibility Condition on Multiple Links From Index Unit WebRation - Create Navigation diagram