Populate a List Control's Detail View Programmatically

[Davidk]

Re: Populate a List Control's Detail View Programmatically

I'm not aware of anything that will allow you to do this. You're essentially bypassing the data-bound List, populating it manually, but you still want data-bound features. I thought providing a Custom data source might work, but again, you're just providing a delimited list of data. In all cases other than SQL, you're not providing table information... and so syncing can't really take place.

You can always sync manually with another callback. Apart from Syncing, displaying data in the Detail View does not require the Primary Key in any Data Source except SQL. If you provide a Custom data source or a Static data source, Detail View will be populated upon row selection. You just can't sync.

You write something that sticks out, though. "Overall, the goal is to convert many UXs to be list based, instead of using data binding in the UX.". The List Control can be data bound... and this data binding is completely separated from a UX being data bound. So, I'm not sure what you mean. Are you converting UX Repeating Sections?

As far as I know, using any method other than SQL is just filling the List with data... it's one sided. As said... you can always update your tables manually with another callback.

In actual practice... let's say you could use an Ajax Callback to populate a List and have everything work. Why do you need to? What's the advantage of filling a List with an Ajax Callback?

[Pizzadude]

Re: Populate a List Control's Detail View Programmatically

OK, say I populate the list with a sql statement, so the list returns the primary key. Now I can populate the detail view and sync. So far so good.

Keep in mind that the Loads list has a child list called Stops.

I want to be able to execute searches that involve finding records based on values in the Loads list (parent). This is not a problem. I can initially load all the records I need in the sql statement, then apply server-side filters to find, for example, all records where loads.Status = 'Booked'.

But I also want to find all records in the stops table where a date field is between a range of dates. The date range is selected by the user in unbound date controls StartDate and EndDate. I want the Loads list to be populated with all the loads where the child records in the stops table has a StopDate between the dates selected. This is just one example of a search to be executed. There are several more complex searches that I need to apply in for example, the onClick event of a radio button control.

This could also probably be done using a server-side filter, but I have not found a way to pass arguments filter expression in the List Control Action - Filter list - Server-side.

The ajax callback method of populating the list is an ideal way to execute the searches. But not having a primary key for the list control makes it not as attractive.

I had started another thread http://www.alphasoftware.com/alphafo...ter-Expression