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 =
                            @"
                                      
                                        
                                        >
                                        
                                        
                                        
                                        
                                          
                                          
                                          
                                        
                                        
                                          
                                        
                                      
                                    ";

All responses (4)

Answers (0)

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
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.
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?
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