Is it possible to pull this highlighted Stock item Description tab Information into a GI.
Solved
Is it possible to pull this highlighted Stock item Description tab Information into a GI.
Best answer by jinin
Try the below approach:
- Add an extra field on InventoryItem (e.g. UsrPlainBody)
- In a FieldSelecting event, strip the HTML tags from InventoryItem.Body and return plain text
- Bind that field in the Report
public class InventoryItemExt : PXCacheExtension<InventoryItem>
{
[PXString(IsUnicode = true)]
[PXUIField(DisplayName = "Description (Plain Text)")]
public virtual string UsrPlainBody { get; set; }
public abstract class usrPlainBody : PX.Data.BQL.BqlString.Field<usrPlainBody> { }
}
protected virtual void _(Events.FieldSelecting<InventoryItem, InventoryItemExt.usrPlainBody> e)
{
var row = e.Row as InventoryItem;
if (row?.Body == null) return;
string text = Regex.Replace(row.Body, "<[^>]+>", string.Empty);
e.ReturnValue = HttpUtility.HtmlDecode(text).Trim();
}
+12Hi
Yes. Add the InventoryItem.Body field to your GI—it contains the Description tab content.
Note: This is a rich text field, so the value will appear as raw HTML in the GI. If you need plain text, a customization is required to strip the HTML tags.
+12
No — conditions in a Report only filter which rows show; they can't strip the HTML out of `InventoryItem.Body`.
You can filter on it (e.g. `InventoryItem.Body Is Not Null` or `Contains` a keyword), but the value will still come through as raw HTML.
To get clean text in both the GI and the Report, the practical option is a small customization that adds a plain-text field on `InventoryItem`.
+12
Try the below approach:
- Add an extra field on InventoryItem (e.g. UsrPlainBody)
- In a FieldSelecting event, strip the HTML tags from InventoryItem.Body and return plain text
- Bind that field in the Report
public class InventoryItemExt : PXCacheExtension<InventoryItem>
{
[PXString(IsUnicode = true)]
[PXUIField(DisplayName = "Description (Plain Text)")]
public virtual string UsrPlainBody { get; set; }
public abstract class usrPlainBody : PX.Data.BQL.BqlString.Field<usrPlainBody> { }
}
protected virtual void _(Events.FieldSelecting<InventoryItem, InventoryItemExt.usrPlainBody> e)
{
var row = e.Row as InventoryItem;
if (row?.Body == null) return;
string text = Regex.Replace(row.Body, "<[^>]+>", string.Empty);
e.ReturnValue = HttpUtility.HtmlDecode(text).Trim();
}
You can refer to this post for the recommended approach to show the Description Body as plain text.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.