Databases
StackOverflow2013
Postsdbo
POSet related entity to current user in HTML Client
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSet related entity to current user in HTML Client
    primarykey
    data
    text
    <p>I am building a Help Desk ticketing program in Lightswitch, and have been having trouble with one requested feature. I was asked to build a mobile friendly version of the app for End Users to submit tickets from their mobile devices. I built the app, with just a couple screens, and added code to the PreProcess query to limit the tickets they can see to only their own. That works wonderfully. What I'm having trouble with is assigning the currently logged in user as the submitter on a new ticket. I've looked at multiple guides online, all of which stop short at what I'm trying to do. The most promising I've found is <a href="http://social.msdn.microsoft.com/Forums/vstudio/en-US/47832659-4ed3-4a8c-9a62-b3ad46c8e8b4/get-logged-in-employee" rel="nofollow">http://social.msdn.microsoft.com/Forums/vstudio/en-US/47832659-4ed3-4a8c-9a62-b3ad46c8e8b4/get-logged-in-employee</a> With that technique, I can succesfully display the current user on the screen.</p> <p>The challenge is, setting the Ticket.EndUser field to the CurrentUserName field. I've tried it in the created method of the AddEditNewTicket screen, and the beforeApplyChanges method.</p> <p>I've been bashing my head against this wall for a couple days now, has anybody out there ever accomplished this?</p> <hr> <p>UPDATE</p> <p>So, I think I may have found the problem, just not sure how to get around it. In the execute code for the new ticket button, I create the ticket, and use <code>newTicket.setEndUser()</code>. This function takes an EndUser entity as a parameter, so I retrieve it with <code>myapp.activeDataWorkspace.MyDataBase.Techs_SingleOrDefault(CurrentUserName)</code> which returns null. UserName is the primary key for my Techs table.</p> <p>Even when I use a literal string for the UserName, it still returns null.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USbigelowr
    1. USbigelowr
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI don't know if this will work on an HTML client, but I had the same problem with a desktop client. There at least, you can just put it in the Entity_Created method. 'EnteredByUser = Application.User.Name;'
      singulars
      1. POSet related entity to current user in HTML Client
      1. USEthan48
    2. COWell, I don't want to put it in the Entity_Created method on the server side, because that would then apply to all tickets created. If a technician enters a ticket, they would then be linked as the end user.
      singulars
      1. POSet related entity to current user in HTML Client
      1. USbigelowr
    3. COEntity_created on the client side might work, except I can't get to the screen.CurrentUserName property.
      singulars
      1. POSet related entity to current user in HTML Client
      1. USbigelowr
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload