custom field value

GT73 · Post by **GT73** » Mon Mar 25, 2019 7:45 pm

Hi, I'd need inserting a default value in to custom field. I tried with these query but don't works
default value = ("select parametri.ValoreSconto FROM parametri WHERE parametri.idParametro = (SELECT azienda.idParametri FROM azienda)")

I tried so but don't works
Page_load
$sconto = ExecuteScalar("select parametri.ValorePunti from parametri WHERE parametri.idParametro =(SELECT idParametri FROM azienda)");
$this->c_Sconto->CurrentValue = $sconto;

mobhar · Post by **mobhar** » Tue Mar 26, 2019 11:58 am

Make sure this part "SELECT idParametri FROM azienda" won't return more than one record. In addition, try to use "Row_Rendered" server event instead.

GT73 · Post by **GT73** » Tue Mar 26, 2019 7:25 pm

field table Azienda
idParametro->FK->parametri(1)

field table parametri
id1 -> ValorePunti (1) ValoreSconto (10)
id2 -> ValorePunti (3) ValoreSconto (40)
id3 -> ValorePunti (5) ValoreSconto (20)
...
custom field table movimenti
c_Sconto = Expression ->(select parametri.ValoreSconto from parametri WHERE parametri.idParametro = (SELECT idParametri FROM azienda)) in list page I see = 10
c_AssegnaPunti = Expression ->(select parametri.ValorePunti from parametri WHERE parametri.idParametro = (SELECT idParametri FROM azienda)) in list page I see = 1

table movimenti
//Row Rendered event
function Row_Rendered() {
// To view properties of field class, use:
//var_dump($this-><FieldName>);
$sconto = ExecuteScalar("select parametri.ValoreSconto from parametri WHERE parametri.idParametro =(SELECT idParametri FROM azienda)");
$punti = ExecuteScalar("select parametri.ValorePunti from parametri WHERE parametri.idParametro =(SELECT idParametri FROM azienda)");
$this->c_Sconto->CurrentValue = $sconto;
$this->c_AssegnaPunti->CurrentValue = $punti;
}

returns only one record. the ValorePunti field is an EditTag-> Select field with 1,2,3,4,5, as values, only one value is selected (1). should return 1 but not work.
returns only one record. the ValoreSconto is an EditTag-> Select field with 0,5,10,15,20,25,30 ... 100 etc. .. only one value is selected (10). should return 10 but does not work.

when I'm in add page I don't see any value

mobhar · Post by **mobhar** » Wed Mar 27, 2019 3:59 pm

This code:
$this->c_Sconto->CurrentValue = $sconto;
$this->c_AssegnaPunti->CurrentValue = $punti;

change to:
$this->c_Sconto->ViewValue = $sconto;
$this->c_AssegnaPunti->ViewValue = $punti;

GT73 · Post by **GT73** » Wed Mar 27, 2019 10:11 pm

I deleted the expression from the custom fields, it works like this...

function Row_Rendered() {
// To view properties of field class, use:
//var_dump($this-><FieldName>);
$sconto = ExecuteScalar("select parametri.ValoreSconto from parametri WHERE parametri.idParametro =(SELECT idParametri FROM azienda)");
$punti = ExecuteScalar("select parametri.ValorePunti from parametri WHERE parametri.idParametro =(SELECT idParametri FROM azienda)");
$this->c_ValoreSconto->CurrentValue = $sconto;
$this->c_ValorePunti->CurrentValue = $punti;
}

the two custom fields are in lookup table, how can I display the "label" of the original field in "DisplayField # .."?

mobhar · Post by **mobhar** » Sat Apr 06, 2019 5:52 pm

GT73 wrote:
how can I display the "label" of the original field in "DisplayField # .."?

Just assign the "ViewValue" property of that field like the code I gave you before.