Row Expander with custom xbasic object

[RankFirstPro]

I am trying to use the row expander with a custom xbasic object. Right now, I can fill it with a session variable that get's filled on the client side event CanRowExpand , but I can't get the info fast enough, so first it loads old info then refreshes to add new.

My question is does anyone know how to use the following recommended feature:

e.primaryKeyValuesArray = Array containing values for all columns in the primary key for the current row

This is what I've tried (I don't know if it's correct)

dim session.Comments as c = e.primaryKeyValuesArray.comments

And this is the crazy error I get (things like function are misspelled, maybe it's an error :-/ I normally don't say that but it's so strange)

Screen Shot 2013-08-29 at 7.40.47 PM.png

[RankFirstPro]

Re: Row Expander with custom xbasic object

Bump, I really need this working, anyone know how to use it properly?

[Peter.Greulich]

Re: Row Expander with custom xbasic object

I don't have time to study you code but CanRowExpand is JavaScript. Your using xbasic. Maybe the server side xbasic OnExpandRow would work for you?

[RankFirstPro]

Re: Row Expander with custom xbasic object

I don't know enough about javascript in order to convert it over to xbasic

This is the code I'm using on client side events (which I've tried a few different events canRowExpand, onRowSelect, afterRowExpand, BeforeAjaxCallback)

var rowNum = {Grid.Object}._selectedRow;
var ele = {grid.object}.getValue('G','COMMENTS',rowNum);
var pstring = '__comments=' + ele

{grid.Object}.ajaxCallback('G',rowNum,'OnRowExpand', '', pstring

So I attempted to convert this over to the server side (and this is where my lack of javascript skills comes in)

dim rowNum as n = "{Grid.Object}._selectedRow;"
dim ele as c = "{grid.object}.getValue('G','COMMENTS',rowNum);"
dim pstring as c = "'__comments=' + ele"
	
e.javascipt = "{grid.Object}.ajaxCallback('G',rowNum,'OnRowExpand', '', pstring);"

I ended up with an empty value

The function I am calling from that code sets the session variable like this:

dim session.Comments as c = ""
session.Comments = e.__comments

Then I use that session variable in another function to add the value to the row expander

I feel like there are ways to do less steps and get better results but I really don't know how.

[Peter.Greulich]

Re: Row Expander with custom xbasic object

{grid.Object}.ajaxCallback('G',rowNum,'OnRowExpand', '', pstring)

I assume that "OnRowExpand" is the name of your xbasic function? if so that's probably not a good name to use. You can't call the event if that's what you are trying to do?

[RankFirstPro]

Re: Row Expander with custom xbasic object

Yes, that is the name of my function, I can change that.

[RankFirstPro]

Re: Row Expander with custom xbasic object

I did change the name of the function and that didn't make a difference, I don't think my javascript code was correct.

Does anyone know how to use this: e.primaryKeyValuesArray

correctly?

Thanks so much!!! :-)

[Peter.Greulich]

Re: Row Expander with custom xbasic object

Lily,

Your explanation for what you are trying to do is a little confusing. It might help if you tell us what you are trying to do?

e.primaryKeyValuesArray = Array containing values for all columns in the primary key for the current row

According to the inline documentation:

'e.primaryKeyValuesArray - an array of the primary key values for the row that was expanded.

This contradicts your quote above.

Remember too, you can only use e.primaryKeyValuesArray server side, not client side.

[RankFirstPro]

Re: Row Expander with custom xbasic object

That is an exact quote from the commented section of the function prototype in the row expander function. So I really don't know what the correct explanation is.

Properties>Row Expander >Row Expander Linked Content >Add Object > Add Custom XBasic Object >Show xBasic Function Prototype

function SupplementDetails as c (e as p)
'Request - The Request object. Includes Request.Variables, which should be used instead of the older e.rv construct
'Session - The Session object. Should be used instead of the older e.session construct

'The 'e' object that is passed in contains:

'e.tmpl - Grid definition
'e.rtc - A pointer variable that is passed to all server-side events allowing you to pass data from one event handler to another
'e.__si = Saved state information
'e.rowNumber = Row number of the current Grid row
'e.primaryKeyValuesArray = Array containing values for all columns in the primary key for the current row
'e.request = Request object
'e.componentName = Grid alias


'Your function must return the HTML that will be displayed.
'If you want your function to also return some Javascript then set the e.javascript property

SupplementDetails = "Return HTML to display"

end function

Do you think it is the wrong explanation?

[Steve Workings]

Re: Row Expander with custom xbasic object

Lily - Basically, e.primaryKeyValuesArray returns the primary key of the parent row that is being expanded.

[RankFirstPro]

Re: Row Expander with custom xbasic object

Okay, then that description is wrong :-(

[[email protected]]

Re: Row Expander with custom xbasic object

Okay, then that description is wrong :-(

"'e.primaryKeyValuesArray = Array containing values for all columns in the primary key for the current row "

If the primary key consists of more then one column/field then I can very well understand why it is being described as it is :)
So if the key is a single field you will have a single value in the array.
If the key consists of two fields you will have two values in the array.

hth

Pieter

[RankFirstPro]

Re: Row Expander with custom xbasic object

That makes sense, I didn't slow down to think about it I guess. I was just focused on all columns for the row and skipping over the rest of the description. Thanks Pieter.

[Peter.Greulich]

Re: Row Expander with custom xbasic object

That makes sense, I didn't slow down to think about it I guess. I was just focused on all columns for the row and skipping over the rest of the description. Thanks Pieter.

The best way to see what's going on in situations like this is to simply use the debugger. Then you can inspect the contents of e.primaryKeyValuesArray directly.

[aburningflame]

Re: Row Expander with custom xbasic object

Tables with 1 Primary Key:
dim person_id as N=convert_type(e.primaryKeyValues[1],"N")
OR
dim item_code as C=e.primaryKeyValues[1]


Tables with a composite key:
dim compositeKeyPart1 as C=e.primaryKeyValues[1]
dim compositeKeyPart2 as C=e.primaryKeyValues[2]

SO if you want to test
dim pkVal as C=e.primaryKeyValues[1]
e.javascript="alert('"+pkVal+"');"