Getting list data in Xbasic function

[datacrunch]

Hello All,

I'm trying to get record id from a list and use that id in a stored procedure.

I have done it many times using e.dataSubmitted.Fieldname what is the e. data for a list?

Thanks

[lgrupido]

Re: Getting list data in Xbasic function

The e.data for a list is the same as for any control, provided there is a value in the list selected.

If none of the list rows have been selected, then it won't have a value.

If you are doing it by clicking on the list, make sure you use the right event. For a list, I think the select event is your best bet, but not sure.

[datacrunch]

Re: Getting list data in Xbasic function

Hello Larry,

Thanks for the reply. I was using e.dataSubmitted.List::TrainLink::trnid instead of e.dataSubmitted.TrainLink

It works. Thanks :)

[canc]

Hi larry

Hope you are well

I noticed you replied to this post and I wonder if you advise on my issue around lists

I have a list called Enquires and when a user presses a button I need to get a value from the first field in the list of the row selected and pass this to a SQL arguement

Would you know I use e.datSubmitted or do have to do something the JSON e.__listdata

thanks in advance

john

[lgrupido]

If the value of the list is the same as the value of the first field, then you can use the value of the list. (You can set the list value in the properties.)

If it is NOT the same as the value of the list, you have some choices.

If the value of the list is the ID of the record, you could simply look up that value or any other value you want using SQL.

OR, if you setup the list with a detail view, you can have any value in the detail view available with e.datasubmitted.fieldname. (This is the easiest way, and also the easiest to debug)

Finally, I believe that in recent versions of Alpha, you can even submit the list values when make an Ajax callback. I haven't done that yet, but it is probably easy enough to learn.

[WayneH]

Hi John,

if you are going to set an argument, you need to pass the list value into an object and have it set server side. Like mentioned above, if the value is the return value of the list (primary key likely), then you can just reference the list itself. If it’s a column in list, you can identify it.
I think the cleanest is pass that value to a state variable and then grab it on the server side and set the argument using an xbasic method. State variables are available both client and server side. Arguments have to be set server side.

Handy state reference:

server-side (Xbasic)
Code:
Set state variable - e._state.myvar1 = "alpha"
Read state variable - myvar1 = e._state.myvar1

Client side
Code:
var myvar = {dialog.object}.stateInfo.myvar1;
{dialog.object}.setStateInfo({myvar1:"alpha"});

https://documentation.alphasoftware....nformation.xml

I can give you one of my template UX’s that I use as a starting place to mess with things in Alpha if you want. It’s based on northwinds and you can watch how values pass around. I have a text box in it that shows the values in your arguments and state as they change.

Wayne

[madtowng]

I'm going to push my luck here. Is there a method to open a UX and populate it based on a value from the list control or a state variable?

[lgrupido]

Yes. Easiest way is to make the value of the field you want be the value of the list. (Generally the Primary Key of the record in question.)

Then set an argument to the list value and use that argument when you open the UX.

[canc]

Hi Wayne

Sorted thanks just needed the primary key so all good

it ended up being a typo :-(

thanks