List design revision from active users

I developed a turn around solution. 

Scenario: The actual design and revision applied to each mobile is only registered on the mobile database. You can install FSM mobile windows application and download the database. I searched and found all tables using revision_id. I took use_mm_revision. 

The development was done by client script:

1.  I select the polulate script from JobList to make sure it will always run (in my case joblist is the first screen).
2. Add Those lines there:

//START ANDRE TOVAR - 08/04/25 - UPDATE DESIGN REVISION ON PERSON TABLE 
var rowId = getDBValue(stringFormat("SELECT metrix_row_id from person where person_id ='{0}'",getUserInfo('PersonID')));

var revision_id  = getDBValue(stringFormat("select revision_id from use_mm_revision"));
var personTrans = generateDataTransaction("person", "UPDATE", stringFormat("metrix_row_id = {0}", rowId));
var person_id = getUserInfo('PersonID');
personTrans = addToDataTransaction(personTrans, "metrix_row_id",rowId);
personTrans = addToDataTransaction(personTrans, "person_id", person_id);
personTrans = addToDataTransaction(personTrans, "user_def1", revision_id);
//alert(stringFormat("RowID:{0},Revision:{1},Person:{2}",rowId,revision_id,person_id));
var personTransSaved = saveDataTransaction(personTrans, "Person Update");

//END ANDRE TOVAR - 08/04/25

3. after updating user_def1 in the person table with the revision_id from the mobile table use_mm_revision. I added the user_def1 field to the Profile screen. 
4. Make sure your sync rule from person table is including this column (user_def1).
   
   It's not the best but solved!