Skip to main content
Solved

BigCommerce Connector - How to get custom fields under Export Filtering drop down


vivekm
Varsity I
Forum|alt.badge.img

Hi Team,

I have created a custom field on Customers screen.

 

Is there any feasibility to get this field under Field Name drop down, under Export Filtering tab, on Entities screen, for Customer entity. To control the customer export based on this checkbox.

As if this checkbox is checked, those customers only should Prepare & Process.

 

This I am trying to achieve on build 20.221.0021.

Best answer by smarenich

@vivekm unfortunately filtering based on custom fields is not supported in 2020r2 version.

In 2021r2 we added filtering support based on the Attributes and also custom fields, but only string custom fields.

Please check if you can update to 2021r2, since 2020r2 is not supported anymore. 

View original
Did this topic help you find an answer to your question?

4 replies

smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • Answer
  • July 16, 2022

@vivekm unfortunately filtering based on custom fields is not supported in 2020r2 version.

In 2021r2 we added filtering support based on the Attributes and also custom fields, but only string custom fields.

Please check if you can update to 2021r2, since 2020r2 is not supported anymore. 


vivekm
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 78 replies
  • July 18, 2022

Thank you @smarenich for the inputs, will check with team for upgrade, if client agrees.

One more request @smarenich can you please suggest the best possible way to customize this, to get custom field for filtering, if it is possible.

 

 


smarenich
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Commerce Edition Team Lead
  • 227 replies
  • July 18, 2022

@vivekm I would recommend this way

	public class BCCustomerProcessorExt : PXGraphExtension<BCCustomerProcessor>
	{
		[PXOverride]
		public FilterResult FilterExport(IMappedEntity record, Func<IMappedEntity, FilterResult> baseHandler)
		{
			FilterResult result = baseHandler(record);

			if (record?.Local?.SyncID != null && result.Result == FilterStatus.None)
			{
				PXSelect<PX.Objects.AR.Customer,
					Where<PX.Objects.AR.Customer.noteID, Equal<Required<PX.Objects.AR.Customer.noteID>>>>.Select(Base, record?.Local?.SyncID);

				if(PX.Objects.AR.Customer.<CustomFeld> != true)
					return new FilterResult(FilterStatus.Filtered, "Customer is not enabled for BigCommerce");
			}

			return result;
		}
	}

 


vivekm
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • 78 replies
  • July 18, 2022

Thank you @smarenich for the details, will try with the suggested code piece.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings