addSelectionField(Fieldnum(table,RecId),selectionfield::COUNT)
________________________________
Fra: Dahlsgaard Jan
Sendt: 24. februar 2005 15:13
Til: [email protected]
Emne: SV: [development-axapta] GROUP BY ON A QUERY
You have to use addsortfield and orderMode(OrderMode::GROUPBY) on your
qbsCust to specify which fields to group by
Regards
Jan Stelsig Dahlsgaard
Fujitsu DK
________________________________
Fra: Gustavo Camargo [mailto:[EMAIL PROTECTED]
Sendt: 23. februar 2005 22:56
Til: [email protected]
Emne: [development-axapta] GROUP BY ON A QUERY
Hello to everybody!!!
I am making a query to extract the items that are blocked on the
inventTableModule.
I have a lookup and i want that when i open the lookup it shows me
only one item, because in this moment it shows me 3, that correspond
to the sales, purch and invent on inventtablemodule, for this reason
i want to group this items and convert to one only to show in this
lookup.
Te query that i've been making is.
if ( FilterGroup.selection() == 3 )
{
SysTableLookup = SysTableLookup::newParameters(tableNum
(InventTable), this);
tableId = tablename2id('InventTable');
sysTableLookup.parmTableId(tableId);
fieldId = fieldname2id(tableId, 'ItemId');
sysTableLookup.addLookupfield(fieldId);
fieldId = fieldname2id(tableId, 'ItemName');
sysTableLookup.addLookupfield(fieldId);
qbsCust = query.addDataSource(InventTable.tableId); //QBSCust
BuildDataSource
qbsModule = qbsCust.addDataSource(TableNum
(InventTableModule)); //QBSModule BuildDataSource
qbsModule.addLink(fieldNum(InventTable,ItemId),fieldNum
(InventTableModule,ItemId));
qbsModule.addRange(fieldNum(InventTableModule,Blocked)).value
(enum2str(NoYes::Yes));
sysTableLookup.parmQuery(query);
this.performFormLookup(sysTableLookup.formRun());
}
Thanks!!!
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129abjtd1/M=298184.6018725.7038619.3001176/
D=groups/S=1705006764:HM/EXP=1109327430/A=2593423/R=0/SIG=11el9gslf/*htt
p://www.netflix.com/Default?mqso=60190075>
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group
s/S=:HM/A=2593423/rand=764500175>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129cbm1go/M=298184.6018725.7038619.3001176/
D=groups/S=1705006764:HM/EXP=1109343601/A=2593423/R=0/SIG=11el9gslf/*htt
p://www.netflix.com/Default?mqso=60190075>
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=group
s/S=:HM/A=2593423/rand=601263477>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
