Listview and Query

[jyherpet]

Hello,

On the document "MEGA Properties pages_MEGA 2009 SP5 EN.pdf", it's writting that a listview enables display of a list obtained by browsing a MetaAssociationEnd or a Query from an object in the properties page.

I tried to insert a query on _Parameterization field of a MetaPropertyPage, without success :

IsAPOrNI=Condition(~)Sgoy)ygu020[Type application]="AP" or ~)Sgoy)ygu020[Type application]="NI")
FrameworkGroup=Group(Bar),Pos(Bottom),Name(Frameworks utilisés),HiddenOn(IsAPOrNI)
Frameworks=Attribute("Select [Application] Where [Type application]='FW' And [Constituée].[Nom]=&name"),In(FrameworkGroup),Control(ListView),Title(No)

Can anyone give me an example, please ?

[yrudloff · Accepted solution]

Ok Good.

Just for information for future people reading this post, the solution should be something like this:

[Template]

ListItemMap=Map(~e2TdUvP)F5hG[OUwEmail])

BusinessFunctionList=Item(~e2TdUvP)F5hG[OUwEmail]),Contains(ListItemMap),Control(ListView),Name("Org_Unit With E-mail"),Param(...)

With the Query OUwEmail being :

Select [Person] Where [E-mail] And [Org-Unit].[Absolute Identifier] &"IdOrg"

[jyherpet]

Hello,

I finally found !

The query must be call on the _Parameterization field and not writting on.

[jyherpet]

Hello Yannick,

thank you for your suggestions, but it's not exactly what I wish.

For example, on a properties page of an Actor, I want to display on a listview Persons linked to this Actor, and only those who have an email. So I need to filter the result for not showing Persons without email.

It's the reason why I tried to use a query on the _Parameterization field of the MetaPropertyPage, for the listview.

Do you know how to filter the result on a listview ?

[yrudloff]

Hi Jean-Yves,

There is a lot of example that you can find in MEGA by querying the MetaPropertyPage containing a Listview.

Select [MetaPropertyPage] Where [_Parameterization] Like "#Listview#"

You'll find below some examples of listviews I selected :

1- Based on a Leg Object 

[Template]
Responsibles=LegObject(~B6XuQd(T5XH0[Network - Responsibility])
ResponsiblesList=Attribute(~B6XuQd(T5XH0[Network - Responsibility]),Contains(Responsibles),Control(ListView),Title(No)

2- Based on Map(MetaAssociationEnd) and defining the toolbar of the listview

[Template]
SubGroup=Group(Bar),Pos(Top),Name(~T0p0sJn)9192[Owned Application Host])
Subs=Map(~T0p0sJn)9192[Owned Application Host])
SubsList=Attribute(~T0p0sJn)9192[Owned Application Host]),Contains(Subs),In(SubGroup),Control(ListView),Title(No),Param(NoDefaultColumn,ToolBar[+C,+D,-L,-U])

3- based on Leg Object and selecting the attributes to display in columns

[Template]
SubGroup=Group(Bar),Pos(Bottom),Name(~LZtAlnYE4b10[Responsible Persons])

Subs=LegObject(~quhNF1cg)080[Business Process Manager])
Att1=Attribute(~tvhNy4cg)KD0[IT Manager]),From(Subs)
Att2=Attribute(~RvhNl4cg)OC0[Process Manager]),From(Subs)
Att3=Attribute(~EwhN45cg)GE0[Quality Manager]),From(Subs)
Att4=Attribute(~cwhND5cg)CF0[Risk Manager]),From(Subs)
Att5=Attribute(~0vhNZ4cg)SB0[Process Owner]),From(Subs)

SubList=Attribute(~quhNF1cg)080[Business Process Manager]),Contains(Subs),In(SubGroup),Control(ListView),Title(No),Param(NoDefaultColumn)

I hope this can help you,

Yannick