cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

image widget image path in postgres database

SOLVED
Participant

image widget image path in postgres database

Hi All,

     I currently know how to link the dropdown menu to the label. Now have other problems.

1) How can I store the image local path in the postgresql database?

1) How to link the dropdown menu to the image stored in localhost? Both info are from postgresql database.

2) How to link the dropdown menu to a grid, elements in which are other corresponding columns but not including the selected dropdown value.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: image widget image path in postgres database

First Map the selectedRows-> name to a Label and check its the Building Name Then Map that to the service getDataTableEnrties and pass that name parameter to  getDataTableEnrties service which i think will give you all data and from that map the OutsidePic to Image widget

14 REPLIES 14

Re: image widget image path in postgres database

Tiantian, is Postgresql used as persistence provider or are you connecting to it via the extension as external DB?

I think for your above scenario you can begin by may be creating a table in the DB which will store the path and the file name (file ID) however way you want to refer each entry and then from the platform you'll need a DatabaseThing with SQL service Inserting values. Now as to getting the path you can use the FileSystemServices to get path information for any file which you can pass to your SQL script for storing that in DB

Re: image widget image path in postgres database

To Store image in any database you will need to create a data table on that basis take a datashape which has one field as Imagelink and add assign a media entity to it so then you will be able to see that image in your datatable as well as then you will be able to call it using the key in the same row.

Re: image widget image path in postgres database

I want to store the image path in PostgreSQL database like this, my column name is, OutsidePic

WeChat Image_20170525142840.png

Then I select the building name, at the same time, want to OutsidePic to change accordingly, like this:

WeChat Image_20170525142904.png

But failed.

pravin pradhanSushant Pandey

Re: image widget image path in postgres database

This getBuilding service is to the DropDown Or its the service which takes output from dropdown?

Re: image widget image path in postgres database

This getBuilding service is to the DropDown. And the selected Row is binded to the output from dropdown, like the picture path to the SourceURL.

Re: image widget image path in postgres database

But on the selected Name you want the address to come right? if so then you have to bind the selectedRows-> name  to the next service which will have logic to get output. as you are saying getBuilding is service whose all data mapped to Dropdown widget then first you have to get selected Building from same dropdown.

Re: image widget image path in postgres database

First Map the selectedRows-> name to a Label and check its the Building Name Then Map that to the service getDataTableEnrties and pass that name parameter to  getDataTableEnrties service which i think will give you all data and from that map the OutsidePic to Image widget

Re: image widget image path in postgres database

Yes. I should attach the name to the dropdown menu first.

But I just attach the return data to the dropdown menu, then select DisplayField as the Name. This way seems wrong..

another question, if the dropdown selection as input, an grid (another infotable) and other information as output, how can I manage to do this?

Means:

Input: dropdown selection (building name)

Output: Building year, building manager name, and a list(grid) of building lift condition

Highlighted

Re: image widget image path in postgres database

yes you can manage this . as there must be a Datatable for all this in which there are this fields like Name,Address, Building Year, Manager, etc so here name should be primary key on hat basis you can write a query in the service that search data table entries on the basis of name. thats it.