SiComponents Forums

[etwoss]

Hi

I have a query 'select * from <viewname>'

i have no persistent fields, just want to export the dataset to excel,
However i want to translate the displaylabels , something like:

[isiticov]

Hello,
There is no such "direct" method, but you may try to use GetStringValue() method to iterate through all existing strings and find your value and then retrieving it.

[etwoss]

[isiticov]

No, I mean that if you know the values of Display_Label(s) then you can add them to Strings property with some IDs like DISPL_LBL_ID_N and translate. Changing N for every label you add. Then you can iterate through DISPL_LBL_ID_N and retrieve initial value, if it is the same as designed- then return GetStringValue(@Strings,...) with needed ID and needed language.
Hope this helps.

[etwoss]

Hi

Thanks

When loading a file from disk with first param Strings, it only read the strings part and leave all other (displayLabels)?

Eric

[isiticov]

Yes,

[etwoss]

Hi

Is "GetTextOrDefault" not faster than "GetStringValue"?

Eric

[isiticov]

GetTextOrDefault returns only value for active language (and default if value not defined) but in your case you will need to obtain value of default language by GetStringValue and then you can use GetTextOrDefault to get active value if working only with Strings property.