cancel
Showing results for 
Search instead for 
Did you mean: 

Listview and Query

Solved
Contributor

Listview and Query

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 ?

Best regards,
Jean-Yves
Tags (3)
4 Replies
Highlighted
MEGA

Re: Listview and Query

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

Yannick RUDLOFF
Contributor

Re: Listview and Query

Hello Yannick,

 

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

 

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 ?

Best regards,
Jean-Yves
Contributor

Re: Listview and Query

Hello,

 

I finally found !

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

Best regards,
Jean-Yves
MEGA

Re: Listview and Query

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"

 


 

Yannick RUDLOFF