This discussion is archived
2 Replies Latest reply: Nov 21, 2012 12:03 PM by Dmitriy Kolasnikov RSS

How to get value from Qualitative EA.

967310 Newbie
Currently Being Moderated
On the calculated EA, I would like to get value from qualitative EA then I put this script to the calculation script :
var flute @ GetCellInMyColumnByRowID('FLUTE').Value.GetQualitativeExtendedAttributeValue();

the error message shown like this : Objects of type 'Xeno.Prodika.ExtendedAttributeSections.Calculation.IExtendedAttributeExtractor' do not have.....
which this code i got it from the caluculated attr. material. I cannot save the script. What it must be done to save this EA?

And if I want to get value from specific cells which it is in different row and column from calculated EA , could i used " GetCell Function"?
--> var mycell @ GetCell ('rowID', 'cellID') is correct or not?
  • 1. Re: How to get value from Qualitative EA.
    970059 Newbie
    Currently Being Moderated
    The calculate button is just a helper. It doesn't work when calling values contextually from a custom section that isn't loaded. It shouldn't prevent you from saving the EA. Calculate will work when calling a few out of the box methods, the system will return a specific fixed value depending on which method you are calling.

    We should click button Done instead of calculate.

    Edited by: 967056 on Nov 19, 2012 11:07 PM

    Edited by: 967056 on Nov 19, 2012 11:58 PM
  • 2. Re: How to get value from Qualitative EA.
    Dmitriy Kolasnikov Explorer
    Currently Being Moderated
    I believe you are looking for a GetMultipleValues() method.
    var flute @ GetCellInMyColumnByRowID('FLUTE').Value.GetMultipleValues();
    This method returns an array of selected qualitative or qualitative lookup values. It will return an array containing one element if you have only one value selected in the cell. You can either iterate through array elements to see the values or use index notation like flute[0].

    You can use getCell function to access specific cells - just provide rowID and collumnID as parameters. In case of repeatable rows it will return the first row matching the rowID.

    Hope this helps,
    Dmitriy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points