Hi,
I have made a solution for the problem. You need to extract the labels from the
enums in the AOT.
Goes something like this:
public void run()
{
EDAViewWizardEnum viewWizardEnumTable;
EDAViewWizardLanguage viewWizardLanguageTable;
Dictionary dictionary;
DictEnum dictEnum;
EnumId enumId;
xInfo xInfo;
int i, idx;
RunBaseProgress progress;
LanguageId currentLanguageId;
;
Dictionary = new Dictionary();
xInfo = new xInfo();
select count(RecId) from viewWizardLanguageTable;
progress = new RunBaseProgress(2);
progress.setCaption("@EDA23");
progress.setAnimation(#AviUpdate);
progress.setTotal(viewWizardLanguageTable.RecId, #second);
progress.setTotal(dictionary.enumCnt(), #first);
progress.setText("@SYS4195", #first);
delete_from viewWizardEnumTable;
startLengthyOperation();
while select viewWizardLanguageTable
{
Progress.setText(viewWizardLanguageTable.LanguageId, #second);
currentLanguageId = xInfo.language();
xInfo.language(viewWizardLanguageTable.LanguageId);
for (i = 1; i <= dictionary.enumCnt(); i++)
{
enumId = dictionary.enumCnt2Id(i);
dictEnum = new DictEnum(enumId);
if(dictEnum)
{
Progress.setText(dictEnum.name(), #first);
idx = 0;
for (idx = 0; idx < dictEnum.values(); idx++)
{
viewWizardEnumTable.LanguageId =
viewWizardLanguageTable.LanguageId;
viewWizardEnumTable.BaseEnumId = enumId;
viewWizardEnumTable.BaseEnumName = dictEnum.name();
viewWizardEnumTable.BaseEnumLabel = dictEnum.label();
viewWizardEnumTable.BaseEnumValueName =
dictEnum.index2Symbol(idx);
viewWizardEnumTable.BaseEnumValueLabel =
dictEnum.index2Label(idx);
viewWizardEnumTable.BaseEnumValue =
dictEnum.index2Value(idx);
viewWizardEnumTable.insert();
}
}
Progress.incCount(1, #first);
}
Progress.incCount(1, #second);
}
xInfo.language(currentLanguageId);
EndLengthyOperation();
}
Then you need to make a table also from within Ax storing the fields that uses
Enums and the Enum Id it uses. (As I create a view from within AX I did not
need this table). You need to loop over the data dictionary (SysDictionary,
sysDictTable, SysDictField). Here you will find the Property Enum and SQLName,
remember the tableName (DBBackend).
Now You can Join the Enumvalue with this table:
Select custAccount, Name from CustTable
LEFT OUTER JOIN BaseEnumValueLabel from viewWizardEnumTable
Where languageId = 'en-us'
And BASEENUMID = 53 (CustVendBlocked) <ID of the enum the field uses>
And BASEENUMVALUE = CustTable.Blocked
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
[EMAIL PROTECTED]
Phone: +49 5242 / 40 80 54
Fax: +49 5242 / 40 80 40
Mobile: +49 172 / 571 03 34
http://www.as-T.biz
arvato systems | Technologies GmbH
Joachim-Jungius-Str. 9, 18059 Rostock
Geschäftsführung: Erwin Pietz, Matthias Moeller
Amtsgericht Rostock - HRB 7497
________________________________
"Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und
ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie
sicher, dass die Information in dieser Nachricht ausschließlich an die
adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie
gesendet worden sein, dann informieren Sie bitte umgehend den Absender und
löschen Sie die Nachricht. Vielen Dank."
"The information in this e-mail and any attachments is confidential. The
information must only be held in areas that have controlled and limited access
to the addressed persons. If this e-mail has been sent to you in error, please
immediately notify the sender and delete the e-mail. Thanks."
________________________________
-----Ursprüngliche Nachricht-----
Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag
von Ozanhan Anaç
Gesendet: Mittwoch, 12. März 2008 15:47
An: development-axapta@yahoogroups.com
Betreff: RE: [development-axapta] Enum values in SQL database
Hi Anýl,
As enum types stored in the application (not in SQL), there shouldn't be a
flexible way to show that values.
Instead, you can use HARDCODED switch cases in your views. For example :
Create view vw_blabla
As
Select StatusIssue_Text = case StatusIssue when 0 then 'none' when 1 then
'sold' ....., StatusIssue, ...,.... from bmssa.INVENTTRANS
Regards,
Ozan
_____
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Anil Ozay
Sent: Wednesday, March 12, 2008 2:45 PM
To: [EMAIL PROTECTED];
development-axapta@yahoogroups.com
Subject: [development-axapta] Enum values in SQL database
Hi,
We want to create a view on SQL server for InventTrans and tha table has
enum values.
SQL uses integer values to store enum values but we want to show enum values
to user.
Is it possible to find the enum values on database to show in the view?
Regards,
Anil Ozay
[Non-text portions of this message have been removed]
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 07.03.2008
14:01
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 07.03.2008
14:01
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.518 / Virus Database: 269.21.6/1318 - Release Date: 07.03.2008
14:01
[Non-text portions of this message have been removed]
Yahoo! Groups Links
http://groups.yahoo.com/group/development-axapta/
Individual Email | Traditional
http://groups.yahoo.com/group/development-axapta/join
(Yahoo! ID required)
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/development-axapta/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
