• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Dialog Studio Project
#1
Hello,

I added a new table in DB referencing REQUEST_ID from SD_REQUEST as a foreign key. This table was then added to DialogStudio in Project, as the custom field E_BASELINE_LAST_CHANGE.

I want this field to be edited to the users but it only shows the option to be readable.

Is there anything that can be changed so this field turns to editable?

Thank you.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#2
(07-30-2019, 08:41 AM)pms23 Wrote: Hello,

I added a new table in DB referencing REQUEST_ID from SD_REQUEST as a foreign key. This table was then added to DialogStudio in Project, as the custom field E_BASELINE_LAST_CHANGE.

I want this field to be edited to the users but it only shows the option to be readable.

Is there anything that can be changed so this field turns to editable?

Thank you.

Please copy the sql query that you use for referencing (FOREIGN KEY) "E_BASELINE" with SD_REQUEST + script CreateTable of "E_BASELINE"

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#3
(07-30-2019, 09:18 AM)ABBE Philippe Wrote:
(07-30-2019, 08:41 AM)pms23 Wrote: Hello,

I added a new table in DB referencing REQUEST_ID from SD_REQUEST as a foreign key. This table was then added to DialogStudio in Project, as the custom field E_BASELINE_LAST_CHANGE.

I want this field to be edited to the users but it only shows the option to be readable.

Is there anything that can be changed so this field turns to editable?

Thank you.

Please copy the sql query that you use for referencing (FOREIGN KEY) "E_BASELINE" with SD_REQUEST + script CreateTable of "E_BASELINE"

P.ABBE

To create that table, the query used was_

CREATE TABLE [50005].[E_PROJECT_BASELINE](
    [PROJECT_BASELINE_ID] [int] IDENTITY(1,1) NOT NULL,
    [E_BASELINE_LAST_CHANGE] [datetime] NULL,
    FOREIGN KEY (REQUEST_ID) REFERENCES [50005].SD_REQUEST(REQUEST_ID)


Thank you.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.

#4
(07-30-2019, 09:35 AM)pms23 Wrote:
(07-30-2019, 09:18 AM)ABBE Philippe Wrote:
(07-30-2019, 08:41 AM)pms23 Wrote: Hello,

I added a new table in DB referencing REQUEST_ID from SD_REQUEST as a foreign key. This table was then added to DialogStudio in Project, as the custom field E_BASELINE_LAST_CHANGE.

I want this field to be edited to the users but it only shows the option to be readable.

Is there anything that can be changed so this field turns to editable?

Thank you.

Please copy the sql query that you use for referencing (FOREIGN KEY) "E_BASELINE" with SD_REQUEST + script CreateTable of "E_BASELINE"

P.ABBE

To create that table, the query used was_

CREATE TABLE [50005].[E_PROJECT_BASELINE](
    [PROJECT_BASELINE_ID] [int] IDENTITY(1,1) NOT NULL,
    [E_BASELINE_LAST_CHANGE] [datetime] NULL,
    FOREIGN KEY (REQUEST_ID) REFERENCES [50005].SD_REQUEST(REQUEST_ID)


Thank you.

Hello,
You must create a field in SD_REQUEST : E_PROJECT_BASELINE_ID, create the foreign key to E_PROJECT_BASELINE. Then you can edit Dialog and allow to modify E_PROJECT_BASELINE_ID

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#5
(07-31-2019, 03:17 AM)ABBE Philippe Wrote:
(07-30-2019, 09:35 AM)pms23 Wrote:
(07-30-2019, 09:18 AM)ABBE Philippe Wrote:
(07-30-2019, 08:41 AM)pms23 Wrote: Hello,

I added a new table in DB referencing REQUEST_ID from SD_REQUEST as a foreign key. This table was then added to DialogStudio in Project, as the custom field E_BASELINE_LAST_CHANGE.

I want this field to be edited to the users but it only shows the option to be readable.

Is there anything that can be changed so this field turns to editable?

Thank you.

Please copy the sql query that you use for referencing (FOREIGN KEY) "E_BASELINE" with SD_REQUEST + script CreateTable of "E_BASELINE"

P.ABBE

To create that table, the query used was_

CREATE TABLE [50005].[E_PROJECT_BASELINE](
    [PROJECT_BASELINE_ID] [int] IDENTITY(1,1) NOT NULL,
    [E_BASELINE_LAST_CHANGE] [datetime] NULL,
    FOREIGN KEY (REQUEST_ID) REFERENCES [50005].SD_REQUEST(REQUEST_ID)


Thank you.

Hello,
You must create a field in SD_REQUEST : E_PROJECT_BASELINE_ID, create the foreign key to E_PROJECT_BASELINE. Then you can edit Dialog and allow to modify E_PROJECT_BASELINE_ID

P.ABBE

Thank you Abbe.
This did not work. I wanted to store all the changes made to [E_BASELINE_LAST_CHANGE].

I want to show [E_BASELINE_LAST_CHANGE] editable to user and store all the dates changed. Also, present [BASELINE NUMBER] that shows how many times that date was changed.
pms23, proud to be a member of EV CONNECT FORUM since Apr 2017.






Users browsing this thread: 1 Guest(s)