Plugin help needed updating some fetch

(0) Share

Report

Posted on by GRedhead

270

I have a plugin, in which I am using a fetch query, it worked fine.

However the scope has changed and in the fetch statement, i need to update the following line, to retrieve the record where the "accountuniquenumber"'s last 7 digits match not the full value.

I know i need to update the following to sections but not sure to what, can i retrieve just the last 7 digits and then make the condition so it ends in?

if (Target.Attributes.Contains("cr011_accountuniquenumber"))
UniqueNumber = Target.Attributes["cr011_accountuniquenumber".ToString();
<condition attribute='cr011_accountuniquenumber' operator='like' value='%{2}' />

                Entity Target = context.InputParameters["Target"] as Entity;
                try
                {
                    string AccountName = "", UniqueNumber = "", ZipCode = "";
                    if (Target.Attributes.Contains("cr011_accountname"))
                        AccountName = Target.Attributes["cr011_accountname"].ToString();
                    if (Target.Attributes.Contains("cr011_accountuniquenumber"))
                        UniqueNumber = Target.Attributes["cr011_accountuniquenumber"].ToString();
                    if (Target.Attributes.Contains("cr011_address1zippostalcode"))
                        ZipCode = Target.Attributes["cr011_address1zippostalcode"].ToString();
                    #region FetchAccounts
                    string AccountsFetchQuery =
                            @"
                                      
                                        
                                        >
                                        
                                        
                                        
                                        
                                          
                                          
                                          
                                        
                                        
                                          
                                        
                                      
                                    ";

I have the same question (0)

All responses (4)

Answers (0)

Federico Pelliccia 75 on at

Like (0)

Report

RE: Plugin help needed updating some fetch

You could try something like this:

UniqueNumber = Target.Attributes["cr011_accountuniquenumber"].ToString();

UniqueNumberSubStr = UniqueNumber .Substring(UniqueNumber .Length - 7);

And yes, with like=%{UniqueNumberSubStr } (I am using $"" annotation) you should compare just the last 7 characters

Was this reply helpful? Yes No
GRedhead 270 on at

Like (0)

Report

RE: Plugin help needed updating some fetch

Hi, thanks for the reply, however when i try and update my code to your suggestion i get the following error when building the solution, it's probably me though, can you point out where I am messing up, please?

Was this reply helpful? Yes No
GRedhead 270 on at

Like (0)

Report

RE: Plugin help needed updating some fetch

Hi, i'm still getting this error, any suggestions are most welcome.

Was this reply helpful? Yes No
Federico Pelliccia 75 on at

Like (0)

Report

RE: Plugin help needed updating some fetch

You must write string before UniqueNumber. It is a variable, so you must specify the type

Was this reply helpful? Yes No