Skip to main content
Solved

Site URL stored in database?

  • July 20, 2023
  • 3 replies
  • 179 views
  • Translate All

hayleehicks
Varsity I
Forum|alt.badge.img+1

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) { }
}
}
}

 

View original

3 replies

dcomerford
Captain II
Forum|alt.badge.img+16

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

Translate

Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+4

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) { }
}
}
}

 

Translate

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

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

Translate