Hi,
I have created a lookup to display SOAddresses. However I could not see any columns in the lookup and the only column there in the column configuration is AddressId(when I select it, it also gives an error).
Any idea about this? Below are the related screenshots.
Thanks
Best answer by darylbowman
View original
+11
Could you post the selector code?
#region UsrAddresses
[PXDBString(300)]
[PXSelector(typeof(Search<SOAddress.addressID>))]
[PXUIField(DisplayName="Addresses")]
public virtual string UsrAddresses { get; set; }
public abstract class usrAddresses : PX.Data.BQL.BqlString.Field<usrAddresses> { }
#endregion
+11
There’s a number of things wrong with how you’re defining it.
Firstly, you’re storing the address as a string instead of the int? addressID. I wouldn’t recommend this.
Secondly, there aren’t any other columns because you haven’t defined any other columns.
I would change custom field to an int? (nullable int) in both your code and the database. Then use this, or something like it:
#region UsrAddresses
[PXDBInt]
[PXSelector(typeof(Search<SOAddress.addressID>),
typeof(SOAddress.addressLine1),
typeof(SOAddress.addressLine2),
typeof(SOAddress.city),
typeof(SOAddress.state),
typeof(SOAddress.postalCode),
DescriptionField = typeof(SOAddress.addressLine1))]
[PXUIField(DisplayName = "Addresses")]
public virtual int? UsrAddresses { get; set; }
public abstract class usrAddresses : PX.Data.BQL.BqlInt.Field<usrAddresses> { }
#endregionYou can read more about options for defining selectors here.
Hi
I agree
In addition, I want to highlight that you should define which are the columns being displayed in the selector.
Regards,
+11
In addition, I want to highlight that you should define which are the columns being displayed in the selector.
I’m not sure where you got that, but according to the Acumatica wiki article, which I linked, that isn’t necessary.
In Column configuration, I can add AddressId Column but it gives this error.
+11
Could you post your code again? It seems like something still doesn’t match because it mentions a string.
#region UsrAddresses
[PXDBInt]
[PXSelector(typeof(Search<SOAddress.addressID>),
typeof(SOAddress.addressLine1),
typeof(SOAddress.addressLine2),
typeof(SOAddress.city),
typeof(SOAddress.state),
typeof(SOAddress.postalCode),
DescriptionField = typeof(SOAddress.addressLine1))]
[PXUIField(DisplayName="Addresses")]
public virtual int? UsrAddresses { get; set; }
public abstract class usrAddresses : PX.Data.BQL.BqlInt.Field<usrAddresses> { }
#endregion
____________________________________________________________________
And I want to mention that if I use a table like InventoryItem, this problem does not occur anymore. if I code like below, all the columns of inventoryItem table shows in my lookup.
[PXDBInt]
[PXSelector(typeof(Search<InventoryItem.inventoryID>))]
[PXUIField(DisplayName="Addresses")]
public virtual int? UsrAddresses { get; set; }
public abstract class usrAddresses : PX.Data.BQL.BqlInt.Field<usrAddresses> { }
+11
Works for me:
You could try deleting the custom form field and re-making it?
+11
I am using 22R1, but I wouldn’t expect that to be a problem.
Before you give up hope, confirm / try the following:
+11
If none of that works, you can try publishing the package I uploaded here.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.