You will probably need to add a custom column to display the value with a webskin. That wouldn't allow you to filter or sort by the status though.
Blair On Sat, Mar 13, 2010 at 8:16 PM, AJ Mercer <[email protected]> wrote: > When viewing Users in User Directory, I would like to display the > userstatus. > > User Status is strored in farUser > So I thought I could pass in my own query - but memberStatus is displaying > as '-- not available --' > > Is there a way to make this happen? > > Farcr 6.0 > > <ft:objectadmin > qRecordSet="#qryUserProfile#" > typename="dmProfile" > title="Member Administration" > > columnList="username,membershipnumber,firstname,lastname,department,memberStatus" > sortableColumns="username,department" > lFilterFields="username,firstname,lastname,department" > sqlorderby="username asc" > lCustomActions="Change password" > lButtons="#lButtons#" > /> > > <cfquery name="qryUserProfile" datasource="#APPLICATION.dsn#"> > SELECT dmProfile.*, farUser.userstatus as memberStatus > FROM dmProfile, farUser > where userName = CONCAT(userID, '_CLIENTUD') > order by username > </cfquery> > > -- > > AJ Mercer > http://webonix.net > http://twitter.com/webonix > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: > [email protected]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
