PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: How can I customize units when submitting a new record in registration?
Topic Summary: Customize units on Registration 11 and 12
Created On: 9/6/2012 10:57 AM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 9/6/2012 10:57 AM
User is offline View Users Profile Print this message


Aldo

Posts: 41
Joined: 7/11/2011

Steps:

1. Identify which unit id are to be selected from the table REGDB.VW_Unit.

2. Within Registration click on Customize Registration

3. From Manage System Behaviours, click on Edit Form XML

4. Navigate to the Submit New Record tab (save a copy of it before making any changes)

5. Find the line that says:

SELECT ID as key,UNIT as value FROM REGDB.VW_Unit ORDER BY upper(UNIT) ASC

and add:

WHERE ID in (put the ID of the units that you want to be displayed) it should look something like:

SELECT ID as key,UNIT as value FROM REGDB.VW_Unit WHERE ID in (1,2,5,6) ORDER BY upper(UNIT) ASC

6. Save changes and exit.



Edited: 9/6/2012 at 11:51 AM by Aldo

FuseTalk Basic Edition v4.0 - © 1999-2017 FuseTalk Inc. All rights reserved.