Changing GUI records programatically in web

[barrymavin]

Unless of course you have an order by on the section. In which case it will not follow a newly added record. It will follow the ordinal position in the order.

[barrymavin]

Simon,

In a previous post in this thread I asked you to remove the order and set the "name" field as the "Search field" on your section.

This causes the records to be ordered by "name" and when adding a record the "active record" will remain on the newly added record.

[barrymavin]

This all works as expected in 7.2Beta38.

[SpringBox]

Hi Barry

Downloaded 7.2 Beta 38.

That works great in development/runtime mode but cannot recreate your suggestion in web. Records are always displayed in unordered table record order.

As before, we did :

order by name removed from all sections. Same database and table in all sections.

Name field (cust.name) set as search field - records displayed in table order in web

Name field set as default search field - records displayed in table order in web

Name field (cust.name) set as search field AND default search field - records displayed in table order in web


What have we missed? Is the fact that we have both form and canvas sections in the same app relevant?

Not sure what to do next with this one.

Cheers


Simon

[barrymavin]

Simon,

it works perfectly fine for me.

I would suggest you create a simple app with a form section and specify a search field and try it.

If you want me to review your application and fix any logic errors that I find please email me.

[SpringBox]

Hi Barry

Good idea.

Created a new app and added one form section with some fields. Only used the GUI wizard. There is no code in this new app.

Specified the name field as both search and/or default search (don't understand the difference) and the behaviour is as before.

Tried with and without specifying the default search option in the wizard - same unordered behaviour.

Replaced with a canvas section - same behaviour.

Works great in dev (records displayed in name order) but in web the records are again always in unordered/table order.

**********************************************

Maybe its the data.

Deleted the test app & remade it using the southwind database, table = customers. Form section.

The southwind customer table is sorted on Customer ID so made the search field contact name.

Ran the app in dev - works perfectly.

Ran the app in web - same issue - table displayed in unordered/table order.

How are you getting this to work?



Simon

[barrymavin]

Simon,

check the search field on the customerid formitem. Are you using the GUI to do this or what exactly.

[SpringBox]

The only odd thing we have noticed

In our normal app, when we log in as admin (no App Center role level security) the instant search box works fine, displaying the appropriate records. The records are still displayed in table order but when exiting the instant search box, the correct "name" order record is displayed briefly before going back to table order.

However, when we log in using a normal user (ie non admin) (example of filter from App Center role level security is "company_no = 31") the instant search box never works, despite there being plenty of records that should show up. It always returns "no records available"


The instant search in the simple app with no code using our data never works, whether logged in as admin or some other user.

Don't know if that is relevant

Cheers



Simon

[SpringBox]

Hi Barry

Yes, only using the GUI

Please see attached

Cheers


Simon

[barrymavin]

Simon,

I can’t debug your application on the forums.

Please just follow what I’m asking you to do rather than jump all over.

if you cannot get a simple app to work as I advised, package it up using southwind and attach to a ticket.

Does the the example_webapp1 work on your machine? If it does not then you have messed up the distribution or have a programming error in your logic.