Advanced Search Columns

I got the results I needed with the Advanced Search but when I added an additional Column it did not show up.

When I moved that field up in the Customize Display, it was there but
the last field on the list did not show up.

It looks like only 7 columns can be displayed, no more. Even tho there is a lot of white space to the right of column 7 where the additional columns should be.

Customize the People View shows up to 11 columns just fine.

I expect all Customized views to work identical.

3 Likes

At first I saw the limit you spoke of. Then while I was checking customize on the People List View and the Basic Search all of a sudden I could add more columns on the Advanced Search and it would display them all. Not sure which one triggered it to start working. I can’t report this unless I can recreate why they weren’t showing in the first place.

In the People List View I deleted the column then did an Advanced Search and I was able to add multiple columns.

Even tho this is a work around, if you don’t know about it.

I will do a test on my other pc. Thanks

UPDATE: Did a test on another pc and the columns added in Advanced Search as they should.

Left over Halloween gremlins I guess.

@rzamor1 and @MadDog --Sorry MadDog–it’s NOT Halloween gremlins as I’m having the same issue in every database I open-- BTW, you can have more than 11 columns—I’ve tried 36–so I guess you could have all of them if you wish…
3rd database I have tried and all have been the same— this time I went into People List first and added 1 more column

then went into Search and increased my customize column list to 25 ( started off with 5)-- clicked okay and only 1 was added…
NOTE that the People and Search Columns NOW show the exact same columns and the exact same amount of columns..

Played with this quite a lot and what I found so far is that however many columns you have showing on the Advanced Search page depends on how many columns you have showing on the People Search page…meaning if I have 6 on the People Page, it will only show the first 6 (out of 15) I have chosen on the Advanced search page ( and they don’t have to be the same 6 columns).
@rzamor1 -If I go back to my People List and reduce the customized columns back to the original 6, my 15 columns in Advanced ( and Basic) Search will still show UNTIL I close and back up the program— the next time I go back into the program Advanced search will only show 6 even though I have 15 in the Customized List window…

4 Likes

Great job finding that. I can confirm it now and have reported it to development.

2 Likes

Nice job trouble shooting this. Once I followed Renee’s directions I could not duplicate it.

Was hoping it was an ancestor spooking me :slight_smile:

Thanks.

2 Likes

Thanks

I actually figured out that this was also happening in RM 10 BUT you would NOT notice it as you couldn’t customize the search page..

For complete transparency, working on this in RM 11 caused a lot of Access Violations


and this one— List Index out of Bounds–normally showed up when I would be removing a lot of Fields to Display

Had to force close the program otherwise it would keep giving other errors when I tried to close normal such as

and typically a runtime 217 error after closing…

The interesting thing was after the access violation showed up and I closed and reopened same database in RM 11 where I had 25 columns selected for Advanced Search and 6 for People List, there would be 7 columns that showed in Advanced Search..

So who knows what is going on…

1 Like

I’m not sure what the limit is on columns but I would not recommend adding more than is reasonable. If you added 36 you may have hit the limit. See if restoring a backup made before adding them all will fix it.

Your “List index out of bounds” and getting 7 columns instead of 6 and other cases of things being off by 1 is suggestive of programmer confusion because in some cases numbering begins at 1 while in others it’s at 0. An array might have 6 rows with the first at 0 and the last at 5 while the corresponding record numbers in a database table are from 1 to 6. Likewise for columns. Any mapping between the two has to take that into account and is easily overlooked.

2 Likes

As of today 11/19/2025 with the latest update 11.0.3.0, this seems to have been fixed

1 Like