Skip to main content
Solved

Site URL stored in database?

  • July 20, 2023
  • 3 replies
  • 129 views

hayleehicks
Varsity I
Forum|alt.badge.img

Does anyone know of a table/datafield that stores the site URL? I’m trying to feed parameters into a GI navigation link and have it be transferable across multiple sites without needing to update the URL on each site. Thanks!

Best answer by Zoltan Febert

You can use an unbound field, here I added it to the SOOrder table:

using PX.Data;
using PX.Data.Update;
using PX.Objects.SO;

namespace PX.Objects
{
// Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active
public class SOOrderSiteURLExt : PXCacheExtension<SOOrder>
{
#region UsrSiteURL
[PXString(255)]
[PXUIField(DisplayName="Site URL")]
[PXUnboundDefault(typeof(SiteURLConstant), PersistingCheck = PXPersistingCheck.Nothing)]
public virtual string UsrSiteURL { get; set; }
public abstract class usrSiteURL : PX.Data.BQL.BqlString.Field<usrSiteURL> { }
#endregion

public class SiteURLConstant : PX.Data.BQL.BqlString.Constant<SiteURLConstant>
{
public SiteURLConstant() : base(PXInstanceHelper.HostName) { }
}
}
}

 

3 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • July 20, 2023

I dont believe it is held in any table but done through the IIS. You could always add a field to the Company table to store the URL and do it that way


Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • Answer
  • July 20, 2023

You can use an unbound field, here I added it to the SOOrder table:

using PX.Data;
using PX.Data.Update;
using PX.Objects.SO;

namespace PX.Objects
{
// Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active
public class SOOrderSiteURLExt : PXCacheExtension<SOOrder>
{
#region UsrSiteURL
[PXString(255)]
[PXUIField(DisplayName="Site URL")]
[PXUnboundDefault(typeof(SiteURLConstant), PersistingCheck = PXPersistingCheck.Nothing)]
public virtual string UsrSiteURL { get; set; }
public abstract class usrSiteURL : PX.Data.BQL.BqlString.Field<usrSiteURL> { }
#endregion

public class SiteURLConstant : PX.Data.BQL.BqlString.Constant<SiteURLConstant>
{
public SiteURLConstant() : base(PXInstanceHelper.HostName) { }
}
}
}

 


darylbowman
Captain II
Forum|alt.badge.img+15

This won’t work with GIs, but an elegant solution for reports is here.