Home » discuss » Public forums » iMIS Community

SQL User_names in 10.6 are what in 15.1

Posted October 20th, 2009 by Greg_REIQ
| | | |

Hi people.

In 10.6  our users run an ADHOC query to identify which records they have touched during the day to produce labels to post out their results..

In this case the Name_Results_Summary  table where their username is entered into the table in the updated_by field.

Here is the username element fo the adhoc..

Name_Results_Summary.UPDATED_BY = Substring(user_name(),1,Case when charindex('_',user_name()) > 0 Then charindex('_',user_name())-1 Else len(user_name())End )

How would I look for the user now in i15.1 adhoc or IQA?

I suppose the question is how is the username passed to queries/IQA in i15?

Thanks in anticpation..

‹ "GetPropertyValue" function is ASI COMMON SERVICESissues publishing imported content files in WCM ›
login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

And the answer is...

On November 3rd, 2009 Greg_REIQ says:

Hi all.

The answer is - "i15 does not pass user details to the database" ergo I cannot use this adhoc in i15.

The solution is to create a separate crystal report version for "my work today" and use the lvSession.userid to compare with the "updated_by" field. Of course there is a date involved so there is either a parameter or additional report version to deal with this.

Hope this helps you..

login or register to post comments