looping through grid

[ljaupi]

Hello,

I've got a grid that has got a few pages of records. How can I loop through the grid and look for a vale in a field?

Thanks,
Luan

[CharlesParker]

Re: looping through grid

to look at it or to use it in an expression?

[lgrupido]

Re: looping through grid

If you are looking for information from your data, it would likely be easier to just connect to the database directly and search there.

However, why not just setup a standard search field? That will not only find the value in the field, it will also setup the grid so only those values are displayed.

[ljaupi]

Re: looping through grid

I'd like to write some Javascript that gets latitude and longitude values and plots them on a map. Will use the search to filter teh data and then go through all pages and get latitude and longitude and plot them on the map.

Thnx

[RichCPT]

Re: looping through grid

If you are wanting to do this client-side, you can only 'see' the data from the rows of the current page. You have to go to the server to see the other rows of data from the other 'pages'. If you really just want to loop through the data of the current page on the client-side then use the following grid method inside a 'for' loop:

{grid.Object}.getValue(GridPart,GridFieldName,[row - omit for Search and Detail View part])

You can get the number of rows to loop through by using:

{grid.Object}.getRowsInGrid()

However, if you have an updateable grid and you allow inserting of rows then you might have to search through the negative row numbers that are used for the new records. I don't recall the specifics on dealing with the 'new' row values, but I think you'll find info about that in the on-screen help for getRowsInGrid().

[lgrupido]

Re: looping through grid

I still think you are better off getting your search criteria and search the database directly.

If you need it in Javascript, then run an xbasic function to get the data, then pass that data to your javascript function like this:

function getdata as c (e as p)

connect to database ;

mydata = data from the database in json format

getdata = "javascriptfunctiontorun(mydata)"

Obviously, there is much more to the code than that, but that gives you the gist of what you would need.

[RichCPT]

Re: looping through grid

I use the technique from my post # 5, to walk through an updateable Grid and put red borders around any field values that are in error. Sometimes, it may not be known if a field value is in error until it is compared against all other rows in the Grid. The OP does not state what is to be done with the value he's looking for.

[Ben S.]

Re: looping through grid

I found this thread and was hoping to find an example of JavaScript that can loop through all cells in a grid. I expect that this is not an unusual request but I haven't found grid methods to work with the columns.
This type of loop would be useful in an updatable grid to perform data validation before saving.

var rowNum
var colNum
var colName 
var fieldValue 

for (rowNum = 1; rowNum <= {grid.Object}.getRowsInGrid(), rowNum++) {
    for (colNum = 1; colNum <= {grid.Object}.getColumnsInGrid(), colNum++) {  // <--- Need help here
        colName = {grid.Object}.getColumnName(colNum);                        // <--- Need help here

        fieldValue = {grid.Object}.getValue('G',colName,rowNum);
        console.log('Row: ' + rowNum + ', Column: ' + colNum + ' (' + colName + ') = ' + fieldValue);        
    }
}  

[lgrupido]

Re: looping through grid

Grids have built in methods for doing data validation already. If you have really complex validation, you can write script into the appropriate event (canupdate I think) to validate there, so there would be no reason to build your own column by column, row by row script to do this.

[Ben S.]

Re: looping through grid

I need to validate a variable number of columns and can't hard code the column names. It's a bit hard to explain. Maybe the built-in Alpha validation would handle it but I don't know enough about it.

I created a routine that will loop through each cell by row and column and explained my column situation in this thread:

https://www.alphasoftware.com/alphaf...l=1#post737857

[RichCPT]

Re: looping through grid

debugger;
var gr = {Grid.Object};
var msg = '';
var val = '';
var cName = '';
var row = 3; // Replace this with your row loop
for(var k=0; k < gr.gridColumnInfo.length; k++ ) {
	cName = gr.gridColumnInfo[k].name;
	val = gr.getValue('G',cName,row);
	msg = msg + cName + '=' + val + ';  ';
}
alert(msg);

[Ben S.]

Re: looping through grid

Where did you discover gridColumnInfo? I don't see that in the documentation, in the forum, or in in Google.

[RichCPT]

Re: looping through grid

Ben,
To find the variable, 'gridColumnInfo', I put the first two lines of code (from post # 11) into the Javascript for a temporary toolbar button and ran it under Chrome with debugging tools turned on. After the 'var gr = …" , I inspected the contents of the contents of the local 'gr' variable in dev tools until I found what I was looking for. I knew the variable existed because I had seen it before in stepping through some of the AA JS code, perhaps it was the {grid.object}.getValue() code that I first saw use of that variable.

[Ben S.]

Re: Looping through grid rows and columns with JavaScript

Rich,

Thanks for revealing the undocumented gridColumnInfo for use in JavaScript. This saved me the hassle of dealing with an XBasic routine to build a string of the column headings and putting them into a session variable so they would be visible to JavaScript. For anyone else looking for undocumented grid objects, here are two more: detailViewColumnInfo and searchColumnInfo . They are for internal use and may change at any time. YMMV.

Below is the JavaScript nested loop I'm using to evaluate every row and column in my grid to set 'Forecast' 0 values to null inside the canGridSubmit() Client-side event

/* 
 This code will loop through all grid cells and change 
 all Forecast values of 0 to null. 
 This is called by the canGridSubmit() Client-side event. 
*/ 
    var gr = {Grid.Object}; 
 
    var rowNum; 
    var colNum; 
    var colName; 
    var fieldValue; 
     
    // If you want this to only process the selected row in the grid replace the first For loop with the following statement. 
    //rowNum = {Grid.RowNumber}; 
 
    for (rowNum = 1; rowNum <= {Grid.Object}.getRowsInGrid(); rowNum++ ) { 
//console.log(rowNum); 
 
        for (var colNum = 0; colNum < gr.gridColumnInfo.length; colNum++ ) { 
//console.log(colNum); 
     
            colName = gr.gridColumnInfo[colNum].name; 
 
            // Only process the weekly forecast columns 
            if (colName.substr(0,7) == 'FCST_20') { 
                fieldValue = {grid.Object}.getValue('G',colName,rowNum); 
                console.log('Row: ' + rowNum + ', Column: ' + colNum + ' (' + colName + ') = ' + fieldValue); 
     
                // Must use quotes around '0' because an empty string '' == numeric 0. 
                if (fieldValue === '0'){ 
                    {grid.Object}.setValue('G',colName,rowNum,null); 
                }         
            } 
        }     
    }  

Sorry for the delayed response. I've been meaning to follow up on all the forum help I receive so others can benefit in the future.

[lvasic]

Re: looping through grid

Rich,
I've noticed that this function "{grid.Object}.getRowsInGrid()" is'nt working. Is this still working for you?