Open UX to specific record when UX is opened from TabbedUI

[[email protected]]

I am opening a UX from a Tabbed UI so the filtering options are different (limited) compared to opening from a button on a grid or another UX.
The UX is bound to a table.
I am loading primary keys when the UX initializes.

How can I open the UX and display a specific record. In other words filter it? At the moment it always displays the first record in the bound table.

I have set an argument on the UX and can populate the argument with a session variable but I can't see how to apply the argument as a filter so the correct record is displayed.

[CharlesParker]

Re: Open UX to specific record when UX is opened from TabbedUI

The UX itself should filter the records using the session variable not the tabbedUI's button calling it - at least that what works for me every time! Now I do not really know exactly what your doing so I could be off base but again, that's how I do it.
SO for testing my UX, I can either set the session var to a known value or remove it, then uncomment it and publish. So the session var gets set in the Server-side onDialogInitialize event and filters the records.


SO what defines the "correct" record? userid? companyid? a specific productid?

Is this a list control in the UX?

[[email protected]]

Re: Open UX to specific record when UX is opened from TabbedUI

Thanks Charles, I'm wanting to apply the filter to the UX itself, rather than a control on it.

My UX is bound to a table containing user information. I want to filter the UX to display the record for the currently logged in user.

The only way I can see to filter the UX is to set an argument on the UX (eg arguserid) then when I add the button for the UX to the tabbedui navigation pane I can set the argument to the session variable (arguserid = session.currentuserid).

However when I do this and open the UX the first record in the table is displayed rather than the record matching the filter. It's got me stumped!

[[email protected]]

Re: Open UX to specific record when UX is opened from TabbedUI

Thanks Charles, I'm wanting to apply the filter to the UX itself, rather than a control on it.

My UX is bound to a table containing user information. I want to filter the UX to display the record for the currently logged in user.

The only way I can see to filter the UX is to set an argument on the UX (eg arguserid) then when I add the button for the UX to the tabbedui navigation pane I can set the argument to the session variable (arguserid = session.currentuserid). But how do apply this argument as a filter? It's got me stumped!

[CharlesParker]

Re: Open UX to specific record when UX is opened from TabbedUI

Again, the filter should be in the UX. How are you setting the value of session.currentuserid? That should be in the Server-side onDialogInitialize event then in the lookup for the table set the WHERE clause in there. You can also ORDER the records then from there. The only code in the tabbedUI should be automatically generated to simply open the UX.
Remember one thing, your UX is doing exactly what your telling it to, frustrating as it is - you'll get it. I filter records based on company_id and user_id in every UX I got and this is how I do it, AND my application runs exclusively in a tabbedUI as well.

In my UX Server-side onDialogInitialize event
I have this:

function onDialogInitialize as v (e as p)
		dim cn as sql::Connection
cn.open("::Name::Connection1")

dim pUser as p
dim pUser.userid as c
a5ws_logged_in_user_values(pUser) 
'gets logged in user data to pointer 'pUser'.
session.coid = sql_lookup("::name::Connection1","users","userid='"+pUser.userid+"'","company_id")

so this simply selects the company id from the users table WHERE the userid = pUserid.userid
and assigns the companyid to the variable session.coid

If your connecting to a table then in the Load Primary Keys for Parent Table, I check Filter and put in that the company_id = session.coid

This will effectively result in ONLY the records showing the company records belonging to that user. You can further filter as you would like and order them from there.

NOW if this is a list control the filtering and order get setup in the list control not here - however since the var is set when the UX is opened the function onDialogInitialize
works for BOTH perfectly!


So in the end I think regardless of what your setting the var to the UX is still not filtering by it so it doesn't matter what your setting it to - just a guess though!

[[email protected]]

Re: Open UX to specific record when UX is opened from TabbedUI

Thanks Charles, I was setting the session variable without issue, the issue I had is that I couldn't see where to set the filter for the UX.

In your post above you mentioned that there is a filter option in the Load Primary Keys server side action. That is exactly what I was looking for, so thanks for your help, much appreciated.

Regards, Richard.

[CharlesParker]

Re: Open UX to specific record when UX is opened from TabbedUI

Awesome, glad I could help!