CRM 2020 R1 ArgObj property not working?

Question

List=CRM.GetBlock("maProjectUserGrid");
List.prevURL=sURL;

FilterBox=CRM.GetBlock("maProjectUserFilterBox");
FilterBox.NewLine = false;
FilterBox.DisplayForm = false;
FilterBox.DisplayButton(Button_Default) = false;
FilterBox.ButtonLocation=Bottom;
FilterBox.ShowValidationErrors = false;
FilterBox.RefreshFromContent = true;

container = CRM.GetBlock('container');
container.AddBlock(List);
List.ArgObj = FilterBox;

I've used code similar to this for years. With CRM 2020 R1 the filter does nothing. In the SQL logs from CRM 2018 and CRM 2020 R1 after clicking the 'Filter' button:

CRM 2018:

Apr 7 2020 13:43:43.332 5648 5056 3 fselectsql,time,sql 79 select count(*) as fcount from vmaProject WITH (NOLOCK) WHERE (prjct_UserId=1 OR prjct_LeadConsultant=1 OR prjct_Consultant2=1 OR prjct_Consultant3=1) AND prjct_stage = N'Planning'
Apr 7 2020 13:43:43.348 5648 5056 3 fselectsql,time,sql 15 SELECT prjct_referenceid, prjct_salesorderno, prjct_name, prjct_stage, prjct_status, prjct_golivedate, prjct_companyid, prjct_maprojectid FROM ( select prjct_referenceid, prjct_salesorderno, prjct_name, prjct_stage, prjct_status, prjct_golivedate, prjct_companyid, prjct_maprojectid , ROW_NUMBER() over(ORDER BY prjct_referenceid DESC , prjct_maProjectID DESC ) AS rowranking from vmaProject WITH (NOLOCK) WHERE (prjct_UserId=1 OR prjct_LeadConsultant=1 OR prjct_Consultant2=1 OR prjct_Consultant3=1) AND prjct_stage = N'Planning' ) as A WHERE rowranking > 0 and rowranking < 11

CRM 2020:

Apr 7 2020 14:26:31.704 3392 4284 3 fselectsql,time,sql 0 select count(*) as fcount from vmaProject WITH (NOLOCK) WHERE (prjct_UserId=1 OR prjct_LeadConsultant=1 OR prjct_Consultant2=1 OR prjct_Consultant3=1)
Apr 7 2020 14:26:31.710 3392 4284 3 fselectsql,time,sql 0 SELECT prjct_referenceid, prjct_salesorderno, prjct_name, prjct_stage, prjct_status, prjct_golivedate, prjct_companyid, prjct_maprojectid FROM ( select prjct_referenceid, prjct_salesorderno, prjct_name, prjct_stage, prjct_status, prjct_golivedate, prjct_companyid, prjct_maprojectid , ROW_NUMBER() over(ORDER BY prjct_referenceid DESC , prjct_maProjectID DESC ) AS rowranking from vmaProject WITH (NOLOCK) WHERE (prjct_UserId=1 OR prjct_LeadConsultant=1 OR prjct_Consultant2=1 OR prjct_Consultant3=1) ) as A WHERE rowranking > 0 and rowranking < 11

Clearly in CRM 2018 the WHERE clause is expanded to include the Filterbox field 'prjct_stage', but not in CRM 2020 R1.

Has anyone else seen this?

Is there a workaround?

Thanks, Paul

Paul C · Accepted Answer

It appears that if the PermissionsEntity and PermissionsType arguments are passed to the CRM.Button() method then filtering gets broken. I am using these to control access to the New Project button to control which users can see the button. If I remove the arguments then filtering works as it should and the New Project button is displayed (and works). Oh well, it's only taken me a whole day (well, 12.5 hours actually) of unbillable time to figure this out. Thanks, Sage.

Paul C · Answer

hi Conrad - you were a great help thanks! 
 I removed the security arguments from the CRM.Button() method: 
 //fbHtml += CRM.Button("New Project", "new.gif", CRM.URL("maProject/maProjectNew.asp")+"&E=maProject", 'maProject', 'insert'); fbHtml += CRM.Button("New Project", "new.gif", CRM.URL("maProject/maProjectNew.asp")+"&E=maProject"); 
 The first line (remarked) is the original, replaced with the second line. Without the security arguments ( , 'maProject', 'insert') filtering works! 
 If you can replicate this then that would be good.

Conrad Roux · Answer

Hi Paul, Sorry that it took you so long and that I was not of greater help to you. Can you show me what you did. If I can replicate this then we can escalate it. You could use logic in the code to display or not display the button (instead of permissions arguments), that should do the job, if I understand you correctly. To answer a previous question you had about the field values: When I need to get the value I assign the block to an enum, then loop the enum with item property, when I need to get the value of the item, you can just use Request.Form to get the value -> String(Request.Form(myE.item())) Hope this helps.

Sage CRM

CRM 2020 R1 ArgObj property not working?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING