|
| | | Supreme Being
Group: Forum Members
Last Login: Wednesday, March 05, 2008
Posts: 80, Visits: 277 |
| Hi there,
I have a workflow which has at some point an array with several users.
I was wondering if there is a way of assigning these user to a certain activity in design time.
I tried something like [user_guid] IN [Array] in the assign actor property of the check-list activity, but I get the following error:
! - @#@Source - at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at Skelta.SqlDataSourceProvider.SqlProvider.QueryEntityItem(String Filter, String Query, String FullyProcessedQuery, Object[] Params)@#@Date - 11:25:46.306@#@Module - C:\WINDOWS\assembly\GAC_MSIL\Skelta.EntityDataSourceProvider\3.5.0.0__35d5e592eeafc8b0\Skelta.EntityDataSourceProvider.dll@#@_MachineName - SNITURHDEV2RC, Process - WFEngine.NET2@#@Message - Error in Getting EntityItem from EntityItem Database, - Conversion failed when converting from a character string to uniqueidentifier.@#@
I must be missing something so any help would be great.
Best regards,
Rui Costa |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Yesterday @ 6:29 AM
Posts: 105, Visits: 556 |
| Hi Rui, Could you show the code thru which you are trying to do something like “[user_guid] IN [Array]”? Then only we can find out the real cause for the error.
Regards, Bineesh E Raghavan |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, April 26, 2008
Posts: 128, Visits: 422 |
| Hi,
If the Variable is of type array and the Array varible values are of Guid of the Resource, then it should work fine. What is the type of value stored in Array variable Array.
regards,
Moderator |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Wednesday, March 05, 2008
Posts: 80, Visits: 277 |
| Hi there, thanks for your help.
The array is being assigned by a Resource Variable.
On the following check-list I have selected this value trough the dropdowlists-> [user_guid] IN [Variable.guidTeste].
I would like to show you an image with this, but I have reached the attachments size limit that the forum allows (1MB). Any way of increasing this value?
Thanks for your help.
Best regards,
Rui Costa |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, April 26, 2008
Posts: 128, Visits: 422 |
| Hi,
You can remove some of the attachments posted by going to Control Panel (On top fo the page) -> Edit Attachments
regards,
Moderator |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Wednesday, March 05, 2008
Posts: 80, Visits: 277 |
| Yes, I know that, but if I do that then they will no longer will be available on the other posts right? If so other people will be unable to see them.
Thats why I didn't want to remove them.
Best regards,
Rui Costa |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, April 26, 2008
Posts: 128, Visits: 422 |
| | I'll check with the Forum administrator and let you know. regards,
Moderator |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, April 26, 2008
Posts: 128, Visits: 422 |
| The upload limit has been increased, please try now.
Moderator |
| |
| | | Supreme Being
Group: Forum Members
Last Login: Wednesday, March 05, 2008
Posts: 80, Visits: 277 |
| ok, here it goes.
Hope this helps.
Best regards,
Rui
|
| |
| | | Supreme Being
Group: Forum Members
Last Login: Saturday, April 26, 2008
Posts: 128, Visits: 422 |
| Hi,
You cannot use the resource variable array directly with IN operator. If you have multiple users you could use a script, populate another variable with user id's similar to below and then Use In operatorArrayList resvariable = (ArrayList)ctx.Variables["ResVarArr"].Value;
ArrayList listGuids = new ArrayList();
foreach (Resource resource in resvariable)
{
listGuids.Add(resource.Properties.Identifier.Value);
}
ctx.log.LogInformation("@@@@:" + listGuids.Count);
ctx.Variables["ResGuidArr"].Value = listGuids;
ctx.SaveVariables();
Moderator |
| |
|
|