Hello all,

 

Is there a way that I can control what data Creatio binds automatically when I make saves in the section wizard? I'm trying to make edits to an application and Creatio keeps incorrectly binding a section to a workplace not included in that application meaning I have to always remove the binding before doing test installs, otherwise the install fails.

Like 1

Like

5 comments

Hi Kevin,



There is no such option for now.

 

But we've registered it in our R&D team backlog for consideration and implementation in future application releases.

 

Thank you for helping us to improve our product. 

 

Hello,

 

I recommend checking the academy article on Automatic data binding to find more details on how this functionality works. 

Mira Dmitruk,

This link doesn't work.



And I would like to vote for making this functionality optional. We don't transfer Workplaces and binding to our customers - they used to organize workplaces by themselves, so deleting automatic binding is extra headache for us



Kind regards,

Vladimir

Vladimir Sokolov,

 

We are sending you the instructions once again: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platfor…. As you were informed earlier, there is currently no way to control what data Creatio binds automatically when making saves in the section wizard.



However, we have registered this idea to our R&D team backlog for consideration and implementation in future application releases.

 

Any updates on this? Creatio automatically adding dependencies and bindings without asking makes building applications extremely difficult.

Show all comments

Hi, community, 



I'm writing because I need your help. I need to set a page as read-only based on some conditions, but I don’t want to do it based on Business Rules (there are way too many fields) or based on Business Processes because we would like to avoid modifying permissions.

The best implementation it’s the one described in this post (Set page to ReadOnlyMode | Community Creatio), but we can’t find the package mentioned in it. Do you know where we can find it?

Thanks in advance!

 

Like 1

Like

1 comments

Hello Community!

 

I have an on-prem installation of creatio studio compatibility edition version 8.0.9.

I installed the Customer 360 app and created my custom app in the application hub.

The newly created package is specified in the "CurrentPackageId" system setting

 

Now when I click on the gear icon on eg the contact list from the Customer 360 app, creatio creates a new package with a name in the format App_...in my case, it was "QsApp_oyuwyip".

This package has a special manifest file called app-descriptor-extension.json in the file system, which seems to be used to associate the package with the Customer 360 app and to extend it (the new package can be seen in the "advanced settings" part of the Customer 360 app).

 

I can move the ClientModule to my package and if I change it, then create will update it correctly (and not create a new module in the QsApp_oyuwyip package), but if I change something else (like the account page from the Customer 360 app) it will be stored in the QsApp_oyuwyip package again and I'd have to move it again.

 

This "feature" makes it more difficult to deploy the changes to our customer's system. We are using git and Clio in our CI/CD pipeline, which was built with one package to transfer in mind...

Is there a way to force the system to use my custom app/package to store all changes?

 

Thanks,

Robert

Like 7

Like

5 comments
Best reply

Hello,

 

In order to have the changes saved in the application to the desired package, you need to set it in the "Package in installed application" lookup. After doing this, the changes made to this application will be automatically saved in the package you have selected.

 

This behavior is described in the article on our academy for more detailed.



Thank you for your question.

Hello,

 

In order to have the changes saved in the application to the desired package, you need to set it in the "Package in installed application" lookup. After doing this, the changes made to this application will be automatically saved in the package you have selected.

 

This behavior is described in the article on our academy for more detailed.



Thank you for your question.

Would definitely be a good video, feels like a recurring theme :)

I've been told the issue with random packages being selected for a customization to be saved in (and new packages being created) will be improved greatly over the next few versions. 

However, for now, you can control the package it will be saved in by changing the URL when you open a page for edits and appending the query string parameter &packageUId=[Your package UId]. This will force the editor to save the new version of the page in that package. If you want an easy way to get the package UId, simple click the [Add page] button in your application and copy this from the URL then use to add to the URL the first time you edit an existing Freedom UI page to force it to go into your package. Once the page is added to your package after the first save, you'll no longer need to add this to the URL and it will continue to save it to your package. 

For example, the *first* time you edit a page such as Contacts_FormPage, add this to the URL to force it to save into your package. From then on, editing that page will continue to save it to that package.

Ryan

Ryan Farley,



Great tip 🙂

 

Great to hear there is plan to improve handling of the "auto" packages. Also from the marketplace directly in the application hub (only in dev/test instances) also create new empty packages each time since Creatio 8.1 is also quite confusing 😅. Hope they fix that before pushing the feature into production instances.



In the meantime, it would be great for Creatio to provide official proper guidance and tips to manage this.

Hi guys,

Do you have any recent news regarding this matter? I have a new Project and this occurred to me again.

Regards,
Solem

Show all comments

Hello all,

 

My colleague and I are trying to develop applications with specific dependencies but Creatio keeps adding dependencies we don't want to the package when we save a business process. Is there a way to turn off the automatic adding of dependencies? I'd prefer to receive an error message if I'm using something for which I don't have access.

Like 2

Like

2 comments

I would love to turn this off and have an error telling me what it needs instead. The auto adding dependencies could be nice but I’d prefer to control that myself. I’ve ran into issues where it attempts to add a dependency for the same package that the item is already located in and then complains that it’s a circular dependency. 

Ryan

Not getting the exact same error, but similar behavior: 



modifiying customer 360 list & form pages, getting account new objects, pages etc saved in my current set package, and the contacts saved automatically in a new package of Creatio's choice.... Quite confusing

Show all comments

Hi Community,

 

My instance was developed on Customer Package

I want to create another package. Let's call it A package. To continue our development.

But after I set up the dependencies for A Package, I was unable to config Object from Custom Package

Should I move all elements from Custom Package to my A Package?

Or what else should I do?

Like 0

Like

4 comments

Hello,

 

If you are developing in order to later transfer these changes to a production website (or any other website), it is essential to transfer these elements from the Custom package, as you have different bindings and data, as well as changes made to the objects. If you do not transfer them, the integrity of the development will be compromised, and the package is unlikely to be successfully installed on the target website.

Also, please note that the package must include all the necessary dependencies for these elements to be transferred. If, at the moment you want to move an element, you are missing a dependency, for example, the website will display a message indicating what is specifically missing.

 

Additionally, please familiarize yourself with the documentation:

Packages basics

Delivery in Creatio IDE

Move the functionality between packages

Kalymbet Anastasia,

I understood

I just have a further question.

If, I move all the elements from the Custom Package to my A package on the Development website. Then, I install that package on the Production website. The Production already had a Custom Package with all the same elements as the Development website.

 

Is there any possible error when I install my A Package on the Production site?

Bao Phan,

 

If they are the same elements with the same UId and name, then yes, there may be a conflict during installation.

Kalymbet Anastasia,

So if I create another package (B package) and move all elements from Custom Package to the B package on Production Site.

Then, I continue to develop A Package on the Development site and install it later on the Production Site

Is it possible doing it? Any conflict or error may happen?

Show all comments

As the title says, I'm trying to save the column layout for a custom record section, as well as for Details on the record.

 

https://customerfx.com/article/including-the-default-column-layout-for-…

Using this resource, I haven't managed to save any that will transfer over when installing a new package.

 

I have saved bound a number of records to the SysProfileData within my package, however none of them have had the intended effect.

https://gyazo.com/9c2347d0e5a3d845888edf5c94b221ab

Like 0

Like

2 comments

Hello Oliver,

The method described in the article you mention does work for me (In fact, I just did this yesterday with no issues). 

Make sure that you've first configured the column layout and selected the "save for all users" and that you're selecting the correct row from the SysProfileData table (the one with no user in the "Contact" column.

If it's not working for you, it's likely one of the two issues listed above. 

Ryan

I appreciate the confidence in your article but I have 100% done both of these, about a thousand times, in every way possible.

 

Is this the only known solution/ there are no known issues with this?

Show all comments

Im trying to get the details columns to be saved within a package, does anyone know how to do this?

Like 0

Like

2 comments

Hello Oliver,

I have the details of how to include the default column layout in a package in this article: 

https://customerfx.com/article/including-the-default-column-layout-for-…

Ryan

Is there any better resources? This doesnt seem to be working for me.

Show all comments

https://drive.google.com/file/d/14bXG1fyxZCbehwAVJIHvBv6TdTwKPz0s/view

 

I get this error every time I try to import an application, whats going wrong?

Like 0

Like

7 comments
Best reply

Hello,



Please use the following script:

 

CREATE OR REPLACE FUNCTION "GetInstallPkgInfo"()

    RETURNS TABLE (

        "Product"              VARCHAR(250),

        "ConfigurationVersion" VARCHAR(250),

        "PrimaryCulture"       VARCHAR(250)

    )

AS $$

DECLARE

    Product VARCHAR(250);

    AppName VARCHAR(250) = 'creatio';

    UseAppName BOOL = FALSE;

    ConfigurationVersion VARCHAR(250);

    PrimaryCulture VARCHAR(250);

    SysAdminUnit_AllUsers UUID = 'A29A3BA5-4B0D-DE11-9A51-005056C00008';

    HasBankSales BOOL;

    HasBankCustomerJourney BOOL;

    HasLending BOOL;

    HasMarketing BOOL;

    HasSalesEnterprise BOOL;

    HasSalesCommerce BOOL;

    HasSalesTeam BOOL;

    HasServiceEnterprise BOOL;

    HasCustomerCenter BOOL;

    HasStudio BOOL;

    HasAlmPortal BOOL;

    HasAlmProxy BOOL;

BEGIN

    SELECT

        ssv."TextValue"

    INTO ConfigurationVersion

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    WHERE ss."Code" = 'ConfigurationVersion'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    SELECT

         c."Name"

    INTO PrimaryCulture

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    INNER JOIN "SysCulture" c ON c."Id" = ssv."GuidValue"

    WHERE ss."Code" = 'PrimaryCulture'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    --region check root packages

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankSalesSoftkey%') THEN

        HasBankSales = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankOnboardingSoftkey%') THEN

        HasBankCustomerJourney = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Lending%') THEN

        HasLending = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'MarketingSoftkey%') THEN

        HasMarketing = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesEnterprise') THEN

        HasSalesEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesCommerce') THEN

        HasSalesCommerce = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesTeam') THEN

        HasSalesTeam = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'ServiceEnterpriseSoftkey') THEN

        HasServiceEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'CustomerCenterSoftkey') THEN

        HasCustomerCenter = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Studio%') THEN

        HasStudio = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'Environments') THEN

        HasAlmPortal = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'TeamCityIntegration') THEN

        HasAlmProxy = TRUE;

    END IF;

    --endregion

    SELECT

        CASE

            WHEN HasBankSales AND HasBankCustomerJourney AND HasLending AND HasMarketing

                THEN 'bank sales & bank customer journey & lending & marketing'

            WHEN HasBankSales AND HasBankCustomerJourney

                THEN 'bank sales & bank customer journey'

            WHEN HasSalesEnterprise AND HasMarketing AND HasCustomerCenter

                THEN 'sales enterprise & marketing & customer center'

            WHEN HasSalesEnterprise AND HasMarketing AND HasServiceEnterprise

                THEN 'sales enterprise & marketing & service enterprise'

            WHEN HasSalesCommerce AND HasMarketing AND HasCustomerCenter

                THEN 'sales commerce & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing AND HasCustomerCenter

                THEN 'sales team & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing

                THEN 'sales team & marketing'

            WHEN HasSalesEnterprise

                THEN 'sales enterprise'

            WHEN HasSalesCommerce

                THEN 'sales commerce'

            WHEN HasSalesTeam

                THEN 'sales team'

            WHEN HasMarketing

                THEN 'marketing'

            WHEN HasServiceEnterprise

                THEN 'service enterprise'

            WHEN HasCustomerCenter

                THEN 'customer center'

            WHEN HasAlmPortal

                THEN 'alm studio'

            WHEN HasAlmProxy

                THEN 'alm studio proxy'

            WHEN HasStudio

                THEN 'studio'

            WHEN HasLending

                THEN 'lending'

            WHEN HasBankSales

                THEN 'bank sales'

            WHEN HasBankCustomerJourney

                THEN 'bank customer journey'

            ELSE '?'

        END

    INTO Product;

    IF (UseAppName = TRUE) THEN

        Product = CONCAT(AppName, ' ', Product);

    END IF;

    RETURN QUERY (

        SELECT

            Product              AS "Product",

            ConfigurationVersion AS "Version",

            PrimaryCulture       AS "Culture"

        );

END;

$$ LANGUAGE plpgsql;

SELECT

    "Product",

    "ConfigurationVersion",

    "PrimaryCulture"

FROM "GetInstallPkgInfo"()

Im running the following on the machine im exporting from: Version 8.0.3.2908 Sales enterprise

importing into: Version 8.0.6.3429

 

Does the version need to be the exact same?

Hello Oliver,



What is the bundle of the target website, Sales enterprise as well? 

 



 

Bogdan,

Yeah, Im not sure 100% if the one im exporting from is, but im pretty sure its Sales Enterprise too

 

Is there any way to confirm what version youre running?

Oliver Crowe,

The below SQL script will give the product version.



Note: This is MSSQL and if you use other DBs please update the syntax wherever applicable.

DECLARE @ConfigurationVersion nvarchar(250)
DECLARE @PrimaryCulture nvarchar(250)
DECLARE @Product nvarchar(250)
 
DECLARE @SysAdminUnit_AllUsers uniqueidentifier = 'A29A3BA5-4B0D-DE11-9A51-005056C00008'
 
BEGIN
SELECT  @ConfigurationVersion = TextValue
FROM SysSettingsValue ssv
INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId
WHERE ss.Code = 'ConfigurationVersion' 
	AND SysAdminUnitId = @SysAdminUnit_AllUsers
 
SELECT @PrimaryCulture = c.Name
FROM SysSettingsValue ssv
INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId
INNER JOIN SysCulture c on c.Id = ssv.GuidValue
WHERE ss.Code = 'PrimaryCulture'
	AND SysAdminUnitId = @SysAdminUnit_AllUsers
 
SELECT @Product =
CASE
     WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')
	 THEN 'bpmonline bank sales & bank customer journey & lending & marketing' 
     WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
	 THEN 'bpmonline bank sales & bank customer journey' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')
	 THEN 'bpmonline sales enterprise & marketing & service enterprise' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline sales enterprise & marketing & customer center' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline sales commerce & marketing & customer center' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline sales team & marketing & customer center' 
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')
		AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')
	 THEN 'bpmonline sales team & marketing'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')
	 THEN 'bpmonline sales team'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')
	 THEN 'bpmonline sales commerce'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')
	 THEN 'bpmonline sales enterprise'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name Like 'MarketingSoftkey%')
	 THEN 'bpmonline marketing'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')
	 THEN 'bpmonline customer center'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')
	 THEN 'bpmonline service enterprise'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Studio%')
	 THEN 'bpmonline studio'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')
	 THEN 'bpmonline lending'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')
	 THEN 'bpmonline bank sales'
	 WHEN 
		EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')
	 THEN 'bpmonline bank customer journey'
	 ELSE  '?' END
 
SELECT @Product Product, @ConfigurationVersion Version, @PrimaryCulture Localization
END

 

 

BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

 

Im using PostgreSQL - All MSSQL syntax checkers ive tried also says this syntax is wrong and I cant seem to get anything that will run from this, I cant find any conversions that work manually and ive tried using online converters too

 

None of the syntax works, could you please be more specific in what I can do to get it working

 

If you scrolled slightly further down the page you got that code from you'd have seen me commenting that it doesnt seem to work.

Hello,



Please use the following script:

 

CREATE OR REPLACE FUNCTION "GetInstallPkgInfo"()

    RETURNS TABLE (

        "Product"              VARCHAR(250),

        "ConfigurationVersion" VARCHAR(250),

        "PrimaryCulture"       VARCHAR(250)

    )

AS $$

DECLARE

    Product VARCHAR(250);

    AppName VARCHAR(250) = 'creatio';

    UseAppName BOOL = FALSE;

    ConfigurationVersion VARCHAR(250);

    PrimaryCulture VARCHAR(250);

    SysAdminUnit_AllUsers UUID = 'A29A3BA5-4B0D-DE11-9A51-005056C00008';

    HasBankSales BOOL;

    HasBankCustomerJourney BOOL;

    HasLending BOOL;

    HasMarketing BOOL;

    HasSalesEnterprise BOOL;

    HasSalesCommerce BOOL;

    HasSalesTeam BOOL;

    HasServiceEnterprise BOOL;

    HasCustomerCenter BOOL;

    HasStudio BOOL;

    HasAlmPortal BOOL;

    HasAlmProxy BOOL;

BEGIN

    SELECT

        ssv."TextValue"

    INTO ConfigurationVersion

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    WHERE ss."Code" = 'ConfigurationVersion'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    SELECT

         c."Name"

    INTO PrimaryCulture

    FROM "SysSettingsValue" ssv

    INNER JOIN "SysSettings" ss ON ss."Id" = ssv."SysSettingsId"

    INNER JOIN "SysCulture" c ON c."Id" = ssv."GuidValue"

    WHERE ss."Code" = 'PrimaryCulture'

        AND ssv."SysAdminUnitId" = SysAdminUnit_AllUsers;

    --region check root packages

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankSalesSoftkey%') THEN

        HasBankSales = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'BankOnboardingSoftkey%') THEN

        HasBankCustomerJourney = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Lending%') THEN

        HasLending = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'MarketingSoftkey%') THEN

        HasMarketing = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesEnterprise') THEN

        HasSalesEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesCommerce') THEN

        HasSalesCommerce = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'SalesTeam') THEN

        HasSalesTeam = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'ServiceEnterpriseSoftkey') THEN

        HasServiceEnterprise = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'CustomerCenterSoftkey') THEN

        HasCustomerCenter = TRUE;

    END IF;

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" LIKE 'Studio%') THEN

        HasStudio = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'Environments') THEN

        HasAlmPortal = TRUE;

    END IF;

    

    IF EXISTS (SELECT 1 FROM "SysPackage" WHERE "Name" = 'TeamCityIntegration') THEN

        HasAlmProxy = TRUE;

    END IF;

    --endregion

    SELECT

        CASE

            WHEN HasBankSales AND HasBankCustomerJourney AND HasLending AND HasMarketing

                THEN 'bank sales & bank customer journey & lending & marketing'

            WHEN HasBankSales AND HasBankCustomerJourney

                THEN 'bank sales & bank customer journey'

            WHEN HasSalesEnterprise AND HasMarketing AND HasCustomerCenter

                THEN 'sales enterprise & marketing & customer center'

            WHEN HasSalesEnterprise AND HasMarketing AND HasServiceEnterprise

                THEN 'sales enterprise & marketing & service enterprise'

            WHEN HasSalesCommerce AND HasMarketing AND HasCustomerCenter

                THEN 'sales commerce & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing AND HasCustomerCenter

                THEN 'sales team & marketing & customer center'

            WHEN HasSalesTeam AND HasMarketing

                THEN 'sales team & marketing'

            WHEN HasSalesEnterprise

                THEN 'sales enterprise'

            WHEN HasSalesCommerce

                THEN 'sales commerce'

            WHEN HasSalesTeam

                THEN 'sales team'

            WHEN HasMarketing

                THEN 'marketing'

            WHEN HasServiceEnterprise

                THEN 'service enterprise'

            WHEN HasCustomerCenter

                THEN 'customer center'

            WHEN HasAlmPortal

                THEN 'alm studio'

            WHEN HasAlmProxy

                THEN 'alm studio proxy'

            WHEN HasStudio

                THEN 'studio'

            WHEN HasLending

                THEN 'lending'

            WHEN HasBankSales

                THEN 'bank sales'

            WHEN HasBankCustomerJourney

                THEN 'bank customer journey'

            ELSE '?'

        END

    INTO Product;

    IF (UseAppName = TRUE) THEN

        Product = CONCAT(AppName, ' ', Product);

    END IF;

    RETURN QUERY (

        SELECT

            Product              AS "Product",

            ConfigurationVersion AS "Version",

            PrimaryCulture       AS "Culture"

        );

END;

$$ LANGUAGE plpgsql;

SELECT

    "Product",

    "ConfigurationVersion",

    "PrimaryCulture"

FROM "GetInstallPkgInfo"()

Cherednichenko Nikita,

 

This is the best solution for PostgreSQL, thanks!

Show all comments

Im trying to transfer a package from one enviroment to another, but get an error saying it cant find the dependent package, when i try remove any dependencies from the package before exporting it, I get a long error, any suggestions?

Like 0

Like

1 comments

Hello,

 

Please refer to the instructions in the Academy articles below that explain the package dependencies and data binding in the system:

Bind data to a package

Package dependencies and hierarchy

Define the package dependencies

Show all comments

Hi community!

I want to move object from custom package to another package, let's call it X package. The problem is that when I set X package as default package my process do not see one field I want to use from that object. The object is added to both packages X and custom. The field I need is added to the object in custom package. I tried to move the object from custom to X package, but got error that X package already has that object. Any suggestions?

Like 0

Like

2 comments

Hey, there are two possible solutions that I can think of off the top of my head:

 

1. Create the field manually using code in the desired package and later delete the schemas from the Custom package. (This is less recommended).

 

2. Create a 3rd package, let's call it Y package, navigate to the dependencies of the X package and add a dependency to the Y package, move the files from the Custom package to Y package.

 

This should solve the issue for you as the field will be available in the Y package, and because X depends on it, it'll also be available there and thus it should work.

 

I hope this helps!

Edo Sagron,

thanks, will try!

Show all comments